My Oracle Support Banner

Error "ORA-00942: table or view does not exist" Upgrading To WebCenter Content/Imaging 12.2.1.4 (Doc ID 2822289.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle WebCenter Content: Imaging - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

When trying to upgrade WebCenter Content/Imaging to 12.2.1.4, during the execution of the domain reconfiguration, an error occurs that indicates the schema OWC_IPM does not exist.  Yet, it does exist.

FINE [69] com.oracle.<HOST>.<DOMAIN>.jdbc.connection.CustomTableChangeDelegate$TestThread - Datasource: IPM Schema test failed!
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Caused by: Error : 942, Position : 14, Sql = select 1 from schema_version_registry where owner=(select user from dual) and mr_type='IPM' and version='12.2.1.3.0', OriginalSql = select 1 from schema_version_registry where owner=(select user from dual) and mr_type='IPM' and version='12.2.1.3.0', Error Msg = ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)

Changes

 

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
Solution


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