All Forums Tools
kallu2020 13 posts Joined 03/14
20 Apr 2016
Suppressing TPT warnings

Just wanted to check if there is a way to supress warnings arised during TPTLOAD. Our requirement is to receive RC 0.

(we don't want to fix the warnings..fyi). Tried VARCHAR Errorlist/WarningList in FILE_READER and LOAD_OPERATOR sections but it's not helping. Could someone please suggest.
$ tbuild -f tptload_xyz.ctl xyz4
Teradata Parallel Transporter Version 14.10.00.10 
Job log: /opt/teradata/client/14.10/tbuild/logs/xyz4- 5227283.out
Job id is xyz4-5227283, running on ..
Teradata Parallel Transporter DataConnector Operator Version 14.10.00.10
FILE_READER: Instance 1 directing private log report to 'dataconnector_log-1'.
Teradata Parallel Transporter Load Operator Version 14.10.00.10
LOAD_OPERATOR: private log specified: load_log
FILE_READER: DataConnector Producer operator Instances: 1
FILE_READER: ECI operator ID: 'FILE_READER-10944852'
FILE_READER: Operator instance 1 processing file 'xyz.out'.
LOAD_OPERATOR: connecting sessions
LOAD_OPERATOR: preparing target table
LOAD_OPERATOR: entering Acquisition Phase
FILE_READER: TPT19003 TPT Exit code set to 4.   ------> Warning
LOAD_OPERATOR: entering Application Phase
LOAD_OPERATOR: Statistics for Target Table:  'db.tab1'
LOAD_OPERATOR: Total Rows Sent To RDBMS:      2
LOAD_OPERATOR: Total Rows Applied:            2
LOAD_OPERATOR: Total Rows in Error Table 1:   0
LOAD_OPERATOR: Total Rows in Error Table 2:   0
LOAD_OPERATOR: Total Duplicate Rows:          0
LOAD_OPERATOR: disconnecting sessions
FILE_READER: Total files processed: 1.
LOAD_OPERATOR: Total processor time used = '0.432734 Second(s)'
LOAD_OPERATOR: Start : Wed Apr 20 20:45:51 2016
LOAD_OPERATOR: End   : Wed Apr 20 20:46:28 2016
Job xyz4 completed successfully, but with warning(s). 
Job start: Wed Apr 20 20:45:50 2016
Job end:   Wed Apr 20 20:46:28 2016

 

feinholz 1234 posts Joined 05/08
20 Apr 2016

No, there is currently no way to suppress warnings.
An exit code of '4' should be treated the same as a '0'. It is a successful job.
 

--SteveF

kallu2020 13 posts Joined 03/14
20 Apr 2016

Thanks steve.

kallu2020 13 posts Joined 03/14
20 Apr 2016

Is there any known issue with tptload attribute 'AcceptExcessColumns'? I am surprised to see the error inspite of setting this attribute to 'Y'.
"FILE_READER: TPT19134 !ERROR! Fatal data error processing file ...Delimited Data Parsing error: Too many columns in row 4."
Row 4 had more columns than what was given in schema definition of ctl.
However the test ran fine for less columns in a row, when AcceptMissingColumns is set to Y.
TPT version is 14.10.00.10
 

kallu2020 13 posts Joined 03/14
20 Apr 2016

Okay found the issue. There was a type that caused the issue. Thanks.

You must sign in to leave a comment.