Skip to Content
0
Jun 16, 2016 at 11:41 PM

BODS job failing due to database table contention

865 Views

Hi Team,

BODS jobs were failed initially with below error :

----------------------------------------------------------------------

error message for operation <SQLExecute>: <[Microsoft][SQL Server Native

Client 10.0][SQL Server]Transaction (Process ID 100) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.>.

-----------------------------------------------------------------------

Later after sometime job ran successfully aftersometime.

Please let me know how to avoid this situation of deadlock for BODS jobs

Thanks

K.Chandrakanth