Error While Locking The Task During Update during Human Task Parallel Voting
(Doc ID 2192497.1)
Last updated on APRIL 01, 2024
Applies to:
Oracle Business Process Management Suite - Version 12.2.1.0.0 and laterInformation 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: <USERID>] [ecid: <ECID>] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.soa.tracking.FlowId: <FLOWID>] [oracle.soa.tracking.InstanceId: ] [oracle.soa.tracking.SCAEntityId: ] [FlowId: ] 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
]]
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: ] [ecid: ,1:16799] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.soa.tracking.FlowId: ] [oracle.soa.tracking.InstanceId: ] [oracle.soa.tracking.SCAEntityId: ] [FlowId: ] 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)
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)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |