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

    • Bug
    • Status: Resolved (View Workflow)
    • Critical
    • Resolution: Won't Do
    • 10.1
    • Future
    • Import/Export
    • None
    • Workaround Exists
    • 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)

      Attachments

        Activity

          People

            blafond Barry LaFond
            gadeynebram Bram Gadeyne (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: