java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TEST_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=15463:rdn=cn=credentialstore:pdn=cn=jpsroot,cn=jpscontext,cn=iam,: JpsStore Entry={[EntryId = 15463:Attribute RowId = 82132 dn = cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot, EntryId = 15463:Attribute RowId = 82133 objectclass = top, EntryId = 15463:Attribute RowId = 82134 objectclass = orclContainer, EntryId = 15463:Attribute RowId = 82135 cn = CredentialStore]})

Oracle Community | D1990 | 2 years ago
  1. 0

    Configure Security Store OAM 11gR2 Fail

    Oracle Community | 2 years ago | D1990
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TEST_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=15463:rdn=cn=credentialstore:pdn=cn=jpsroot,cn=jpscontext,cn=iam,: JpsStore Entry={[EntryId = 15463:Attribute RowId = 82132 dn = cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot, EntryId = 15463:Attribute RowId = 82133 objectclass = top, EntryId = 15463:Attribute RowId = 82134 objectclass = orclContainer, EntryId = 15463:Attribute RowId = 82135 cn = CredentialStore]})
  2. 0

    Configure Security Store OAM 11gR2 Fail

    Oracle Community | 2 years ago | D1990
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (TEST_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=15463:rdn=cn=credentialstore:pdn=cn=jpsroot,cn=jpscontext,cn=iam,: JpsStore Entry={[EntryId = 15463:Attribute RowId = 82132 dn = cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot, EntryId = 15463:Attribute RowId = 82133 objectclass = top, EntryId = 15463:Attribute RowId = 82134 objectclass = orclContainer, EntryId = 15463:Attribute RowId = 82135 cn = CredentialStore]})
  3. 0

    Issue in creating OPSS Schema with rcu.

    Oracle Community | 3 years ago | 974057
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV1_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=11437:rdn=cn=credentialstore:pdn=cn=jpsroot,cn=jpscontext,cn=iam,: JpsStore Entry={[EntryId = 11437:Attribute RowId = 45348 dn = cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot, EntryId = 11437:Attribute RowId = 45349 objectclass = top, EntryId = 11437:Attribute RowId = 45350 objectclass = orclContainer, EntryId = 11437:Attribute RowId = 45351 cn = CredentialStore]})
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    configureSecurityStore.py Fails With ORA-00001: unique constraint (DEV_OPSS.IDX_JPS_RDN_PDN) violated

    Oracle Community | 3 years ago | 974057
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV1_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=11437:rdn=cn=credentialstore:pdn=cn=jpsroot,cn=jpscontext,cn=iam,: JpsStore Entry={[EntryId = 11437:Attribute RowId = 45348 dn = cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot, EntryId = 11437:Attribute RowId = 45349 objectclass = top, EntryId = 11437:Attribute RowId = 45350 objectclass = orclContainer, EntryId = 11437:Attribute RowId = 45351 cn = CredentialStore]})
  6. 0

    error while configuring security store for OIM

    Oracle Community | 2 years ago | Shabz
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (REMP_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=11437:rdn=cn=credentialstore:pdn=cn=jpsroot,cn=jpscontext,cn=iam,: JpsStore Entry={[EntryId = 11437:Attribute RowId = 45348 dn = cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot, EntryId = 11437:Attribute RowId = 45349 objectclass = top, EntryId = 11437:Attribute RowId = 45350 objectclass = orclContainer, EntryId = 11437:Attribute RowId = 45351 cn = CredentialStore]})

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLIntegrityConstraintViolationException

      ORA-00001: unique constraint (TEST_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=15463:rdn=cn=credentialstore:pdn=cn=jpsroot,cn=jpscontext,cn=iam,: JpsStore Entry={[EntryId = 15463:Attribute RowId = 82132 dn = cn=CredentialStore,cn=IAM,cn=JPSContext,cn=jpsroot, EntryId = 15463:Attribute RowId = 82133 objectclass = top, EntryId = 15463:Attribute RowId = 82134 objectclass = orclContainer, EntryId = 15463:Attribute RowId = 82135 cn = CredentialStore]})

      at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal()
    2. EclipseLink (non-OSGi)
      EntityTransactionImpl.commit
      1. org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
      2. org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
      2 frames
    3. oracle.security.jps
      JpsDBDataManager.internalCommitTxn
      1. oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager$8.run(JpsDBDataManager.java:1487)
      2. oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.internalCommitTxn(JpsDBDataManager.java:1492)
      2 frames