OAM11g R2 : configureSecurityStore.py - Unique Constraint (<PREFIX>_OPSS.IDX_JPS_RDN_PDN) Violated (Doc ID 1525714.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

OAM11g R2 - configureSecurityStore.py - unique constraint (<PREFIX>_OPSS.IDX_JPS_RDN_PDN) violated

Steps followed -

1. Installation of IBM JDK 1.6
2. Installation of Database 11g
3. Creation of schema for OIM using RCU 11.1.2.0.0
4. Installation of WebLogic 10.3.6
5. Installation of Identity & Access Management 11.1.2.0
7. Create Weblogic Domain for OAM
8. Configure the Database Security Store

./wlst.sh <IDM_HOME_PATH>/common/tools/configureSecurityStore.py -d <DOMAIN_HOME>/domains/<DOMAIN_NAME> -c IAM -p <PASSWORD> -m create

Gets  below errors while configuring the Database Security Store
 

[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator]  migrateData - failed JPS-10000: There was an internal error in the policy store.
Exception in thread "main" java.lang.RuntimeException: JPS-10000: There was an internal error in the policy store.
oracle.security.jps.internal.api.common.JpsCredentialStoreLdapNodeCreationException: JPS-10000: There was an internal error in the policy store.
       at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.createJpsCredentailStoreInLdap(JpsDbBootstrapImpl.java:300)
       at oracle.security.jps.internal.config.ldap.LdapCredStoreServiceConfigurator.addServiceStoreBase(LdapCredStoreServiceConfigurator.java:98)
       at oracle.security.jps.internal.config.ldap.LdapCredStoreServiceConfigurator.migrateData(LdapCredStoreServiceConfigurator.java:64)
       at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.runConfiguration(LdapServiceEnabler.java:441)
       at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.configureCredentialStoreService(LdapServiceEnabler.java:221)
       at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.configureSecurityServices(LdapServiceEnabler.java:160)
       at oracle.security.jps.internal.tools.configuration.ldap.LdapServiceEnabler.main(LdapServiceEnabler.java:119)
Caused by: oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-10000: There was an internal error in the policy store.
       at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.handleRollbackException(JpsDBDataManager.java:1274)
       at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.internalCommitTxn(JpsDBDataManager.java:1437)
       at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.commitTransactionInDoAs(JpsDBDataManager.java:1404)
       at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.commitTransaction(JpsDBDataManager.java:1395)
       at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.createJpsCredentailStoreInLdap(JpsDbBootstrapImpl.java:293)
       ... 6 more
Caused by: javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>_OPSS.IDX_JPS_RDN_PDN) violated

Error Code: 1
Call: INSERT INTO JPS_DN (ENTRYID, PARENTDN, RDN) VALUES (?, ?, ?)
       bind => [3 parameters bound]
Query: InsertObjectQuery(EntryId=9787:rdn=cn=credentialstore:pdn=cn=jpsroot,cn=jpscontext,cn=iam,: JpsStore Entry={[EntryId = 9787:Attribute RowId = 37614
dn = cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot, EntryId = 9787:Attribute RowId = 37615
objectclass = top, EntryId = 9787:Attribute RowId = 37616 objectclass = orclContainer, EntryId = 9787:Attribute RowId = 37617 cn = CredentialStore]})
       at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
       at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
       at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager$7.run(JpsDBDataManager.java:1416)
       at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.internalCommitTxn(JpsDBDataManager.java:1421)
       ... 9 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<PREFIX>_OPSS.IDX_JPS_RDN_PDN) violated

Error Code: 1
Call: INSERT INTO JPS_DN (ENTRYID, PARENTDN, RDN) VALUES (?, ?, ?)
       bind => [3 parameters bound]
Query: InsertObjectQuery(EntryId=9787:rdn=cn=credentialstore:pdn=cn=jpsroot,cn=jpscontext,cn=iam,: JpsStore Entry={[EntryId = 9787:Attribute RowId = 37614
dn = cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot, EntryId = 9787:Attribute RowId = 37615 objectclass = top, EntryId = 9787:Attribute RowId = 37616 objectclass = orclContainer, EntryId = 9787:Attribute RowId = 37617 cn = CredentialStore]})

Changes

Cause

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