java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated

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

    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
  2. 0

    ODI Agent Failed

    Oracle Community | 7 months ago | Kimi
    oracle.odi.core.repository.UncategorizedRepositoryAccessException: ODI-10182: Uncategorized exception during repository access. ORA-01400: cannot insert NULL into ("EPMREP"."SNP_CONNECT_PROP"."PROP_KEY")
  3. 0

    Active Directory Group Recon Error in OIM11gR2

    Oracle Community | 4 years ago | Srivatsa.kashyap
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("DEV_OIM"."UD_ADGRP"."UD_ADUSER_KEY")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    while saving Blanket purchase Agreements in oaf page i am getting this error

    Oracle Community | 1 year ago | 2996619
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("PO"."PO_ATTRIBUTE_VALUES_TLP_DRAFT"."DESCRIPTION")
  6. 0

    OIM Connector Installation Error

    Oracle Community | 3 years ago | 871346
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_OIM.OIMHOME_JARS_UNIQUE) violated
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

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeUpdate
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeUpdate
    1. weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
    1 frame
  4. EclipseLink (non-OSGi)
    UnitOfWorkImpl.internalExecuteQuery
    1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:831)
    2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906)
    3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592)
    4. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)
    5. org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)
    6. org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253)
    7. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207)
    8. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
    9. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342)
    10. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)
    11. org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177)
    12. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472)
    13. org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
    14. org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
    15. org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287)
    16. org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
    17. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844)
    18. org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743)
    19. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
    20. org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
    21. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871)
    21 frames
  5. oracle.security.am
    PerformanceProfiler.profileExecutionOfQuery
    1. oracle.security.am.db.common.PerformanceProfiler.profileExecutionOfQuery(PerformanceProfiler.java:57)
    1 frame
  6. 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
  7. 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
  8. org.eclipse.higgins
    ConfigurationHandler.configure
    1. org.eclipse.higgins.configuration.xml.ConfigurationHandler.configure(ConfigurationHandler.java:417)
    1 frame
  9. 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