Error "ORA-00942: table or view does not exist" Upgrading To WebCenter Content/Imaging 18.104.22.168
(Doc ID 2822289.1)
Last updated on JANUARY 03, 2023
Applies to:Oracle WebCenter Content: Imaging - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
When trying to upgrade WebCenter Content/Imaging to 126.96.36.199, during the execution of the domain reconfiguration, an error occurs that indicates the schema OWC_IPM does not exist. Yet, it does exist.
FINE  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='188.8.131.52.0', OriginalSql = select 1 from schema_version_registry where owner=(select user from dual) and mr_type='IPM' and version='184.108.40.206.0', Error Msg = ORA-00942: table or view does not exist
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