Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2898

JDBC import wizard (update) stops after importing 1 database of 3

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 10.1
    • Fix Version/s: Future
    • Component/s: Import/Export
    • Labels:
      None
    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Update each of the 3 databases one by one using the JDBC (default) schema processor

      Show
      Update each of the 3 databases one by one using the JDBC (default) schema processor

      Description

      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)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                gadeyne.bram Bram Gadeyne
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: