TPT Error - Not able to get rows having incorrect format

Tools
M_M
Teradata Employee

TPT Error - Not able to get rows having incorrect format

Hi TPT Users,

I see there's some issue with the datafile that I have been trying to load.

I keep getting exit status 8 and exit status 12 whenever trying to load full file.

If I just try to load 1 rec from that datafile it is getting loaded.So I believe somewhere there is issue with the data that I have received in one of the record.

Now I am trying to find out that bad record.

I am using below variables

VARCHAR RecordErrorFilePrefix='tablename_err.dat',

VARCHAR RecordErrorVerbosity ='Med',

But the logfile says

     WARNING!  Definition of attribute RecordErrorFilePrefix ignored

     WARNING!  Definition of attribute RecordErrorVerbosity ignored

Any Idea Why ? All I am trying to achieve is to find the record with bad record format.

Please suggest !

6 REPLIES
Enthusiast

Re: TPT Error - Not able to get rows having incorrect format

The attribute you should use is RowErrFileName. If you mention this attribute, that the error record will be directed to the file name you mentioned value for the attribute RowErrFileName.

Teradata Employee

Re: TPT Error - Not able to get rows having incorrect format

May I ask where you got these attribute names from?

VARCHAR RecordErrorFilePrefix='tablename_err.dat',

VARCHAR RecordErrorVerbosity ='Med',

-- SteveF
M_M
Teradata Employee

Re: TPT Error - Not able to get rows having incorrect format

Thanks @ratchetandclank ! It worked.

Feinholz, I believe I found it in TPT pdf under operator attribute section and also in the tpt logfile.

I have next query, The err file does gets created but its empty.

Can you please suggest how can I verify what record has issues if it doesn't get even upto error table 1 and error table 2.

The job log says:

Load_DomesticEstablishments: preparing target table(s)

Load_DomesticEstablishments: entering Acquisition Phase

Load_DomesticEstablishments: disconnecting sessions

Load_DomesticEstablishments: Total processor time used = '2.90625 Second(s)'

Load_DomesticEstablishments: Start : Fri Jan 17 14:25:56 2014

Load_DomesticEstablishments: End   : Fri Jan 17 14:26:09 2014

Job step LOAD_TABLES terminated (status 12)

Any kind of input is highly appreciated .

Teradata Employee

Re: TPT Error - Not able to get rows having incorrect format

As "ratchet" mentioned, if you set the RowErrFileName attribute to a valid file name, the file reader will place the error rows into the file and continue processing.

When the job used to terminate with status code 8 or 12, what was the error you were getting?

-- SteveF
M_M
Teradata Employee

Re: TPT Error - Not able to get rows having incorrect format

I do see the file is created but it is 0 byte.

One more file "TPT_DCOP_RE_TMP_<User>_2.txt"gets created along with it which is also empty.

When job terminates with code 8 and 12 , no error message comes up..it just says connecting session and then disconnecting session.It happens during acquistion phase.

Feinholz, Would you like to see the complete logfile.

Teradata Employee

Re: TPT Error - Not able to get rows having incorrect format

Please send the complete .out file to steven.feinholz@teradata.com.

-- SteveF