My Oracle Support Banner

Upgrading OIM 11g to 12c (One Hop Upgrade), OPSS Schema Seems Corrupted - Log Error Includes: "JPS-04028: Application with name "cn=SystemPolicy,cn=opssSecurityStore,cn=JPSContext,cn=opssRoot" does not exist." (Doc ID 2887314.1)

Last updated on JANUARY 03, 2024

Applies to:

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

Symptoms

After upgrade from Oracle Identity Manager (OIM) 11.1.2.3 to 12.2.1.4, OPSS schema seems to be corrupted.

Admin server .out file includes:

...<snip>...
<Jul 25, 2022 1:14:15,358 PM CDT> <Warning> <oracle.security.opss.internal.runtime.ServiceContextManagerImpl> <BEA-000000> <Bootstrap services are used by OPSS internally and clients should never need to directly read/write bootstrap credentials. If required, use Wlst or configuration management interfaces.>
oracle.security.jps.service.policystore.PolicyObjectNotFoundException: JPS-04028: Application with name "cn=SystemPolicy,cn=opssSecurityStore,cn=JPSContext,cn=opssRoot" does not exist.
    at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.getObjectCount(JpsDBDataManager.java:6311)
    at oracle.security.jps.internal.policystore.entitymanager.impl.InternalQueryManagerImpl.getObjectCount(InternalQueryManagerImpl.java:2388)
    at oracle.security.jps.az.internal.management.pd.service.GenericPolicyDistributionService.internalGetApplicationPolicyChangeLog(GenericPolicyDistributionService.java:2063)
    at oracle.security.jps.az.internal.management.pd.service.GenericPolicyDistributionService.getApplicationPolicyChangeLog(GenericPolicyDistributionService.java:2023)
    at oracle.security.jps.az.internal.runtime.notifier.PolicyChangeNotifierImpl.isSystemChanged(PolicyChangeNotifierImpl.java:184)
    at oracle.security.jps.az.internal.runtime.notifier.PolicyChangeNotifierImpl.isChanged(PolicyChangeNotifierImpl.java:161)
    at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner.scanSystemPolicy(PolicyChangeScanner.java:341)
    at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner.scan(PolicyChangeScanner.java:294)
    at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner.access$200(PolicyChangeScanner.java:114)
    at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner$ScanTask.run(PolicyChangeScanner.java:246)
    at javax.enterprise.concurrent.ManagedExecutors$RunnableAdapter.run(ManagedExecutors.java:211)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at weblogic.work.concurrent.TaskWrapper.call(TaskWrapper.java:151)
    at weblogic.work.concurrent.future.AbstractFutureImpl.runTask(AbstractFutureImpl.java:391)
    at weblogic.work.concurrent.future.AbstractFutureImpl.doRun(AbstractFutureImpl.java:436)
    at weblogic.work.concurrent.future.ManagedScheduledFutureImpl.timerExpired(ManagedScheduledFutureImpl.java:86)
    at weblogic.work.concurrent.future.ManagedPeriodFutureImpl.timerExpired(ManagedPeriodFutureImpl.java:97)
    at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:301)
    at weblogic.work.concurrent.future.ManagedScheduledFutureImpl.run(ManagedScheduledFutureImpl.java:96)
    at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
    at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
    at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
    at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
    at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
