deadlock issues
583910Jun 26 2007 — edited Jun 27 2007Hope this is the right place to ask
I am getting deadlock issues in SQL server
Release: 8.9.05
Tools: 8.47
During a test run when multiple users executed Online & Batch GL post process the Deadlock Error is encountered (below is the error message).
Remote program GLPPPOST failed with return code:8601 .Reason:[Microsoft][ODBC SQL Server Driver][SQL server] Transaction(Process ID 117) was deadlocked on lock resources with another process and has been chosen as the
deadlock victim.Rerun the transaction.(SQLSTATE 40001)1205. In section:SQLRT:EXECUTE-STMT.Check log file:
S:\psoft\FSUDEV\appserv\FSUDEV\LOGS\GLPPPOST_VP1_0517080353.out in App Server for more info.
Check log file:
S:\psoft\FSUDEV\appserv\FSUDEV\LOGS\GLPPPOST_VP1_0517080353.out(2,-1) JRNL_PANELS_WRK.PB_POST.FieldChange Name:
post_jrnl PCPC:855 Statement:2 Called from:JRNL_PANELS_WRK.PB_POST.FieldChange Name:pb_post_fc Statement:75
Called from:JRNL_PANELS_WRK.PB_PROCESS.FieldChange Statement:27
any suggestions of what can be done