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.
SAP Knowledge Base Article - Preview