JDBC import wizard (update) stops after importing 1 database of 3 ----------------------------------------------------------------- Key: TEIIDDES-2898 URL: https://issues.jboss.org/browse/TEIIDDES-2898 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 10.1 Reporter: Bram Gadeyne Assignee: Barry LaFond Priority: Critical Fix For: Future I'm trying to update an xmi file that contains tables from 3 databases on one server. Teiiddesigner is connected to the teiid server. Step 1: select connection + sybase metadata processor (using the jtds driver) Step 2: select table types SYSTEM TABLE, TABLE and VIEW Step 3: deselect 1 of the selected databases (AUDITARCHIVE), select 3 times dbo from required databases (Department, Patient, System) Step 4: Select model to update, deselect include cost statistics, deselect auto create data source. In second tab select "Use fully qualified Names" When I click next now the wizard starts to read the database. It indicates that it is reading table x of 13xx. It starts of with database Department. When it reaches 101 objects it stops. I think this is when it starts reading one of the other databases. Prior to the start of this reading process there is an exception stack trace in the logs. While reading the database there is however no indication of an error. The 101 objects are indicated as new and all other objects are indicated as removed (however most should be updates). This is the stack trace prior to clicking next after step 4. It mentions AUDITARCHIVE which I've deslected. !ENTRY org.teiid.designer.jdbc 2 0 2016-08-17 10:12:04.983 !MESSAGE Unexpected exception while calling net.sourceforge.jtds.jdbc.JtdsDatabaseMetaData.getTableTypes() and processing results on DatabaseIZISprod !STACK 0 java.sql.SQLException: Server user id 1227 is not a valid user in database 'AUDITARCHIVE' at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1032) at net.sourceforge.jtds.jdbc.JtdsDatabaseMetaData.getTables(JtdsDatabaseMetaData.java:1836) at org.teiid.designer.jdbc.metadata.impl.JdbcTableTypeImpl.computeChildren(JdbcTableTypeImpl.java:58) at org.teiid.designer.jdbc.metadata.impl.JdbcNodeImpl.getChildren(JdbcNodeImpl.java:197) at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.updateCounts(JdbcImportObjectsPage.java:799) at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.updateCounts(JdbcImportObjectsPage.java:799) at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.updateCounts(JdbcImportObjectsPage.java:799) at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.validatePage(JdbcImportObjectsPage.java:821) at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.refresh(JdbcImportObjectsPage.java:555) at org.teiid.designer.jdbc.ui.wizards.JdbcImportObjectsPage.setVisible(JdbcImportObjectsPage.java:454) at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1229) at org.eclipse.jface.wizard.WizardDialog.access$4(WizardDialog.java:1208) at org.eclipse.jface.wizard.WizardDialog$8.run(WizardDialog.java:1197) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70) at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1194) at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:885) at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:425) at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:619) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4362) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1113) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4180) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3769) at org.eclipse.jface.window.Window.runEventLoop(Window.java:827) at org.eclipse.jface.window.Window.open(Window.java:803) at org.eclipse.ui.internal.handlers.WizardHandler$Import.executeHandler(WizardHandler.java:158) at org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:290) at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:295) at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56) at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:252) at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:234) at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132) at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:152) at org.eclipse.core.commands.Command.executeWithChecks(Command.java:493) at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:486) at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:210) at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:343) at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:160) at org.eclipse.ui.internal.actions.CommandAction.run(CommandAction.java:175) at org.eclipse.ui.actions.ImportResourcesAction.run(ImportResourcesAction.java:99) at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:170) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:595) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:511) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:420) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84) at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4362) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1113) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4180) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3769) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337) at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018) at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156) at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:694) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:606) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:139) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608) at org.eclipse.equinox.launcher.Main.run(Main.java:1515)