TPT Load Issue: Column length overflow(s) in row 1.

Tools & Utilities

TPT Load Issue: Column length overflow(s) in row 1.

While execution getting error:  TPT19134 !ERROR! Fatal data error processing file 'C:\CAP\OTL_ARTOAR.txt'. Delimited Data Parsing error: Column length overflow(s) in row 1.

Also tried to give fixed length approach getting same error. Could you please give resolution for this issue. 

 

DEFINE JOB SAMPLE_FILE_LOAD
DESCRIPTION 'Load a Teradata table from a file'
(
DEFINE SCHEMA SCHEMA_AR
(
A VARCHAR(100) ,
B VARCHAR(32) ,
C VARCHAR(32) ,
D VARCHAR(32) ,
id VARCHAR(30) ,
date1 VARCHAR(40) ,
date2 VARCHAR(40) ,
date3 VARCHAR(40) ,
date4 VARCHAR(40) ,
flag VARCHAR(30) ,
id VARCHAR(34) ,
REOPN_DT VARCHAR(40) ,
EDW_STRT_TS VARCHAR(30) ,
EDW_END_TS VARCHAR(30) ,
SRC_STRT_TS VARCHAR(30) ,
SRC_END_TS VARCHAR(30) ,
FNL_RNWL_DT VARCHAR(200)
);

DEFINE OPERATOR op_AR
TYPE DATACONNECTOR PRODUCER
SCHEMA SCHEMA_AR
ATTRIBUTES
(
VARCHAR DirectoryPath='C:\CAP',
VARCHAR FileName = 'abx.txt',
VARCHAR Format = 'Delimited',
VARCHAR OpenMode = 'Read',
VARCHAR TextDelimiter =','
);

 

DEFINE OPERATOR ol_AR
TYPE LOAD
SCHEMA *
ATTRIBUTES
(

VARCHAR TruncateColumnData='YesWithoutLog',
VARCHAR TruncateColumns='Y',
VARCHAR TruncateLongCols='Y',
VARCHAR LogonMech ='',
VARCHAR PrivateLogName = 'load_log',
VARCHAR TdpId ='TDPID',
VARCHAR UserName ='',
VARCHAR UserPassword ='Password',
VARCHAR LogTable = '.yt_NEW_LG',
VARCHAR ErrorTable1 = 'xyz.yt_NEW_ET',
VARCHAR ErrorTable2 = 'xyz.yt_NEW_UV',
VARCHAR TargetTable = 'xyz.yt_NEW'
);


STEP stLOAD_FILE_NAME
(
APPLY
('INSERT INTO xyz.yt_NEW
(
,A
,B
,C
,D
,id
,date1
,date2
,date3
,date4
,flag
,id
,REOPN_DT
,EDW_STRT_TS
,EDW_END_TS
,SRC_STRT_TS
,SRC_END_TS
,FNL_RNWL_DT
)
VALUES
(
,:A
,:B
,:C
,:D
,:id
,:date1
,:date2
,:date3
,:date4
,:flag
,:id
,:REOPN_DT
,:EDW_STRT_TS
,:EDW_END_TS
,:SRC_STRT_TS
,:SRC_END_TS
,:FNL_RNWL_DT
);
')
TO OPERATOR (ol_AR)
SELECT * FROM OPERATOR(op_AR);
);
);

Tags (3)
1 REPLY
Teradata Employee

Re: TPT Load Issue: Column length overflow(s) in row 1.

It would really help if you would provide some more meaningful information.

The version of TPT would help.

Also, the row of data from the data file.

It is pretty hard to help without some details.

 

 

-- SteveF