My Oracle Support Banner

OPSS - OAM Domain Upgrade From 11g To 12c Fails with OPSS Processing Error during Domain Reconfiguration Step (Doc ID 2490663.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

Upgrading OAM fails with the following OPSS error:

ORA-00001: unique constraint (OAMTST_OPSS.JPS_ATTRS_PK) violated

Error stack:

2018-06-28 15:16:39,899 FINE [89] oracle.security.jps.internal.policystore.ldap.LdapPolicyStoreProvider - policyServiceInstances : {in-memory1530188199886in-memory1530188199886inmemory1530188199886nullcn=IAM,cn=JPSContext,cn=jpsroot=oracle.security.jps.internal.policystore.PolicyStoreImpl@c6ccdb5}
2018-06-28 15:16:39,922 FINE [89] oracle.security.jps.upgrade.tools.CredentialStoreUpgrade - Retrieved credential object size : 4
2018-06-28 15:16:39,922 FINE [89] oracle.security.jps.upgrade.tools.CredentialStoreUpgrade - Processing credential: orclCSFKey=Test-Cred,cn=Oracle-IAM-Security-Store-Diagnostics,cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot
2018-06-28 15:16:40,140 FINEST [29] com.oracle.cie.wizard.internal.engine.EmbeddedEngine - Waiting for new commands...
2018-06-28 15:16:40,205 FINE [89] oracle.security.jps.upgrade.tools.DBCredentialStoreUpgrade - Upgrade of DB credential store failed. Cause : javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OAMTST_OPSS.JPS_ATTRS_PK) violated

Error Code: 1
Call: INSERT INTO JPS_ATTRS (JPS_ATTRS_ID, ATTRKIND, ATTRNAME, ATTRVAL, JPS_DN_ENTRYID) VALUES (?, ?, ?, ?, ?)
bind => [5 parameters bound]
Query: InsertObjectQuery(EntryId = 11438:Attribute RowId = 8002
orclOPSSGenericCredential = [B@4ee968cf)
2018-06-28 15:16:40,205 FINE [89] oracle.security.jps.upgrade.tools.utility.Upgrade - Upgrade DIT and Data error!
oracle.security.jps.JpsException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OAMTST_OPSS.JPS_ATTRS_PK) violated

Error Code: 1
Call: INSERT INTO JPS_ATTRS (JPS_ATTRS_ID, ATTRKIND, ATTRNAME, ATTRVAL, JPS_DN_ENTRYID) VALUES (?, ?, ?, ?, ?)
bind => [5 parameters bound]
Query: InsertObjectQuery(EntryId = 11438:Attribute RowId = 8002
orclOPSSGenericCredential = [B@4ee968cf)
at oracle.security.jps.upgrade.tools.DBCredentialStoreUpgrade.upgradeDITAndData(DBCredentialStoreUpgrade.java:93)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgradeOPSSDITAndData(Upgrade.java:1075)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgradeOPSS(Upgrade.java:772)
at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.reconfigSubsystem(OpssDomainConfigImpl.java:364)
at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.initializeSubsystem(OpssDomainConfigImpl.java:276)
at oracle.security.opss.tools.lifecycle.cie.OpssSecurityConfiguration.initializeSubsystem(OpssSecurityConfiguration.java:188)
at com.oracle.cie.domain.progress.template.importer.ImporterOPSSProcessingPhase.initialize(ImporterOPSSProcessingPhase.java:36)
at com.oracle.cie.domain.progress.domain.generation.OPSSProcessingPhase.processOPSS(OPSSProcessingPhase.java:154)
at com.oracle.cie.domain.progress.domain.generation.OPSSProcessingPhase.execute(OPSSProcessingPhase.java:54)
at com.oracle.cie.domain.progress.AbstractProgressGenerator.run(AbstractProgressGenerator.java:94)
at java.lang.Thread.run(Thread.java:748)
Caused by: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OAMTST_OPSS.JPS_ATTRS_PK) violated

 

Changes

 Upgraded OAM from 11.1.2.3  to 12.2.1.3.

 Upgrade has been tried several times by restoring the same OPSS schema from backup

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.