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!
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.