Upgrade Assistant Failed For IAU Components with error Caused by: Error : 942, Position : 7535, Sql = CREATE OR REPLACE VIEW JPS_V AS (Doc ID 3066944.1)

Last updated on JANUARY 13, 2025

Applies to:

Symptoms

UA readiness is failing for IAU_Viewer schema with below error
[RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 128] [ecid: db1867cc-762d-496f-9830-ac644c6cfa66-00000002,0] [[
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:527)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:463)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:554)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:270)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:271)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:92)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:971)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1288)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3724)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1427)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3836)

Caused by: Error : 942, Position : 7535, Sql = CREATE OR REPLACE VIEW JPS_V AS
SELECT IAU_COMMON.IAU_COMPONENTTYPE AS ComponentType,
 IAU_COMMON.IAU_MAJORVERSION AS MajorVersion,
 IAU_COMMON.IAU_MINORVERSION AS MinorVersion,
 IAU_COMMON.IAU_INSTANCEID AS InstanceId,
 IAU_COMMON.IAU_HOSTID AS HostId,
 IAU_COMMON.IAU_HOSTNWADDR AS HostNwaddr,
 IAU_COMMON.IAU_MODULEID AS ModuleId,
 IAU_COMMON.IAU_PROCESSID AS ProcessId,
 IAU_COMMON.IAU_ORACLEHOME AS OracleHome,
 IAU_COMMON.IAU_HOMEINSTANCE AS HomeInstance,
 IAU_COMMON.IAU_ECID AS ECID,
 IAU_COMMON.IAU_RID AS RID,
 
 Below error were also observed in log file

  EXCEPTION OIDCOMPONENT synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION IAU_CUSTOM_01 synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION IAU_BASE synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION AUDITREPORTS_PKG synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION WS_POLICYATTACHMENT synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION OWSM_PM_EJB synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION XMLPSERVER synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION SOA_HCFP synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION JPS synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION SOA_B2B synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION OVDCOMPONENT synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION WEBSERVICES synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION AUDITSCHEMA_PKG synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION STS synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION IAU_DISP_NAMES_TL synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION OWSM_AGENT synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION OHSCOMPONENT synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION OAAM synonym missing in PREFIX_IAU_VIEWER schema
  INFO IAU_CUSTOM synonym missing in PREFIX_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.1.0.0 upgrade So this issue will be fixed in 12.2.1.0.0 and later releases
  EXCEPTION WEBCACHECOMPONENT synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION REPORTSSERVERCOMPONENT synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION DIP synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION ADMINSERVER synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION LIST_OF_COMPONENTS synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION OIF synonym missing in PREFIX_IAU_VIEWER schema
  INFO IAU_AUDITSERVICE synonym missing in PREFIX_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.1.0.0 upgrade So this issue will be fixed in 12.2.1.0.0 and later releases
  EXCEPTION ATTRIBUTE_VALUE_PAIRS synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION LIST_OF_EVENTS synonym missing in PREFIX_IAU_VIEWER schema
  EXCEPTION IAU_LOCALE_MAP_TL synonym missing in PREFIX_IAU_VIEWER schema
  INFO IAU_USERSESSION synonym missing in PREFIX_IAU_VIEWER schema. This maybe caused by a known issue, anyway, this missing synonym will be added in 12.2.1.0.0 upgrade So this issue will be fixed in 12.2.1.0.0 and later releases

Cause

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