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
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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})

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