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)

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web12

Stack trace

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

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

We couldn't find other users who have seen this exception.