Skip to Content

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.

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