UTY2806 Maximum retry limit (200) exceeded for transaction

UDA
N/A

UTY2806 Maximum retry limit (200) exceeded for transaction

Hi there,
I am trying to load 800,000 accounts flat file into a table, but everytime i run the script, sometimes it loads to 200k and gives me the error "UTY2806 Maximum retry limit (200) exceeded for transaction"
sometimes it loads to 700k and then give the above specified error.

could somebody please help me with this.

2 REPLIES

Re: UTY2806 Maximum retry limit (200) exceeded for transaction

Here is the error description from manual. I hope this helps you understand what the situation.
As mentioned below, can you please check for DBS errors

UTY2806 Maximum retry limit ''
exceeded for transaction.
Explanation: Tpump retries for certain CLI/DBS
errors. And, if the number of retries exceeds TLIMAXRETRY
(which is 200) then Tpump Terminates
with the above error message.
Generated By: TLISESS
Remedy: Resubmit the job.
Teradata Employee

Re: UTY2806 Maximum retry limit (200) exceeded for transaction

Not much detail here, but I'm guessing you have many rows in the table with the same PI value and/or the input file contains many records with the same PI value. Use of SERIALIZE ON may help, particularly in the latter case.