TeraGenericQuery Error: DB Call Failure(success check) Info = 2631, Code = 3132, Message = Access Logging step has failed. The transaction was aborted. Session return code = 3,132 , DBC return code = 0
TeraSync: control state query failed: "lock row access select col1, col2, col3, col4 from Database.terasync where cookie="---"
This is a routine job which runs every month. I got this error mess while it ran last night. When I looked t the Info =2631 it says the job aborted due to the dead locks or multiple users submitting multiple request.This table is not accessed by anyone. Could there be any other reason for the job to get aborted.
TeraGenericQuery Error: DB Call Failure(success check)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
This can be the result of contention on system resource or contention on database object. If you are sure there were no locks and checked with your dba that no locks were reported on the Locking Logger or DumpLockLog utility then cause is contention on system resource (which caused request time out?)
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>