Transaction DeadLock Error
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.
There are already 2 open connections to the same database which are also writing some data using the same Stored Procedure.