My Oracle Support Banner

Oracle Analytics: Error During Upgrade Assistance Readiness Check For PREFIX_OPSS And PREFIX_IAU Schemas on Amazon RDS (Doc ID 2390047.1)

Last updated on AUGUST 02, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.1.0 and later
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms

While preparing for an upgrade from OBIEE 12.2.1.1.0 To 12.2.1.3.0 you experience errors with these schemas; PREFIX_OPSS and PREFIX_IAU Schemas when doing the readiness check

During the Readiness check the below types of errors could be seen:

  Completed schema test: PRIVILEGES_TEST --> Test that the audit schema has appropriate system and object privileges +++ FAIL
  Starting schema test:  SEQUENCE_TEST  Test that the audit schema sequence and its properties are valid
  Completed schema test: SEQUENCE_TEST --> Test that the audit schema sequence and its properties are valid +++ PASS
  Starting schema test:  SYNONYMS_TEST  Test that the audit schema required synonyms are present
  Completed schema test: SYNONYMS_TEST --> Test that the audit schema required synonyms are present +++ PASS
  Finished readiness check of Oracle Audit Services with status: FAILURE.

This is with  Amazon RDS

Changes

 Upgrading from OBIEE 12.2.1.1 to 12.2.1.X

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.