Symptom
When Multiple business processes are in process the following error happens and after this error a new Task entry is created however that is not picked up for processing and the business process gets stuck.
Error From Log:
[WaitNode] Error scheduling wait for event [${process.code}_wsLogin] in node with ID [waitForWebserviceResponse] for process with code [responsysEmailProcess-ORDER_CONFIRMATION-1467773869375-1000000212971]. Task condition has unique ID [responsysEmailProcess-ORDER_CONFIRMATION-1467773869375-1000000212971_wsLogin]. On Debug we found the following exception is caught in WaitNode.java scheduleTask method "org.springframework.dao.DeadlockLoserDataAccessException: query; SQL []; Deadlock found when trying to get lock; try restarting transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction" We have the index on Task which is created by OOTB definition
Read more...
Environment
SAP Commerce Cloud
Product
Keywords
workflow, index, taskconditions, InnoDB, business process , KBA , CEC-SCC-CDM-BO-APP , Applications , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.