Symptom
When executing a script in CPQ, you see this error: "SQLEXCEPTION: Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim".
Environment
SAP SALES CLOUD CPQ
Cause
This issue happens when you are you are executing the same query in parallel.
Parallel work on the same table causes the queries to lock each other.
Resolution
Please check your scripts and change the implementation as this can only affect performances even if the deadlock is not happening.
Keywords
SQLEXCEPTION, Transaction, deadlock, parallel, script, table, queries , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem
Product
SAP CPQ all versions