SAP Knowledge Base Article - Public

3513262 - CPQ SQLEXCEPTION: Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock

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