ORA-00942 When Importing Upgraded MDL Into Warehouse Builder 11.2 (Doc ID 976124.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

***Checked for relevance on 28-Jan-2013***

Symptoms

When using the Warehouse Builder 11.2 Repository Assistant to upgrade a Repository from a previous version using the steps outlined in Section 6 of the OWB 11.2 Installation and Upgrade Guide, you can receive a fatal pop-up error like:

SQLException
Persistent Layer Error:SQL Exception..
Class Name: CMPPersist.
Method Name: queryObjNameInfo.
Persistent Layer Error Message: ORA-00942: table or view does not exist
SELECT elementid, classname, name, logicalname, uoid, classname, notm,
editable, customerrenamable, customerdeletable, seeded, UpdateTimestamp,
strongTypeName, aggregatedSignature, iconObject from CMPInstallation_V .

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