Exception In JDBC Importer Because Of An Invalid Database User
--------------------------------------------------------------
Key: TEIIDDES-180
URL:
https://jira.jboss.org/jira/browse/TEIIDDES-180
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 6.0.0
Environment: Ubuntu 8.04
Reporter: Dan Florian
Running the "E2E Procedure Relational Mapping Test Script" I got the below
exception after hitting "Next" in the JDBC import wizard's "Select
Database Metadata" screen. The exception only appeared in the log and did not affect
the test other than possibly making me manually select the correct database objects.
!MESSAGE Unexpected exception while calling
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTableTypes() and processing
results on DatabaseAdventureWorks2000
!STACK 0
com.microsoft.sqlserver.jdbc.SQLServerException: Server user 'mmds' is not a valid
user in database 'ACBIS'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:39)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(SQLServerConnection.java:1457)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(SQLServerConnection.java:1462)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.setCatalog(SQLServerConnection.java:1767)
at
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.switchCatalogs(SQLServerDatabaseMetaData.java:313)
at
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:264)
at
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:291)
at
com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:441)
at
com.metamatrix.modeler.jdbc.metadata.impl.JdbcTableTypeImpl.computeChildren(JdbcTableTypeImpl.java:54)
at
com.metamatrix.modeler.jdbc.metadata.impl.JdbcNodeImpl.getChildren(JdbcNodeImpl.java:185)
at
com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportObjectsPage.updateCounts(JdbcImportObjectsPage.java:595)
at
com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportObjectsPage.updateCounts(JdbcImportObjectsPage.java:595)
at
com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportObjectsPage.updateCounts(JdbcImportObjectsPage.java:595)
at
com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportObjectsPage.validatePage(JdbcImportObjectsPage.java:616)
at
com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:406)
at
com.metamatrix.modeler.internal.jdbc.ui.wizards.JdbcImportObjectsPage.setVisible(JdbcImportObjectsPage.java:307)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira