Archives of the TeradataForum

Message Posted: Tue, 28 May 2013 @ 19:00:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi ,

We recently upgraded to TD 13.10 from 13.00, we are having issue after the upgrade in the TPT.

In 13.00 if the Load ready file has 10 cols and table has 8 cols. Then the tpt would fail after reading the First record stating

Example

     Teradata Parallel Transporter Load Operator Version 13.00.00.08
     File_Loader: private log not specified
     File_Loader: connecting sessions
     File_Reader Operator instance 1 processing file '/wrk/prd/tmp/dw/icdw/Table_pipe'.
     File_Loader: preparing target table
     File_Loader: entering Acquisition Phase
     File_Reader: TPT19109 Data Schema Column count (56) conflicts with columns received (57) in record 1.
     File_Reader Total files processed: 0.
     File_Loader: disconnecting sessions
     File_Loader: Total processor time used = '0.111316 Second(s)'
     File_Loader: Start : Wed May 15 00:07:01 2013
     File_Loader: End   : Wed May 15 00:07:15 2013 Job step Load_Table terminated (status 8) Job Table_20130513 terminated (status 8)

But in 13.10 the tpt is reading the entire file and displaying the error message for each record in the file, as a result the logs are getting filled up , if the file has 1Million record the tpt is reading all the 1Million record and displaying the error message.

     Teradata Parallel Transporter DataConnector Version 13.10.00.08
     File_Reader: TPT19008 DataConnector Producer operator Instances: 1 Teradata Parallel Transporter Load Operator Version 13.10.00.04
     File_Loader: private log not specified
     File_Reader: TPT19003 ECI operator ID: File_Reader-33947666
     File_Loader: connecting sessions
     File_Reader: TPT19222 Operator instance 1 processing file '/wrk/prd/tmp/dw/icdw/TABLE1_pipe'.
     File_Loader: preparing target table
     File_Loader: entering Acquisition Phase
     File_Reader: TPT19350 I/O error on file '/wrk/prd/tmp/dw/icdw/TABLE1_pipe'.
     File_Reader: TPT19109 Data Schema Column count (28) conflicts with columns received (30) in record 1.
     File_Reader: TPT19350 I/O error on file '/wrk/prd/tmp/dw/icdw/TABLE1_pipe'.
     File_Reader: TPT19109 Data Schema Column count (28) conflicts with columns received (30) in record 2.
     File_Reader: TPT19350 I/O error on file '/wrk/prd/tmp/dw/icdw/TABLE1_pipe'.
     File_Reader: TPT19109 Data Schema Column count (28) conflicts with columns received (30) in record 3.
     .
     .
     File_Loader: Statistics for Target Table: 'ICDW_FL_EDW_W.DCM_OLM_FCT_DLY_PYMT_RQST1'
     File_Loader: Total Rows Sent To RDBMS:      7669
     File_Loader: Total Rows Applied:            0
     File_Loader: Total Possible Duplicate Rows: 7669
     File_Reader: TPT19221 Total files processed: 1.
     File_Loader: disconnecting sessions
     File_Loader: Total processor time used = '0.220126 Second(s)'
     File_Loader: Start : Sun May 19 21:29:26 2013
     File_Loader: End   : Sun May 19 21:31:03 2013 Job step Load_Table completed successfully Job TABLE1_20130518 completed successfully

     Error and UV Loader Table Count
     UV and ET table count
     ErrorFieldName                  ErrorCode     Count(*)
     Field1                         2679         4429
     Field2                        2665         3240

Is there any variable in tpt 13.10 than can be used, to come out of the script if we encounter some error in the first record itself.

Please advise.

Thanks,

Vijay Mani

	<Prev	Next>		<<First	<Prev	Next>	Last>>