Error While Locking The Task During Update during Human Task Parallel Voting

(Doc ID 2192497.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Business Process Management Suite - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Experiencing below error when two different participant users set the task outcome at the same time (using two different browser sessions).

[2016-08-24T15:10:19.680-04:00] [soa_server1] [ERROR] [] [oracle.soa.services.workflow.persistency] [tid: [ACTIVE].ExecuteThread: '51' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 38875c84-b24f-4866-9089-87d13ee32043-008c3e6a,1:27814] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.soa.tracking.FlowId: 110098] [oracle.soa.tracking.InstanceId: 141718] [oracle.soa.tracking.SCAEntityId: 50007] [FlowId: 0000LQuKbcW5aaj_L1S4ye1Ni4Z400001f] exception.code:30279[[
exception.type: ERROR
exception.severity: 2
exception.name: Error while locking the task during update .
exception.description: Error while locking the task 81f04438-04ab-4067-aeca-6561877cef7a during update.
exception.fix: The task is being updated by another user, merge and update the task later.
 ORABPEL-30279

exception.code:30279
exception.type: ERROR
exception.severity: 2
exception.name: Error while locking the task during update .
exception.description: Error while locking the task 81f04438-04ab-4067-aeca-6561877cef7a during update.
exception.fix: The task is being updated by another user, merge and update the task later.

at oracle.bpel.services.workflow.repos.driver.oracle.OracleWFTask.updateTaskInDatabase(OracleWFTask.java:437)
at oracle.bpel.services.workflow.repos.driver.WFTask.updateWFTask(WFTask.java:3208)
at oracle.bpel.services.workflow.repos.driver.PersistencyService.updateWFTask(PersistencyService.java:737)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperationInTrans(TaskService.java:7730)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperationInTrans(TaskService.java:7442)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7390)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7340)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7316)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7298)
at oracle.bpel.services.workflow.task.impl.TaskService.updateTaskOutcomeAndEvaluateRoutingSlip(TaskService.java:4294)
at oracle.bpel.services.workflow.task.impl.TaskService.updateTaskOutcome(TaskService.java:3980)
at oracle.bpel.services.workflow.task.impl.TaskService.updateTaskOutcome(TaskService.java:3948)
at oracle.bpel.services.workflow.task.impl.TaskService.updateTaskOutcome(TaskService.java:3938)
......
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1626)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1586)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:617)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:397)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused by: java.sql.SQLException: ORA-20001: Task is locked for update
ORA-06512: at "SOA_SOAINFRA.WFTASKPKG_121200", line 3090
ORA-20001:
ORA-06512: at "SOA_SOAINFRA.WFTASKPKG_121200", line 117
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:228)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:49)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1000)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:5136)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:10886)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1519)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170)
at sun.reflect.GeneratedMethodAccessor2090.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at oracle.bpel.services.workflow.repos.Connection$DBStatementProxy.invoke(Connection.java:134)
at com.sun.proxy.$Proxy601.executeUpdate(Unknown Source)
at oracle.bpel.services.workflow.repos.driver.oracle.OracleWFTask.updateTaskInDatabase(OracleWFTask.java:419)
... 158 more

]]


You could also face this error.

[2016-09-28T17:00:31.385-04:00] [soa_server1] [ERROR] [] [oracle.soa.services.workflow.task] [tid: [ACTIVE].ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: d25a39bf-5412-4ba4-a64b-5804fb2b4777-00009e93,1:16799] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.soa.tracking.FlowId: 430009] [oracle.soa.tracking.InstanceId: 1220146] [oracle.soa.tracking.SCAEntityId: 240007] [FlowId: 0000LTmZ^c0AxGLLMQWBye1Nv2^f00000F] exception.code:30024[[
exception.type: ERROR
exception.severity: 2
exception.name: The task is already modified.
exception.description: The task was modified before the current action could be performed.
exception.fix: Refresh the task and perform the action again if the action is still relevant on the refreshed task.
 ORABPEL-30024

exception.code:30024
exception.type: ERROR
exception.severity: 2
exception.name: The task is already modified.
exception.description: The task was modified before the current action could be performed.
exception.fix: Refresh the task and perform the action again if the action is still relevant on the refreshed task.

at oracle.bpel.services.workflow.repos.driver.oracle.OracleWFTask.updateTaskInDatabase(OracleWFTask.java:444)
at oracle.bpel.services.workflow.repos.driver.WFTask.updateWFTask(WFTask.java:3218)
at oracle.bpel.services.workflow.repos.driver.PersistencyService.updateWFTask(PersistencyService.java:737)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperationInTrans(TaskService.java:7730)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperationInTrans(TaskService.java:7442)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7390)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7340)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7316)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7298)
at oracle.bpel.services.workflow.task.impl.TaskService.checkParentTaskOnSubtaskComplete(TaskService.java:6887)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperationInTrans(TaskService.java:7778)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperationInTrans(TaskService.java:7442)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:7390)
at oracle.bpel.services.workflow.task.impl.TaskService.performPostActionOperation(TaskService.java:8814)
at oracle.bpel.services.workflow.task.impl.TaskService.localHandleRoutingSlipInterpretationResult(TaskService.java:4420)
at oracle.bpel.services.workflow.task.impl.TaskService.handleRoutingSlipInterpretationResult(TaskService.java:4543)
at oracle.bpel.services.workflow.task.impl.TaskService.evaluateRoutingSlipTaskAssignment(TaskService.java:4345)
at oracle.bpel.services.workflow.task.impl.TaskService.updateTaskOutcomeAndEvaluateRoutingSlip(TaskService.java:4301)

 

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