Instance failing to create due to unique constrant violation (Doc ID 2257457.1)

Last updated on APRIL 20, 2017

Applies to:

Oracle Business Process Management Suite - Version 10.3.1 to 10.3.3 [Release AS10gR3]
Information in this document applies to any platform.

Symptoms

Cannot create an instance:

  

, "Apr 18, 2017 3:16:15 AM", Default, Main, [ACTIVE] ExecuteThrea, "PAPI WS Exception: Activity '/TrueSys#Default-1.0/Begin[Begin]' task 'BeginIn' could not execute successfully.
Detail:Method: 'BeginIn', Exception: 'Process execution engine execution error.'
.
Details:
Activity '/TrueSys#Default-1.0/Begin[Begin]' task 'BeginIn' could not execute successfully.
Detail:Method: 'BeginIn', Exception: 'Process execution engine execution error.'

Caused by: Process execution engine execution error.
Caused by: An error occurred while accesing the database.
Detail:SQL statement: 'INSERT INTO PPROCINSTANCE ( PROCESSID, INSTID, THREADID, NAME, PARENTTHREAD, PRIORITY, CREATIONTIME, AUTHOR, PARTICIPANT, NEXTPARTICIPANT, PROCESSDEADLINE, ACTIVITYDEADLINE, RECEIVETIME, ACTIVITYNAME, NTHREADS, CTHREADS, FCTHREAD, ATHREAD, TOTALTHREADS, STATE, SOURCEACTIVITYNAME, ROLEIN, PENDINGITEMID, LASTRESULT, ITEMDEADLINE, ACTIVATIONTIME, NCHANGES, NREMARKS, NATTACHMENTS, INSTANCEDATA, HASPARTFORROLE,MICROACTIVITYNAME , V_BUS_CONDITION, V_BUS_STAT_UPDATE, V_CASE_ID, V_CLR_REOPEN_FLG, V_CTL_CONDITION, V_CTL_STAT_UPDATE, V_EXP_DT_UPDATED, V_EXT_BUS_PEND_MIN, V_EXT_CTL_PEND_MIN, V_EXT_FATAL_PEND_M, V_MIGRATION_MODE, V_TR_BUS_CONFLICT, V_TR_BUS_STALE, V_TR_BUS_STATUS, V_TR_CHG_NTFY_REQ, V_TR_CTL_CONFLICT, V_TR_CTL_STALE, V_TR_CTL_STATUS, V_TR_FATAL_CONF, V_TR_MARK_CLOSE, V_TR_MARK_DUP, V_TR_REREVIEW_REQ, V_TR_TRANS_STATUS, V_TRANSACTION_ID) VALUES ( 41, 105450, 0, TrueSys105450, -1, 3, 2017-04-18 03:16:14.0, 10876, null, null, null, null, 2017-04-18 03:16:14.0, ProcessRegister, 0, 0, -1, null, 0, 1, Begin, 0, -1, , null, null ,6 ,0 ,0 ,[B@678b7d9, false, StartExecution[ProcessRegister],null,null,,null,null,null,,null,null,null,null,null,null,null,,null,null,null,,,,,,124719)'

