Archives of the TeradataForum
Message Posted: Thu, 22 Dec 2011 @ 15:37:45 GMT
Our Development team is getting the below error in their Informatica workflow
Formatting TPT API error message... Wed Dec 21 16:16:00 2011 : > TPTWR_10562 [ERROR] Type:(Teradata PT API Error), Error: (**** 16:15:54 Deadlock error received. Retrying Request.) Wed Dec 21 16:16:00 2011 : > TPTWR_21211 [ERROR] Plug-in failed to Initiate Teradata database connection.?
When I am going and checking in the DBQLogTbl in the querytext below statement is showing and I am unable to find out the root cause. We have not enabled locking logger as of now.
USING TOTALAMPS(SMALLINT),UPAMPS(SMALLINT) ,DOWNAMPS(SMALLINT),AMPARRAY(VARBYTE(24576)) INSERT INTO WRK.INFA_LT_318843801109150 (LOGTYPE,OPERSEQ,TOTALAMPS,UPAMPS,DOWNAMPS,AMPARRAY) VALUES (130,10,:TOTALAMPS,:UPAMPS,:DOWNAMPS,:AMPARRAY);
Any clue on this?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|