Error when executing 'Preview Data' in Teiid Designer
bmincey Mar 3, 2010 4:35 PMMy 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