Caused by: [BEA][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (TRBBPUTG_ENG.SYS_C0027273) violated

fuego.papi.exception.ActivityFailedException: Activity '/TrueSys#Default-1.0/Begin[Begin]' task 'BeginIn' could not execute successfully.
Detail:Method: 'BeginIn', Exception: 'Process execution engine execution error.'

at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:205)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:345)
at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)
at fuego.ejbengine.EJBProcessControl_1zamnl_EOImpl_1030_WLStub.createInstance(Unknown Source)
at fuego.papi.impl.j2ee.EJBProcessControlInterfaceWrapper.createInstance(EJBProcessControlInterfaceWrapper.java:193)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at fuego.papi.impl.AbstractProcessControlHandler.invokeInternal(AbstractProcessControlHandler.java:72)
at fuego.papi.impl.j2ee.EJBProcessControlHandler.doInvoke(EJBProcessControlHandler.java:116)
at fuego.papi.impl.j2ee.EJBProcessControlHandler.invoke(EJBProcessControlHandler.java:70)
at $Proxy180.createInstance(Unknown Source)
at fuego.papi.impl.ProcessInstanceOperation.createInstance(ProcessInstanceOperation.java:344)
at fuego.papi.impl.ProcessServiceSessionImpl.processCreateInstance(ProcessServiceSessionImpl.java:3203)
at fuego.papi.webservice.ProcessServiceSession.processCreateInstance(ProcessServiceSession.java:1879)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:89)
at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:71)
at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:93)
at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:598)
at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:557)
at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:542)
at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:439)
at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:243)
at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:444)
at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)
at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:134)
at weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:272)
at weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:185)
at weblogic.wsee.jaxws.JAXWSServlet.doPost(JAXWSServlet.java:180)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at weblogic.wsee.jaxws.JAXWSServlet.service(JAXWSServlet.java:64)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(Unknown Source)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: fuego.papi.impl.EngineExecutionException: Process execution engine execution error.
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:139)
at fuego.server.execution.EngineExecution.executeImmediate(EngineExecution.java:66)
at fuego.server.AbstractProcessBean.internalCreateInstance(AbstractProcessBean.java:4320)
at fuego.server.AbstractProcessBean._doCreateInstance(AbstractProcessBean.java:3670)
at fuego.server.AbstractProcessBean.createInstance(AbstractProcessBean.java:667)
at fuego.ejbengine.EJBProcessControlAdapter.createInstance(EJBProcessControlAdapter.java:118)
at fuego.ejbengine.EJBProcessControl_1zamnl_EOImpl.createInstance(EJBProcessControl_1zamnl_EOImpl.java:2653)
at fuego.ejbengine.EJBProcessControl_1zamnl_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)
... 50 more
Caused by: fuego.transaction.DatabaseException: An error occurred while accesing the database.
Detail:SQL statement: 'INSERT INTO PPROCINSTANCE ( PROCESSID, INSTID, THREADID, NAME, PARENTTHREAD, PRIORITY, CREATIONTIME, AUTHOR, PARTICIPANT, NEXTPARTICIPANT, PROCESSDEADLINE, ACTIVITYDEADLINE, RECEIVETIME, ACTIVITYNAME, NTHREADS, CTHREADS, FCTHREAD, ATHREAD, TOTALTHREADS, STATE, SOURCEACTIVITYNAME, ROLEIN, PENDINGITEMID, LASTRESULT, ITEMDEADLINE, ACTIVATIONTIME, NCHANGES, NREMARKS, NATTACHMENTS, INSTANCEDATA, HASPARTFORROLE,MICROACTIVITYNAME , V_BUS_CONDITION, V_BUS_STAT_UPDATE, V_CASE_ID, V_CLR_REOPEN_FLG, V_CTL_CONDITION, V_CTL_STAT_UPDATE, V_EXP_DT_UPDATED, V_EXT_BUS_PEND_MIN, V_EXT_CTL_PEND_MIN, V_EXT_FATAL_PEND_M, V_MIGRATION_MODE, V_TR_BUS_CONFLICT, V_TR_BUS_STALE, V_TR_BUS_STATUS, V_TR_CHG_NTFY_REQ, V_TR_CTL_CONFLICT, V_TR_CTL_STALE, V_TR_CTL_STATUS, V_TR_FATAL_CONF, V_TR_MARK_CLOSE, V_TR_MARK_DUP, V_TR_REREVIEW_REQ, V_TR_TRANS_STATUS, V_TRANSACTION_ID) VALUES ( 41, 105450, 0, TrueSys105450, -1, 3, 2017-04-18 03:16:14.0, 10876, null, null, null, null, 2017-04-18 03:16:14.0, ProcessRegister, 0, 0, -1, null, 0, 1, Begin, 0, -1, , null, null ,6 ,0 ,0 ,[B@678b7d9, false, StartExecution[ProcessRegister],null,null,,null,null,null,,null,null,null,null,null,null,null,,null,null,null,,,,,,124719)'

at fuego.server.persistence.jdbc.JdbcProcessInstancePersMgr.createInstance(JdbcProcessInstancePersMgr.java:1290)
at fuego.server.persistence.Persistence.createProcessInstance(Persistence.java:686)
at fuego.server.execution.EngineExecutionContext.persistInstances(EngineExecutionContext.java:1997)
at fuego.server.execution.EngineExecutionContext.persist(EngineExecutionContext.java:1211)
at fuego.transaction.TransactionAction.beforeCompletion(TransactionAction.java:132)
at fuego.connector.ConnectorTransaction.beforeCompletion(ConnectorTransaction.java:692)
at fuego.connector.ConnectorTransaction.commit(ConnectorTransaction.java:375)
at fuego.transaction.TransactionAction.commit(TransactionAction.java:302)
at fuego.transaction.TransactionAction.startBaseTransaction(TransactionAction.java:481)
at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:551)
at fuego.transaction.TransactionAction.start(TransactionAction.java:212)
at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:123)
... 58 more
Caused by: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (TRBBPUTG_ENG.SYS_C0027273) violated

at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.execute(Unknown Source)
at weblogic.jdbcx.base.BasePreparedStatementWrapper.execute(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98)
at fuego.jdbc.FaultTolerantPreparedStatement.execute(FaultTolerantPreparedStatement.java:574)
at

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms