My Oracle Support Banner

OPSS - Pre-upgrade Readiness Check Failed For FMW Product Upgrade from 11.1.1.9 To 12c - Schema is Missing a Required Table: JPS_ENTITY_LOCK -Completed Schema Test: SEQUENCE_TEST --> +++ FAIL (Doc ID 2876954.1)

Last updated on MARCH 01, 2023

Applies to:

Oracle Platform Security for Java - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Message reported running pre-upgrade readiness check utility as part of a FMW product upgrade process:

/ua -readiness

The error was checking the OPSS schema. Here is part of the au.log file:

..
..
[2022-06-07T16:07:03.<TID>1-04:00] [OPSS] [NOTIFICATION] [] [upgrade.OPSS.OPSS_SCHEMA_PLUGIN] [tid: <TID>] [ecid: <ECID>] List of database TABLE objects for user: <[PREFIX>_OPSS
[2022-06-07T16:07:04.<TID>9-04:00] [OPSS] [NOTIFICATION] [] [upgrade.OPSS.OPSS_SCHEMA_PLUGIN] [tid: <TID>] [ecid: <ECID>] EXCEPTION Schema is missing a required table: JPS_ENTITY_LOCK
[2022-06-07T16:07:04.500-04:00] [OPSS] [NOTIFICATION] [] [upgrade.OPSS.OPSS_SCHEMA_PLUGIN] [tid: <TID>] [ecid: <ECID>] Completed schema test: TEST_REQUIRED_TABLES --> Test that the schema contains all the required tables +++ FAIL
..
..
[2022-06-07T16:08:32.882-04:00] [OPSS] [NOTIFICATION] [] [upgrade.OPSS.OPSS_SCHEMA_PLUGIN] [tid: <TID>] [ecid: <ECID>] Completed schema test: SEQUENCE_TEST --> Test that the Oracle Platform Security Services schema sequence and its properties are valid +++ FAIL
[2022-06-07T16:08:32.883-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: <TID>] [ecid: <ECID>] Finished readiness check of Oracle Platform Security Services with status: FAILURE.
..
..

 

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
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.