Archived discussions are read-only. Learn more about SAP Q&A

Transaction DeadLock Error

Hi,

I am trying to execute a transaction in WorkBench and it gives me an Error

"com.sap.xmii.illuminator.logging.LHException:com.microsoft.sqlserver.jdbc.SQLServerException:Transaction (Process ID 62) was deadlocked on lock resources with another process and has been choosen as the deadlock victim. Rerun the transaction"

This error is coming while executing a SQL action inside the transaction. This Sql action will call a stored procedure on External System to write some data.

These are the server Parameter of this data server.

PoolMax: 100

PollSize: 1

There are already 2 open connections to the same database which are also writing some data using the same Stored Procedure.

Thanks,

Gowtham K.

  • SAP Employee
Not what you were looking for? View more on this topic or Ask a question