2 Replies Latest reply: Mar 4, 2010 10:23 PM by Gowtham Kuchipudi RSS

Transaction DeadLock Error

Gowtham Kuchipudi
Currently Being Moderated

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.

Actions