AnsweredAssumed Answered

An error occurred when closing the action item

Question asked by sender on Oct 9, 2017
Latest reply on Oct 10, 2017 by Abhisek

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?

Outcomes