Hi Team,
An error occurred in the project's process
Messages:
BPM-0544: An error occurred when closing the action item. Contact your site administrator.
Expection:
com.niku.union.persistence.PersistenceDeadlockException:
SQL error code: 1205
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 72) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Executed:
UPDATE CAL_ACTION_ITEM_ASSIGNEES SET STATUS_CODE = ?, LAST_UPDATED_DATE=?, LAST_UPDATED_BY=? WHERE CAL_ACTION_ITEM_ID = ? AND STATUS_CODE != 'CAL_CLOSED'
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="actionItemListPMD.xml" id="calendar.modifyActionItemAllStatuses_stmt" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
<sql dbVendor="all">
<text>
UPDATE CAL_ACTION_ITEM_ASSIGNEES SET STATUS_CODE = ?, LAST_UPDATED_DATE=?, LAST_UPDATED_BY=? WHERE CAL_ACTION_ITEM_ID = ? AND STATUS_CODE != 'CAL_CLOSED'
</text>
<param name="status" path="masterStatus/@value" type="string" direction="IN" expressionListDelimiter=","/>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param replace="userId" direction="IN" expressionListDelimiter=","/>
<param name="id" path="actionItemId/@value" type="long" direction="IN" expressionListDelimiter=","/>
</sql>
</statement>
Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="calendar.modifyActionItemAllStatuses_stmt" inputSource="map" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/>
Using input:
{id=5220702, status=CAL_CLOSED}
at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2070)
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2189)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2823)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:869)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:769)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:577)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:307)
at com.niku.calendar.service.ActionItemService.updateActionItemStatus(ActionItemService.java:460)
at com.niku.bpm.services.ExecuteManualAction.closeActionItem(ExecuteManualAction.java:833)
at com.niku.bpm.services.ProcessEngine.stepComplete(ProcessEngine.java:336)
at com.niku.bpm.engine.rules.PostConditionTransitionPipeline.setStepInstanceAsDone(PostConditionTransitionPipeline.java:441)
at com.niku.bpm.engine.rules.PostConditionTransitionPipeline.transitionStep(PostConditionTransitionPipeline.java:414)
at com.niku.bpm.engine.rules.PostConditionTransitionPipeline.processWaitingForTransitionSteps(PostConditionTransitionPipeline.java:297)
at com.niku.bpm.engine.rules.PostConditionTransitionPipeline.execute(PostConditionTransitionPipeline.java:103)
at com.niku.bpm.engine.rules.Pipeline.run(Pipeline.java:280)
Caused by: java.sql.SQLTransactionRollbackException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 72) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transactio
Does anyone have any Suggestions?