SAP Knowledge Base Article - Preview

2365760 - Error while processing business process

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

SAP Commerce Cloud all versions

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.