My Oracle Support Banner

"ORA-00942: table or view does not exist" Error When Opening a Saved List in ODI (Doc ID 2574429.1)

Last updated on SEPTEMBER 23, 2020

Applies to:

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

Symptoms

When the database user of the Oracle Data Integrator (ODI) work repository is different from the database user of the master repository, loading a list of objects in the "Export Multiple Objects" window results in an ODI-26184 error.

ODI-26184: SQL error occurred. See error details for more information. 
com.sunopsis.dwg.SQLMasterReposException: 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) 
  ...

To reproduce:

  1. Create ODI Master Repository (Sample schema owner: ODI_Master) with ODI Studio.
  2. Create ODI Work Repository (Sample schema owner: ODI_Work) with ODI Studio.
  3. Create a scenario.
  4. Select "Export" and underneath, "Export Multiple Objects"
  5. Drag and Drop the scenario to the "Drag and drop objects into the list to export them" panel.
  6. Press "Save export list" icon. and save it.
  7. Close "Export Multiple Objects" window
  8. Reopen "Export Multiple Objects" window
  9. Press "Load a list of objects..." icon. and then, open the saved list from step 6.
  10. The ODI-26184 and ORA-00942 errors occur.

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.