FILE_READER: TPT19157 Error while File to Stage Table Loading

Tools & Utilities

FILE_READER: TPT19157 Error while File to Stage Table Loading

Hi,

I am getting below error.

FILE_READER: TPT19157 Buffer Mode expected row length 151 does not match actual row length of 211.
Please let me know the pointer of the error.

 

 
Tech Tool :  "DYNAMIC-TPT-FILELIST” 


Please find below my TPT script. (14.10.00.12)


DEFINE JOB FILE_LOAD
DESCRIPTION 'Load a Teradata table from a file'
(
DEFINE SCHEMA XYZ
(
COL1 VARCHAR(10) ,
COL2 VARCHAR(60) ,
COL3 VARCHAR(10)
);
DEFINE OPERATOR DDL_OPERATOR
TYPE DDL
ATTRIBUTES (
VARCHAR TdpId = @tdpid,
VARCHAR UserName = @userid,
VARCHAR UserPassword = @password,
VARCHAR ErrorList = '3807'
);
DEFINE OPERATOR FILE_READER
TYPE DATACONNECTOR PRODUCER
SCHEMA XYZ
ATTRIBUTES
(
VARCHAR PrivateLogName='dataconnector_log',
INTEGER ErrorLimit = 1,
VARCHAR Format = 'Delimited',
VARCHAR TextDelimiter = '~|',
VARCHAR OpenMode = 'Read',
VARCHAR DateForm = 'ANSIDATE',
VARCHAR FileList = 'Y',
VARCHAR FileName = @v_file_list,
VARCHAR AcceptExccessColumns = 'y',
VARCHAR AcceptMissingCOlumns ='Y',
VARCHAR TruncateColumnData = 'Y',
VARCHAR AccessModuleName = '/opt/teradata/client/14.10/tbuild/lib/cp2uni_axm.so',
VARCHAR AccessModuleInitStr = 'CodePage=UTF8, ErrorChar=U+003F, EOR=0A'
);

/*********************************** Reader Operator Definition ***********************************/

DEFINE OPERATOR LOAD_OPERATOR
TYPE LOAD
SCHEMA *
ATTRIBUTES
(
VARCHAR PrivateLogName = 'load_log',
VARCHAR TdpId = @tdpid,
VARCHAR UserName = @userid ,
VARCHAR UserPassword = @password,
INTEGER TenacityHours = 4,
INTEGER TenacitySleep = 6,
INTEGER MaxSessions = @v_session,
INTEGER MinSessions = 2,
INTEGER ErrorLimit = 1,
VARCHAR TargetTable = 'x_stg.XYZ_FL',
VARCHAR LogTable = 'x_stg.LG_XYZ',
VARCHAR ErrorTable = 'x_stg.ET_XYZ',
VARCHAR DateForm = 'ANSIDATE'
);
STEP drop_table
(
APPLY
('DELETE FROM x_stg.XYZ_FL ALL ;'),
('drop table x_stg.LG_XYZ;'),
('drop table x_stg.ET_XYZ;'),
('drop table x_stg.UV_XYZ;')
TO OPERATOR (DDL_OPERATOR);
);
STEP XYZ
(
APPLY
('INSERT x_stg.XYZ_FL(
COL1,
COL2,
COL3
) VALUES (

:COL1 ,
:COL2 ,
:COL3 ,
);
')
TO OPERATOR (LOAD_OPERATOR[1])
SELECT
*
FROM OPERATOR(FILE_READER[4]);
);
);


Could you please provide pointers in resolving this issue ?

 

Special Note : When I am using Tech Tool as "DYNAMIC-TPT" it is running fine.

 

Thanks in advance.

 

Regards,Techie_A