TPT fails if data file contains a single row

Tools & Utilities

TPT fails if data file contains a single row

Hi,

 

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[1]: TPT19435 pmRead failed. EOF encountered before end of record (35)
TPT_DATACONNECTOR_OPERATOR[1]: TPT19305 Fatal error reading data.
TPT_DATACONNECTOR_OPERATOR[1]: TPT19015 TPT Exit code set to 12.

 

Data File:

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.

 

Many thanks,

Mushtaq


Accepted Solutions
Teradata Employee

Re: TPT fails if data file contains a single row

Ok, I had a mixup in the versions of TPT on my VM.

I was running 15.10.00.04, not 15.10.01.04.

The problem was indeed fixed in 15.10.00.09 and 15.10.01.01.

 

-- SteveF
1 ACCEPTED SOLUTION
7 REPLIES
Senior Supporter

Re: TPT fails if data file contains a single row

Teradata Employee

Re: TPT fails if data file contains a single row

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.

 

-- SteveF

Re: TPT fails if data file contains a single row

sent. please note the data file has a new line at the end of the row.
Teradata Employee

Re: TPT fails if data file contains a single row

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.

 

Thanks!

-- SteveF
Teradata Employee

Re: TPT fails if data file contains a single row

Ok, I had a mixup in the versions of TPT on my VM.

I was running 15.10.00.04, not 15.10.01.04.

The problem was indeed fixed in 15.10.00.09 and 15.10.01.01.

 

-- SteveF

Re: TPT fails if data file contains a single row

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.

Re: TPT fails if data file contains a single row

Hi,

 

The client upgraded to TPT version 15.10.01.06 and the problem went away.

 

Thanks for the help Steve.