My Oracle Support Banner

After Database Import Of ODI 11g Repositories Into An Oracle Database, ODI Studio Fails To Connect To The Master Repository Signalling ODI-26130: Could Not Connect To Repository, ODI-10181 and ORA-00942 (Doc ID 1582582.1)

Last updated on MAY 21, 2021

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

After having restored Oracle Data Integrator (ODI) 11g Master and Work Repositories from backups into an Oracle database, ODI Studio fails to connect to the Master Repository with following message:

ODI-26130: Could Not Connect To Repository

The exception stack trace shows:

oracle.odi.core.config.UncategorizedConfigurationException: ODI-10181: Uncategorized configuration exception.
com.sunopsis.dwg.SQLMasterReposException: ORA-00942: table or view does not exist
 at oracle.odi.core.OdiInstance$2.doAction(OdiInstance.java:479)
 at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:186)
 at oracle.odi.core.OdiInstance.loadWorkDataSourceFromSnpConnect(OdiInstance.java:464)
 at oracle.odi.core.OdiInstance.createDataSourceDefinition(OdiInstance.java:382)
 at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:572)
 at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
 at oracle.odi.ui.docking.panes.OdiCnxFactory$1.run(OdiCnxFactory.java:203)
 at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
 at java.lang.Thread.run(Thread.java:662)

Changes

ODI 11g Repositories have been restored from backup using the Oracle imp (import) utility. 

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
Changes
Cause
 1. Check the import logfile created by the imp (import) utility to see if there are any empty tables imported
 2. Check if there are any empty tables in the ODI Master and Work Repository
 3. Total number of ODI Repository objects
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.