TPT19134 - Only happens after the 7th run of the same file.

Tools
Enthusiast

TPT19134 - Only happens after the 7th run of the same file.

Hi All,

We're using TPT to load a flat file.  It loads the file just fine 6 times.  However, on the 7th run, we get the following error:  FILE_READER: TPT19134 !ERROR! Fatal data error processing file '/informatica/powercenter/infa_shared/SrcFiles/Shared/PRE/MB/Prepped/PROD.MB.DATA.MB423.CSR.EXTRACT.H0'. Delimited Data Parsing error: Column length overflow(s) in row 2.,,,,,,301085,-1,6873032

I know there was a reported problem in a prior release of TPT, but we're running Teradata Parallel Transporter Version 14.10.00.07, which is supposed to have the fix in it.

Any thoughts or suggestions would be much appreciated!

Thanks!

Larry

Tags (3)
1 REPLY
Enthusiast

Re: TPT19134 - Only happens after the 7th run of the same file.

Please ignore this question.  It turns out that we finally chased it down to the tool we were using having a duplicate id, which caused two columns to get randomly swapped when the TPT script was generated.  My apologies.