Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Deadlock error received
 
From:   Ahmad, Syed Rehan

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016