Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

deadlock issues

583910Jun 26 2007 — edited Jun 27 2007
Hope 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2007
Added on Jun 26 2007
8 comments
1,032 views