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

Last updated on APRIL 03, 2023

Applies to:

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

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