TPT Error TPT19104 VARCHAR field length error in column 1 . Rece ived 771 (max 20) on record 1.

Tools

TPT Error TPT19104 VARCHAR field length error in column 1 . Rece ived 771 (max 20) on record 1.

Job log: C:\Program Files\Teradata\client\13.10\Teradata Parallel Transporter/lo

gs/nbhupathiraju-64.out

Job id is nbhupathiraju-64, running on R92LTR3

Found CheckPoint file: C:\Program Files\Teradata\client\13.10\Teradata Parallel

Transporter/checkpoint\nbhupathirajuLVCP

This is a restart job; it restarts at step MAIN_STEP.

Teradata Parallel Transporter Update Operator Version 13.10.00.02

Teradata Parallel Transporter DataConnector Version 13.10.00.02

W_1_o_WKLY_STOCK_STATUS: private log not specified

W_0_o_WKLY_STOCK_STATUS Instance 1 restarting.

W_0_o_WKLY_STOCK_STATUS: TPT19008 DataConnector Producer operator Instances: 1

W_0_o_WKLY_STOCK_STATUS: TPT19003 ECI operator ID: W_0_o_WKLY_STOCK_STATUS-3820

W_1_o_WKLY_STOCK_STATUS: connecting sessions

W_1_o_WKLY_STOCK_STATUS: preparing target table(s)

W_1_o_WKLY_STOCK_STATUS: entering Acquisition Phase

W_0_o_WKLY_STOCK_STATUS: TPT19222 Operator instance 1 processing file 'C:\Data\T

est.csv'.

W_0_o_WKLY_STOCK_STATUS: TPT19104 VARCHAR field length error in column 1 .  Rece

ived 771 (max 20) on record 1.

W_0_o_WKLY_STOCK_STATUS: TPT19350 I/O error on file 'C:\Data\Test.csv'.

W_1_o_WKLY_STOCK_STATUS: disconnecting sessions

W_0_o_WKLY_STOCK_STATUS: TPT19221 Total files processed: 0.

W_1_o_WKLY_STOCK_STATUS: Total processor time used = '0.28125 Second(s)'

W_1_o_WKLY_STOCK_STATUS: Start : Mon Sep 12 13:35:17 2011

W_1_o_WKLY_STOCK_STATUS: End   : Mon Sep 12 13:35:20 2011

Job step MAIN_STEP terminated (status 8)

Job nbhupathiraju terminated (status 8)

3 REPLIES

Re: TPT Error TPT19104 VARCHAR field length error in column 1 . Rece ived 771 (max 20) on record 1.

 I am getting the above error ... when I am trying load the data into a teradata table from a flat file (.csv); none of the files have values greater than 20 width;

Teradata Employee

Re: TPT Error TPT19104 VARCHAR field length error in column 1 . Rece ived 771 (max 20) on record 1.

Please provide me with the script, and a sample row from the .csv file.

Did you define your delimiter character correctly?

Looks like the file reader did not detect the delimiter character and possibly grabbed the entire first record and tried to apply it to the first column.

-- SteveF
N/A

Re: TPT Error TPT19104 VARCHAR field length error in column 1 . Rece ived 771 (max 20) on record 1.


yes,The reader takes the all column values as one column value.you need to separate the column values in .csv file