ORA-00942 When Importing Upgraded MDL Into Warehouse Builder 11.2
Last updated on MAY 09, 2017
Applies to:Oracle Warehouse Builder - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 28-Jan-2013***
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:
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 .
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