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:

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

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