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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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)

    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