We are experiencing a problem where processes are not starting intermittently. The same processes start at other times. Further we face this issue only in one of our environments.
The following error was noticed in the bg-ca.log:
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SET PARENT_OBJECT_ID = (SELECT ID FROM BPM_RUN_OBJECTS WHERE OBJECT_NAME = ? AND PK_ID = ? AND TABLE_NAME = ?)
WHERE OBJECT_NAME = ? AND PK_ID = ? AND TABLE_NAME = ?
This is caused by an issue in the DB. Request the DBA to look into the BPM_RUN_OBJECTS table, for problems such as fragmentation or bad execution plan.