1 Reply Latest reply on Mar 3, 2010 5:24 PM by Barry LaFond

    Error when executing 'Preview Data' in Teiid Designer

    Blaine Mincey Newbie

      My environment is as follows:

      Fedora 12 32-bit

      Sun JVM 1.6.0_18

      JBDS 3.0.0.CR1

      Teiid Designer 6.3

       

      I created a sample Model Project.  I have imported "Metadata from JDBC Database" from a MySQL and a Postgres database successfully.  Unfortunately, when I select a table to enable the "Preview Data" button and then click the "Preview Data" button, I get a pop-up window with "Error occurred during execution, Error trying to execute a statement select * from MMX_EUCUSTOMERS_POSTGRES.Customer."

       

      In the Message Log in JBDS/Designer, it indicates the org.teiid.designer.dqp.ui plug-in and the following stack trace:

      com.metamatrix.jdbc.MMSQLException: Error trying to execute a statement select * from MMX_EUCUSTOMERS_POSTGRES.Customer.
           at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:116)
           at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:414)
           at com.metamatrix.jdbc.MMPreparedStatement.executeQuery(MMPreparedStatement.java:210)
           at com.metamatrix.modeler.dqp.ui.workspace.WorkspaceExecutor.executeSQL(WorkspaceExecutor.java:200)
           at com.metamatrix.modeler.internal.dqp.ui.actions.PreviewTableDataContextAction$1QueryExecutor.run(PreviewTableDataContextAction.java:279)
           at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
      Caused by: com.metamatrix.jdbc.MMSQLException: The specified session ID "0" is invalid. It cannot be found in the userbase.
           at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:123)
           at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:71)
           at com.metamatrix.jdbc.MMStatement.sendRequestMessageAndWait(MMStatement.java:855)
           at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:410)
           ... 4 more
      Caused by: [MetaMatrixComponentException]The specified session ID "0" is invalid. It cannot be found in the userbase.
      1 [InvalidSessionException]The specified session ID "0" is invalid. It cannot be found in the userbase.
           at com.metamatrix.client.ExceptionUtil.convertException(ExceptionUtil.java:59)
           at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:119)
           at $Proxy24.executeRequest(Unknown Source)
           at com.metamatrix.jdbc.MMStatement.sendRequestMessageAndWait(MMStatement.java:853)
           ... 5 more
      Caused by: [InvalidSessionException]The specified session ID "0" is invalid. It cannot be found in the userbase.
           at com.metamatrix.platform.security.session.service.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:295)
           at com.metamatrix.platform.security.session.service.SessionServiceImpl.validateSession(SessionServiceImpl.java:287)
           at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:109)
           ... 7 more
      

       

       

      I had some issues with getting Teiid Designer to work in JBDS so it is quite possible I corrupted something along the way.

       

      Thanks for the help.

       

      Blaine