"invalid table name" Or "java.lang.NumberFormatException: null" Signalled When Smart Importing A Scenario Which Has BreakPoints Into ODI 12c

(Doc ID 2228499.1)

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 to 12.2.1.2.6 [Release 12c]
Information in this document applies to any platform.

Symptoms

The smart import of Scenarios with Break Points fails in Oracle Data Integrator (ODI) 12c, and one of the following messages is received:

java.lang.RuntimeException: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.dwg.SQLWorkReposException: ORA-00903: invalid table name

  at oracle.odi.ui.framework.adapter.DefaultAdapter.executeBackgroundTask(DefaultAdapter.java:636)
  at oracle.odi.ui.framework.UIFramework.executeBackgroundTask(UIFramework.java:452)
  at oracle.odi.ui.smartie.imp.ImportSmartWizardPageIssuesTreeTableModel.runIssueDetection(ImportSmartWizardPageIssuesTreeTableModel.java:655)
  at oracle.odi.ui.smartie.imp.ImportSmartWizardPageIssuesTreeTableModel.setRoot(ImportSmartWizardPageIssuesTreeTableModel.java:522)
  at oracle.odi.ui.smartie.imp.ImportSmartWizardPageIssuesTreeTable.setRoot(ImportSmartWizardPageIssuesTreeTable.java:446)
  at oracle.odi.ui.smartie.imp.ImportSmartWizardPageIssuesPanel.setRoot(ImportSmartWizardPageIssuesPanel.java:155)
  at oracle.odi.ui.smartie.imp.ImportSmartWizardPageIssues.initialize(ImportSmartWizardPageIssues.java:62)
  at oracle.odi.ui.smartie.imp.ImportSmartWizard.initializeIssuesPage(ImportSmartWizard.java:133)
  at ...
Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.dwg.SQLWorkReposException: ORA-00903: invalid table name
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2941)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalIssueDetectionForChildFCOs(IssueDetectionEngine.java:2957)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.doIssueDetectionForSmartImportObject(IssueDetectionEngine.java:3004)
  at com.sunopsis.dwg.smartie.SmartImportManager.getSmartImportHierarchy(SmartImportManager.java:2564)
  at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.internalGetSmartImportHierarchy(ISmartImportInstanceImpl.java:198)
  at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.access$100(ISmartImportInstanceImpl.java:68)
  at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl$1.doAction(ISmartImportInstanceImpl.java:248)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
  at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)
  at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.getSmartImportHierarchy(ISmartImportInstanceImpl.java:243)
  at oracle.odi.ui.smartie.imp.ImportSmartWizardPageIssuesTreeTableModel$1.doInBackground(ImportSmartWizardPageIssuesTreeTableModel.java:624)
  at oracle.odi.ui.smartie.imp.ImportSmartWizardPageIssuesTreeTableModel$1.doInBackground(ImportSmartWizardPageIssuesTreeTableModel.java:582)
  at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
  at java.lang.Thread.run(Thread.java:745)
Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.dwg.SQLWorkReposException: ORA-00903: invalid table name
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2941)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2928)
  ... 14 more
Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.dwg.SQLWorkReposException: ORA-00903: invalid table name
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2941)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2928)
  ... 15 more
Caused by: com.sunopsis.dwg.SQLWorkReposException: ORA-00903: invalid table name
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
  at ...

  == or ==

java.lang.RuntimeException: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: java.lang.NumberFormatException: null
  at oracle.odi.ui.framework.adapter.DefaultAdapter.executeBackgroundTask(DefaultAdapter.java:636)
  at oracle.odi.ui.framework.UIFramework.executeBackgroundTask(UIFramework.java:452)
  at ...
Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: java.lang.NumberFormatException: null
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2945)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalIssueDetectionForChildFCOs(IssueDetectionEngine.java:2961)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.doIssueDetectionForSmartImportObject(IssueDetectionEngine.java:3008)
  at com.sunopsis.dwg.smartie.SmartImportManager.getSmartImportHierarchy(SmartImportManager.java:2564)
  at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.internalGetSmartImportHierarchy(ISmartImportInstanceImpl.java:198)
  at...
Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: java.lang.NumberFormatException: null
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2945)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2932)
  ... 14 more
Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: java.lang.NumberFormatException: null
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2945)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2932)
  ... 15 more
Caused by: java.lang.NumberFormatException: null
  at java.lang.Integer.parseInt(Integer.java:542)
  at java.lang.Integer.valueOf(Integer.java:766)
  at com.sunopsis.dwg.smartie.SmartImportUtil.getSnpReferencedObject(SmartImportUtil.java:384)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.getSnpReferencedObjectDesc(IssueDetectionEngine.java:975)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.detectIssuesForFK(IssueDetectionEngine.java:1245)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.runFKIssueDetection(IssueDetectionEngine.java:1358)
  at com.sunopsis.dwg.smartie.IssueDetectionEngine.internalRunIssueDetectionForSmartImportObject(IssueDetectionEngine.java:2918)
  ... 16 more

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms