My Oracle Support Banner

Domain reconfig Failing While Upgrading The Environment To 122140 From 122130 (Doc ID 2791353.1)

Last updated on JULY 16, 2021

Applies to:

Oracle WebCenter Sites - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade from Sites 122130 to Sites 122140, schema readiness is successful but domain reconfig is failing
and the following error occurs.


ERROR
=================================================================
2021-07-05 06:26:10,163 FINE [61] com.oracle.cie.domain.gui.jdbc.connection.CustomTableChangeDelegate$TestThread
 - Datasource: OPSS Audit Viewer Schema test failed!
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:765)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1362)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:369)
at com.oracle.cie.domain.jdbc.JDBCConnectionTester.test(JDBCConnectionTester.java:212)
at com.oracle.cie.domain.gui.jdbc.connection.CustomTableChangeDelegate$TestThread.run(CustomTableChangeDelegate.java:251)
Caused by: Error : 942, Position : 23, Sql = select 1 from schema_version_registry where owner=(select user from dual) and
mr_type='IAU_VIEWER' and version like '12.2.1%', OriginalSql = select 1 from schema_version_registry where owner=(select user from dual) and
mr_type='IAU_VIEWER' and version like '12.2.1%', Error Msg = ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
... 14 more

2021-07-05 06:26:11,068 FINE  [62]
com.oracle.cie.domain.gui.jdbc.connection.CustomTableChangeDelegate$TestThread
- COnneciton test info:
com.oracle.cie.domain.jdbc.JDBCConnectionTester@7a647b88

2021-07-05 06:26:11,194 FINE  [62]
com.oracle.cie.domain.gui.jdbc.connection.CustomTableChangeDelegate$TestThread
- Datasource: OPSS Schema test failed!
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4CC8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:229)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)

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
References


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