I am using Teradata Parallel Transporter Version 15.10.00.04 64-Bit on Solaris.
When loading a data file with a single row of data, TPT failes with the error:
TPT_DATACONNECTOR_OPERATOR: TPT19435 pmRead failed. EOF encountered before end of record (35)
TPT_DATACONNECTOR_OPERATOR: TPT19305 Fatal error reading data.
TPT_DATACONNECTOR_OPERATOR: TPT19015 TPT Exit code set to 12.
Pipe, "|", delimited
And record is delimited by a Unix New Line
If I were to enter an additional new line at the end of the row, the first row is loaded successfully but the 2nd row (new line) ends in a bad file.
If I copy paste the row and create a file with 2 rows, retaining the original row, TPT runs successfully.
I have tried to change the encoding of the file i.e. to ANSI and UTF8 without BOM etc but that has not helped.
Solved! Go to Solution.
Please post or email me the script and the data file.
Treating EOF as EOR went into 15.10.00.00 and thus you should not be getting that error.
I can reproduce inhouse and have opened a bug report for this.
The "treat EOF as EOR" was implemented, but apparently the logic fails when there is just one record in the source file.
I don't see a 15.10.00.09 release, the max version i see for 15.10.00 is 15.10.00.04
Going to 15.10.01.XX isn't an option if it requires the rest of TTU to be updated.