TeraGenericQuery Error: DB Call Failure(success check)

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Hope
Participant
Posts: 97
Joined: Sun May 13, 2007 2:51 pm
Contact:

TeraGenericQuery Error: DB Call Failure(success check)

Post by Hope »

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.
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

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>
Post Reply