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])

Oracle Community | 871346 | 3 years ago
  1. 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])
  2. 0

    Problem using BAM 12c with BPEL

    Oracle Community | 2 years ago | MarcG
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_SOAINFRA.BEAM_8_STRING_1_UC) violated Error Code: 1 Call: INSERT INTO BEAM_VIEW_39 (BEAM_ID, BEAM_OPTLOCK, B_INPUTS, B_SAMPLE, CASEID, CASE_DEFINITION_ID, COMPONENT_INSTANCE_ID, COMPOSITE_DEFINITION_ID, COMPOSITE_INSTANCE_ID, DATAOBJECT_CREATED, DATAOBJECT_HIERARCHY, DATAOBJECT_MODIFIED, ECID, FLOW_ID, ORGUNITID, PROCESS_DEFINITION_ID, PROCESS_DUE_TIME, PROCESS_END_DATE, PROCESS_END_EVENT_TYPE, PROCESS_END_TIME, PROCESS_ESTIMATED_TIME, PROCESS_EXPIRATION_TIME, PROCESS_FAULT_INFO, PROCESS_FAULT_TYPE, PROCESS_INSTANCE_STATUS, PROCESS_INSTANCE_TITLE, PROCESS_LASTUPDATED_TIME, PROCESS_RUNNING_TIME, PROCESS_STARTTIME_MS, PROCESS_START_DATE, PROCESS_START_EVENT_TYPE, PROCESS_START_TIME, PROCESS_SUSPEND_TIME, PROC_SYS_NUM01, PROC_SYS_NUM02, PROC_SYS_NUM03, PROC_SYS_NUM04, PROC_SYS_NUM05, PROC_SYS_STR02, PROC_SYS_STR03, PROC_SYS_STR04, PROC_SYS_STRG01, PROC_SYS_STRG05, PROC_SYS_TS01, PROC_SYS_TS02, PROC_SYS_TS03, S_SAMPLE, TENANT_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [48 parameters bound] Query: InsertObjectQuery({BEAM_VIEW_39 2003})
  3. 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)
  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_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])

    at org.eclipse.persistence.exceptions.DatabaseException.sqlException()
  2. EclipseLink (non-OSGi)
    JTASynchronizationListener.beforeCompletion
    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)
    23. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516)
    24. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498)
    25. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449)
    26. org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224)
    27. org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:123)
    28. org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799)
    29. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415)
    30. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1505)
    31. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3143)
    32. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3124)
    33. org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157)
    34. org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68)
    34 frames
  3. weblogic.transaction.internal
    TransactionManagerImpl.commit
    1. weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1244)
    2. weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1219)
    3. weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:121)
    4. weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1355)
    5. weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2172)
    6. weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:300)
    7. weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:267)
    8. weblogic.transaction.internal.TransactionManagerImpl.commit(TransactionManagerImpl.java:307)
    9. weblogic.transaction.internal.TransactionManagerImpl.commit(TransactionManagerImpl.java:301)
    9 frames
  4. EclipseLink (non-OSGi)
    UnitOfWorkImpl.commit
    1. org.eclipse.persistence.transaction.JTATransactionController.commitTransaction_impl(JTATransactionController.java:144)
    2. org.eclipse.persistence.transaction.AbstractTransactionController.commitTransaction(AbstractTransactionController.java:162)
    3. org.eclipse.persistence.internal.sessions.AbstractSession.commitExternalTransaction(AbstractSession.java:731)
    4. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitInternallyStartedExternalTransaction(UnitOfWorkImpl.java:1270)
    5. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commit(UnitOfWorkImpl.java:1068)
    5 frames
  5. oracle.iam.connectormgmt
    DBConnectorBundleStore.addConnectorBundle
    1. oracle.iam.connectormgmt.repository.DBConnectorBundleStore.addConnectorBundle(DBConnectorBundleStore.java:65)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  7. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  8. oracle.iam.platform
    DMSMethodInterceptor.invoke
    1. oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25)
    1 frame
  9. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  10. com.sun.proxy
    $Proxy549.addConnectorBundle
    1. com.sun.proxy.$Proxy549.addConnectorBundle(Unknown Source)
    1 frame
  11. com.thortech.xl
    ConnectorInstallProcessAction.completeInstallation
    1. com.thortech.xl.webclient.actions.ConnectorInstallUtility.uploadConnectorBundleToDB(ConnectorInstallUtility.java:218)
    2. com.thortech.xl.webclient.actions.ConnectorInstallUtility.upload(ConnectorInstallUtility.java:175)
    3. com.thortech.xl.webclient.actions.ConnectorInstallProcessAction.copyJarFilesForInstallation(ConnectorInstallProcessAction.java:449)
    4. com.thortech.xl.webclient.actions.ConnectorInstallProcessAction.completeInstallation(ConnectorInstallProcessAction.java:207)
    4 frames
  12. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  13. struts
    DispatchAction.dispatchMethod
    1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
    1 frame
  14. com.thortech.xl
    ConnectorInstallProcessAction.execute
    1. com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(tcLookupDispatchAction.java:133)
    2. com.thortech.xl.webclient.actions.tcActionBase.execute(tcActionBase.java:894)
    3. com.thortech.xl.webclient.actions.tcAction.execute(tcAction.java:213)
    4. com.thortech.xl.webclient.actions.ConnectorInstallProcessAction.execute(ConnectorInstallProcessAction.java:108)
    4 frames
  15. Struts Core
    ActionCommandBase.execute
    1. org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
    2. org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
    3. org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
    3 frames
  16. Commons Chain
    ChainBase.execute
    1. org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
    2. org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
    3. org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
    3 frames
  17. Struts Core
    ComposableRequestProcessor.process
    1. org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
    1 frame
  18. struts
    ActionServlet.doPost
    1. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
    2. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
    2 frames
  19. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  20. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  21. com.thortech.xl
    CSRFFilter.doFilter
    1. com.thortech.xl.webclient.security.CSRFFilter.doFilter(CSRFFilter.java:76)
    1 frame
  22. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  23. oracle.iam.platform
    OIMAuthContextFilter.doFilter
    1. oracle.iam.platform.auth.web.OIMAuthContextFilter.doFilter(OIMAuthContextFilter.java:107)
    1 frame
  24. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  25. oracle.security.jps
    JpsAbsFilter$1.run
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    1 frame
  26. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  27. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
    2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
    3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
    4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
    5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    5 frames
  28. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  29. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
    1 frame
  30. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
    3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    5 frames
  31. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  32. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  33. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    3 frames
  34. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames