Archives of the TeradataForum

Message Posted: Tue, 29 Jan 2013 @ 20:57:31 GMT

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

TD v13 on Windows,

Dear experts,

Could you tell me why I get an error in running a TPT? Thank you in advance.

1. TPT script

     /**************************************************************/
     /*
     /* Teradata Parallel Transporter
     /*
     /**************************************************************/
     /* Description: 7
     /*
     /* This example script uses two job steps.
     /*
     /* The first job step, called "Setup_Tables", uses the DDL
     /* Operator to setup the target table.
     /*
     /* The second job step, called "Load_Trans_Table", uses
     /* an instance of the DataConnector Operator to read
     /* rows from a file and uses an instance of the Load
     /* Operator to write the rows into an empty Teradata target
     /* table.
     /**************************************************************/
     DEFINE JOB FILE_LOAD
     DESCRIPTION 'Load a Teradata table from a file'
     (
     DEFINE SCHEMA Trans_n_Accts_Schema
     (
     ident VARCHAR(30),
     i1    VARCHAR(30)
     );


     DEFINE OPERATOR DDL_OPERATOR
     TYPE DDL
     ATTRIBUTES
     (
     VARCHAR PrivateLogName,
     VARCHAR TdpId                 = '@TDPID',
     VARCHAR UserName             = @UserID,
     VARCHAR UserPassword         = @Password,
     VARCHAR AccountID,
     VARCHAR DataEncryption,
     VARCHAR LogonMech,
     VARCHAR LogonMechData,
     VARCHAR QueryBandSessInfo,
     VARCHAR ErrorList = '3807'
     );



     DEFINE OPERATOR FILE_READER
     TYPE DATACONNECTOR PRODUCER
     SCHEMA Trans_n_Accts_Schema
     ATTRIBUTES
     (
     VARCHAR PrivateLogName,
     VARCHAR DirectoryPath         = 'C:\xxxx\Teradata\TPT Practice 01',
     VARCHAR FileName             = 'testdata.txt',
     VARCHAR Format                 = 'Delimited',
     VARCHAR OpenMode             = 'Read',
     VARCHAR TextDelimiter         = ','
     );

     DEFINE OPERATOR LOAD_OPERATOR
     TYPE LOAD
     SCHEMA *
     ATTRIBUTES
     (
     VARCHAR PrivateLogName,
     VARCHAR TdpId                 = 'xxxxxxxx',
     VARCHAR UserName             = @UserID,
     VARCHAR UserPassword         = @Password,
     VARCHAR TargetTable         = 'abc.test01',
     VARCHAR SelectStmt            = 'sel * from abc.test01',
     VARCHAR ErrorTable1         = @ErrTbl1 ,
     VARCHAR ErrorTable2         = @ErrTbl2 ,
     VARCHAR LogTable            = @LogTbl
     );



     STEP Setup_Tables
     (
     APPLY
     ( 'del from abc.test01;'  )
     TO OPERATOR (DDL_OPERATOR);
     );


     STEP Load_Trans_Table
     (
     APPLY
     ( 'insert into abc.test01
     (ident,
     i1 )
     VALUES
     (:ident,
     :i1 );')

     TO OPERATOR (LOAD_OPERATOR[1])
     SELECT
     *
     FROM OPERATOR
     (FILE_READER[1]);
     );
     );

2. Output

     Teradata Parallel Transporter Version 13.10.00.04 Job log: ./load1exe-181.out Job id is
     load1exe-181, running on WITDL140 Found CheckPoint file: C:\Program
     Files\Teradata\client\13.10\Teradata
     Parallel
     Transporter/checkpoint\load1exeLVCP
     This is a restart job; it restarts at step Load_Trans_Table.
     Teradata Parallel Transporter DataConnector Version 13.10.00.04 FILE_READER Instance 1
     restarting.
     FILE_READER: TPT19008 DataConnector Producer operator Instances: 1 Teradata Parallel
     Transporter Load Operator Version 13.10.00.03
     LOAD_OPERATOR: private log not specified
     FILE_READER: TPT19003 ECI operator ID: FILE_READER-496
     LOAD_OPERATOR: connecting sessions
     LOAD_OPERATOR: preparing target table
     LOAD_OPERATOR: entering Acquisition Phase
     FILE_READER: TPT19222 Operator instance 1 processing file 'C:\JPARK\Teradata\TPT
     Practice 01\testdata.txt'.
     FILE_READER: TPT19350 I/O error on file 'C:\JPARK\Teradata\TPT Practice 01\testdata.txt'.
     FILE_READER: TPT19435 pmRead failed. EOF encountered before end of record
     (35)
     FILE_READER: TPT19305 Fatal error reading data.
     LOAD_OPERATOR: disconnecting sessions
     FILE_READER: TPT19221 Total files processed: 0.
     LOAD_OPERATOR: Total processor time used = '0.703125 Second(s)'
     LOAD_OPERATOR: Start : Tue Jan 29 15:25:50 2013
     LOAD_OPERATOR: End   : Tue Jan 29 15:26:02 2013
     Job step Load_Trans_Table terminated (status 12) Job load1exe terminated (status 12)

3. input file

     135,123433789012345
     134,123456789012345
     125,1892345567
     123,1234567
     127,18899234567
     136,129363378901345
     126,18992345567
     124,2345567
     289,4444444
     299,555555
     400,6666666

James Park
Database Specialist II

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