Transaction DeadLock Error

[Former Member]

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.

[jamie_cawley]

That error is from your database. There may be ways to mitigate this, just search for the error on google. If using mssql check

[http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/194f18b0-03b2-4e8f-8c67-5c92373c3efd]

Regards,

Jamie

[Former Member]

Thanks Jamie. I will check with the DBA to kill all the connections. and will try again.

Thanks,

Gowtham K.