<Jul 25, 2022 1:23:21,087 PM CDT> <Warning> <oracle.jps.authorization> <JPS-04080> <Scanning of system policy failed. Reason oracle.security.jps.service.policystore.PolicyObjectNotFoundException: JPS-04028: Application with name "cn=SystemPolicy,cn=opssSecurityStore,cn=JPSContext,cn=opssRoot" does not exist.>
<Jul 25, 2022 1:23:21,484 PM CDT> <Warning> <oracle.jps.authorization> <JPS-04155> <Scanning of application policy failed. Reason {0}
oracle.security.jps.service.policystore.PolicyStoreRuntimeException: JPS-04006: No results found for given Application Name:b2bui, DN: cn=<CN>,cn=opssSecurityStore,cn=JPSContext,cn=opssRoot, Query: BaseSearchQuery: [Negation:false
IsORMatch:false
IsComplexQuery:true
Num ChildQueries:1
Non-paginated search.

EntryType:APPLICATION
ComparatorType:null

...<etc>...

<Jul 25, 2022 1:33:21,499 PM CDT> <Warning> <oracle.jps.authorization> <JPS-04080> <Scanning of system policy failed. Reason oracle.security.jps.service.policystore.PolicyObjectNotFoundException: JPS-04028: Application with name "cn=SystemPolicy,cn=opssSecurityStore,cn=JPSContext,cn=opssRoot" does not exist.>
<Jul 25, 2022 1:33:21,539 PM CDT> <Warning> <oracle.jps.authorization> <JPS-04155> <Scanning of application policy failed. Reason {0}
oracle.security.jps.service.policystore.PolicyStoreRuntimeException: JPS-04006: No results found for given Application Name:soa-infra, DN: cn=soa-infra,cn=opssSecurityStore,cn=JPSContext,cn=opssRoot, Query: BaseSearchQuery: [Negation:false
IsORMatch:false
IsComplexQuery:true
Num ChildQueries:1
Non-paginated search.

EntryType:APPLICATION
ComparatorType:null
...<etc>...

And/Or:

<Aug 2, 2023 7:45:38,403 PM> <Warning> <Socket> <BEA-000449> <Closing the socket, as no data read from it on <IP:port> during the configured idle timeout of 5 seconds.>
oracle.security.jps.service.policystore.PolicyObjectNotFoundException: JPS-04028: Application with name "cn=SystemPolicy,cn=opssSecurityStore,cn=JPSContext,cn=opssRoot" does not exist.
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.getObjectCount(JpsDBDataManager.java:6311)
at oracle.security.jps.internal.policystore.entitymanager.impl.InternalQueryManagerImpl.getObjectCount(InternalQueryManagerImpl.java:2388)
at oracle.security.jps.az.internal.management.pd.service.GenericPolicyDistributionService.internalGetApplicationPolicyChangeLog(GenericPolicyDistributionService.java:2063)
at oracle.security.jps.az.internal.management.pd.service.GenericPolicyDistributionService.getApplicationPolicyChangeLog(GenericPolicyDistributionService.java:2023)
at oracle.security.jps.az.internal.runtime.notifier.PolicyChangeNotifierImpl.isSystemChanged(PolicyChangeNotifierImpl.java:184)
at oracle.security.jps.az.internal.runtime.notifier.PolicyChangeNotifierImpl.isChanged(PolicyChangeNotifierImpl.java:161)
at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner.scanSystemPolicy(PolicyChangeScanner.java:341)
at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner.scan(PolicyChangeScanner.java:294)
at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner.access$200(PolicyChangeScanner.java:114)
at oracle.security.jps.az.internal.common.scanner.PolicyChangeScanner$ScanTask.run(PolicyChangeScanner.java:246)
at javax.enterprise.concurrent.ManagedExecutors$RunnableAdapter.run(ManagedExecutors.java:211)
....
<Aug 2, 2023 7:54:35,027 PM BRT> <Warning> <oracle.jps.authorization> <JPS-04080> <Scanning of system policy failed. Reason oracle.security.jps.service.policystore.PolicyObjectNotFoundException: JPS-04028: Application with name "cn=SystemPolicy,cn=opssSecurityStore,cn=JPSContext,cn=opssRoot" does not exist.>
<Aug 2, 2023 7:54:35,142 PM BRT> <Warning> <oracle.jps.authorization> <JPS-04155> <Scanning of application policy failed. Reason {0}
...
Caused by: oracle.security.jps.JpsException: JPS-06198: OPSS Schema is not upgraded. Current schema version is 11.1.1.6.1. Schema version for upgrade is 12.2.1.0.0
oracle.security.jps.JpsException: JPS-06198: OPSS Schema is not upgraded. Current schema version is 11.1.1.6.1. Schema version for upgrade is 12.2.1.0.0


The related objects do not show any problems, e.g.:

 

Reference:
CFGWK-64254 Error Occured In "OPSS Processing" Phase Execution (Doc ID 2598504.1)
OPSS - How to verify OPSS Database Policy Store version? (Doc ID 2216291.1)

Changes

 

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.