Archives of the TeradataForum

Message Posted: Thu, 22 Dec 2011 @ 15:37:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

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?

Thanks,

Syed

	<Prev	Next>		<<First	<Prev	Next>	Last>>