All Forums Tools
M.M@TD 16 posts Joined 03/13
08 Jan 2014
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 !
 
 
 

ratchetandclank 49 posts Joined 01/08
14 Jan 2014

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.

feinholz 1234 posts Joined 05/08
15 Jan 2014

May I ask where you got these attribute names from?
 
VARCHAR RecordErrorFilePrefix='tablename_err.dat',
VARCHAR RecordErrorVerbosity ='Med',

--SteveF

M.M@TD 16 posts Joined 03/13
17 Jan 2014

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 .
 
 
 
 
 

feinholz 1234 posts Joined 05/08
17 Jan 2014

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@TD 16 posts Joined 03/13
17 Jan 2014

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.

feinholz 1234 posts Joined 05/08
17 Jan 2014

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

--SteveF

You must sign in to leave a comment.