My Oracle Support Banner

ORA-00942 Received When Renumbering an ODI 12c Execution-type Work Repository (Doc ID 2621708.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

The following error is received when attempting to renumber an Execution-type Work Repository that has been upgraded from Oracle Data Integrator (ODI) 11g to 12c in compatibility mode:

java.lang.RuntimeException: com.sunopsis.dwg.SQLWorkReposException: ORA-00942: table or view does not exist
  at oracle.odi.ui.framework.adapter.DefaultAdapter.executeBackgroundTask(DefaultAdapter.java:636)
  at oracle.odi.ui.framework.UIFramework.executeBackgroundTask(UIFramework.java:452)
  at com.sunopsis.graphical.dialog.SnpsDialogRenumberId.dialogOkActionHook(SnpsDialogRenumberId.java:65)
  at com.sunopsis.graphical.definition.DialogDefinitionNode$1.vetoableChange(DialogDefinitionNode.java:416)
  at java.beans.VetoableChangeSupport.fireVetoableChange(VetoableChangeSupport.java:375)
  at java.beans.VetoableChangeSupport.fireVetoableChange(VetoableChangeSupport.java:271)
  at ...

Caused by: com.sunopsis.dwg.SQLWorkReposException: ORA-00942: table or view does not exist
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
  at ...

  Caused by: Error : 942, Position : 552, Sql = Select ALIAS_LENGTH, BEG_VERSION, COD_MOD, DEF_ACTION_GRP, EXT_VERSION, FIRST_DATE, FIRST_USER, GLOBAL_ID, IND_CHANGE, IND_EVO_JDBC, IND_JRN_METHOD, INT_VERSION, I_DEF_FOLDER, I_GENERIC_MODEL, I_MOD, I_MOD_FOLDER, I_TRT_KCM, I_TRT_KDM, I_TRT_KJM, I_TRT_SKM, I_TXT_MOD, LAGENT_NAME, LAST_DATE, LAST_USER, LSCHEMA_NAME, MOD_NAME, PRV_VERSION, RELEASE_TAG, REV_ALIAS_LTRIM, REV_CONTEXT, REV_INSERT, REV_OBJ_PATT, REV_OBJ_TYPE, REV_TYPE, REV_UPDATE, TECH_INT_NAME, V_LAST_DATE, WS_DATA_SOURCE, WS_JAVA_PACKAGE, WS_LSCHEMA_NAME, WS_NAME, WS_NAME_SPACE from SNP_MODEL where SNP_MODEL.I_MOD=:1 , OriginalSql = Select ALIAS_LENGTH, BEG_VERSION, COD_MOD, DEF_ACTION_GRP, EXT_VERSION, FIRST_DATE, FIRST_USER, GLOBAL_ID, IND_CHANGE, IND_EVO_JDBC, IND_JRN_METHOD, INT_VERSION, I_DEF_FOLDER, I_GENERIC_MODEL, I_MOD, I_MOD_FOLDER, I_TRT_KCM, I_TRT_KDM, I_TRT_KJM, I_TRT_SKM, I_TXT_MOD, LAGENT_NAME, LAST_DATE, LAST_USER, LSCHEMA_NAME, MOD_NAME, PRV_VERSION, RELEASE_TAG, REV_ALIAS_LTRIM, REV_CONTEXT, REV_INSERT, REV_OBJ_PATT, REV_OBJ_TYPE, REV_TYPE, REV_UPDATE, TECH_INT_NAME, V_LAST_DATE, WS_DATA_SOURCE, WS_JAVA_PACKAGE, WS_LSCHEMA_NAME, WS_NAME, WS_NAME_SPACE from SNP_MODEL where SNP_MODEL.I_MOD=?, Error Msg = ORA-00942: table or view does not exist
...

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.