Job log: C:\Program Files\Teradata\client\13.10\Teradata Parallel Transporter/lo
Job id is nbhupathiraju-64, running on R92LTR3
Found CheckPoint file: C:\Program Files\Teradata\client\13.10\Teradata Parallel
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
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)
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;
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.
yes,The reader takes the all column values as one column value.you need to separate the column values in .csv file