java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated Error Code: 1 Call: INSERT INTO ENTITIES (ID, CREATE_TIME_STAMP, CREATOR, DESCRIPTION, JOURNAL_ID, MODIFIER, MODIFY_TIME_STAMP, NAME, NAME_PATH, TAG, TRANSACTION_ID, TYPE_NAMES, UNIQUE_ID, VERSI ON) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [14 parameters bound] Query: InsertObjectQuery(oracle.security.am.foundation.entity.admin.provider.db.beans.Entities@640d67a7)

Oracle Community | Bram van Pelt | 2 years ago
  1. 0

    Oracle Access Manager default installation issue: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated

    Oracle Community | 2 years ago | Bram van Pelt
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated Error Code: 1 Call: INSERT INTO ENTITIES (ID, CREATE_TIME_STAMP, CREATOR, DESCRIPTION, JOURNAL_ID, MODIFIER, MODIFY_TIME_STAMP, NAME, NAME_PATH, TAG, TRANSACTION_ID, TYPE_NAMES, UNIQUE_ID, VERSI ON) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [14 parameters bound] Query: InsertObjectQuery(oracle.security.am.foundation.entity.admin.provider.db.beans.Entities@640d67a7)
  2. 0

    Sharing transaction with AbstractRoutingDataSource

    Stack Overflow | 3 years ago | Nikopolidis
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (VETO_PROD.SYS_C0013988) violated Error Code: 1 Call: INSERT INTO S_VET_CONTACT_TYPE (ID, DESCRIPTION, NAME, FASEDIDEFAULT_ID) VALUES (82, 'Prova doppione', '16XOV', NULL) Query: InsertObjectQuery(ContactType [id=82, name=16XOV, description=Prova doppione, fasiAssociate={[]}, faseDiDefault=null])
  3. 0

    OIM Connector Installation Error

    Oracle Community | 3 years ago | 871346
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OIM.OIMHOME_JARS_UNIQUE) violated Error Code: 1 Call: INSERT INTO OIMHOME_JARS (OJ_ID, OJ_JAR, OJ_TYPE, CREATED_BY, CREATED_ON, UPDATED_ON, OJ_NAME, UPDATED_BY) VALUES (?, ?, ?, ?, ?, ?, ?, ?) bind => [8 parameters bound] Query: InsertObjectQuery(ConnectorBundle [name=org.identityconnectors.ldap-1.0.6380.jar, type=ICFBundle, lastChangedTime=Mon Jan 27 23:44:41 IST 2014])
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    unique constraint (SOAINFRA.AT_PK) violated

    Oracle Community | 4 years ago | 652977
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (RTE_SOAINFRA.AT_PK) violated Error Code: 1 Call: INSERT INTO AUDIT_TRAIL (CIKEY, COUNT_ID, BLOCK, BLOCK_CSIZE, BLOCK_USIZE, LOG, NUM_OF_EVENTS, CI_PARTITION_DATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?) bind => [8 parameters bound] Query: InsertObjectQuery(com.collaxa.cube.persistence.dto.AuditTrail@849ae4a) This error contained an exception thrown by the message handler. Check the exception trace in the log (with logging level set to debug mode).
  6. 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]})

    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 (DEV_OAM.PK_ENTITIES) violated Error Code: 1 Call: INSERT INTO ENTITIES (ID, CREATE_TIME_STAMP, CREATOR, DESCRIPTION, JOURNAL_ID, MODIFIER, MODIFY_TIME_STAMP, NAME, NAME_PATH, TAG, TRANSACTION_ID, TYPE_NAMES, UNIQUE_ID, VERSI ON) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [14 parameters bound] Query: InsertObjectQuery(oracle.security.am.foundation.entity.admin.provider.db.beans.Entities@640d67a7)

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException()
    2. EclipseLink (non-OSGi)
      UnitOfWorkImpl.internalExecuteQuery
      1. org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
      2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:840)
      3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906)
      4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592)
      5. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
      6. org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
      7. org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
      8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
      9. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
      10. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342)
      11. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)
      12. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177)
      13. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472)
      14. org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
      15. org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
      16. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)
      17. org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
      18. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
      19. org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
      20. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
      21. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
      22. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
      22 frames
    3. oracle.security.am
      PerformanceProfiler.profileExecutionOfQuery
      1. oracle.security.am.db.common.PerformanceProfiler.profileExecutionOfQuery(PerformanceProfiler.java:57)
      1 frame
    4. EclipseLink (non-OSGi)
      EntityManagerImpl.flush
      1. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1514)
      2. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
      3. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449)
      4. org.eclipse.persistence.internal.sessions.CommitManager.commitChangedObjectsForClassWithChangeSet(CommitManager.java:265)
      5. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:190)
      6. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:136)
      7. org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799)
      8. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415)
      9. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:636)
      10. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithPreBuiltChangeSet(UnitOfWorkImpl.java:1561)
      11. org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.writeChanges(RepeatableWriteUnitOfWork.java:447)
      12. org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:780)
      12 frames
    5. oracle.security.am
      StoreUtil.loadConfiguration
      1. oracle.security.am.db.jpa.JPABaseDAO$InsertObjectAction.internalPerformAction(JPABaseDAO.java:387)
      2. oracle.security.am.db.jpa.JPABaseDAO$DBAction.performAction(JPABaseDAO.java:99)
      3. oracle.security.am.db.jpa.JPADBManager.insert(JPADBManager.java:110)
      4. oracle.security.am.db.dataaccess.entity.impl.EntityDataAccessImpl.createEntities(EntityDataAccessImpl.java:104)
      5. oracle.security.am.foundation.entity.admin.provider.db.EntityStoreImpl.createEntity(EntityStoreImpl.java:106)
      6. oracle.security.am.foundation.entity.admin.impl.EntityManagerImpl.createEntity(EntityManagerImpl.java:168)
      7. oracle.security.am.admin.config.util.store.EntityStore.storeAsEntity(EntityStore.java:661)
      8. oracle.security.am.admin.config.util.store.EntityStore.doStore(EntityStore.java:442)
      9. oracle.security.am.admin.config.util.store.EntityStore.store(EntityStore.java:299)
      10. oracle.security.am.admin.config.util.store.StoreUtil.reconcile(StoreUtil.java:289)
      11. oracle.security.am.admin.config.util.store.StoreUtil.loadConfiguration(StoreUtil.java:259)
      11 frames
    6. org.eclipse.higgins
      ConfigurationHandler.configure
      1. org.eclipse.higgins.configuration.xml.ConfigurationHandler.configure(ConfigurationHandler.java:417)
      1 frame
    7. oracle.security.am
      BasicFileConfigurationStore$ListenerDispatcher.run
      1. oracle.security.am.admin.config.BasicFileConfigurationStore.callConfigure(BasicFileConfigurationStore.java:839)
      2. oracle.security.am.admin.config.BasicFileConfigurationStore.loadConfiguration(BasicFileConfigurationStore.java:783)
      3. oracle.security.am.admin.config.BasicFileConfigurationStore.getConfigurationHandler(BasicFileConfigurationStore.java:755)
      4. oracle.security.am.admin.config.BasicFileConfigurationStore.getConfiguration(BasicFileConfigurationStore.java:189)
      5. oracle.security.am.admin.config.BasicFileConfigurationStore.getConfiguration(BasicFileConfigurationStore.java:183)
      6. oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl$ConfigListener.getStatNumber(CoherenceMapImpl.java:1247)
      7. oracle.security.am.foundation.mapimpl.coherence.CoherenceMapImpl$ConfigListener.configurationChanged(CoherenceMapImpl.java:1259)
      8. oracle.security.am.admin.config.BasicFileConfigurationStore$ListenerDispatcher.run(BasicFileConfigurationStore.java:1110)
      8 frames