TPT_INFRA: TPT03586: Warning: the rightmost 63990 characters (bytes) of the values of column Col1 will be truncated on a

Tools
Enthusiast

TPT_INFRA: TPT03586: Warning: the rightmost 63990 characters (bytes) of the values of column Col1 will be truncated on a

Hi, can anyone help with this issue. User's job is failing with the following warnings.

TPT_INFRA: TPT03586: Warning: the rightmost 63990 characters (bytes) of the values of column Col1 will be truncated on assignment.

TPT_INFRA: TPT03586: Warning: the rightmost 63985 characters (bytes) of the values of column Col2 will be truncated on assignment.

TPT_INFRA: TPT03586: Warning: the rightmost 63995 characters (bytes) of the values of column Col3 will be truncated on assignment.

TPT_INFRA: TPT03586: Warning: the rightmost 63995 characters (bytes) of the values of column Col4 will be truncated on assignment.

.

.

.

TPT_INFRA: TPT03586: Warning: the rightmost 63997 characters (bytes) of the values of column Col5 will be truncated on assignment.

.Teradata Parallel Transporter FastLoad INMOD Adapter Version 13.10.00.13

Teradata Parallel Transporter Load Operator Version 13.10.00.04

W_O_1_TPT_LOAD_INMOD: private log not specified

W_O_1_TPT_LOAD_INMOD: connecting sessions

W_O_1_TPT_LOAD_INMOD: preparing target table

W_O_1_TPT_LOAD_INMOD: entering Acquisition Phase

W_O_1_TPT_LOAD_INMOD: entering Application Phase

W_O_1_TPT_LOAD_INMOD: Statistics for Target Table:  'TABLE_X'

W_O_1_TPT_LOAD_INMOD: Total Rows Sent To RDBMS:      6264

W_O_1_TPT_LOAD_INMOD: Total Rows Applied:            6264

W_O_1_TPT_LOAD_INMOD: disconnecting sessions

The warnings are on every column of the table and as you can see from table DDL, the cols are very small in terms of length

CREATE SET TABLE TABLE_X ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      COL1 CHAR(10) CHARACTER SET LATIN CASESPECIFIC,

      COL2 CHAR(15) CHARACTER SET LATIN CASESPECIFIC,

      COL3 CHAR(5) CHARACTER SET LATIN CASESPECIFIC,

      COL4 CHAR(3) CHARACTER SET LATIN CASESPECIFIC,

      COL5 CHAR(1) CHARACTER SET LATIN CASESPECIFIC,

      COL6 CHAR(10) CHARACTER SET LATIN CASESPECIFIC,

      COL7 CHAR(3) CHARACTER SET LATIN CASESPECIFIC,

      COL8 CHAR(6) CHARACTER SET LATIN CASESPECIFIC,

      COL9 DATE FORMAT 'YYYY-MM-DD' COMPRESS ,

      COL10 CHAR(6) CHARACTER SET LATIN CASESPECIFIC,

      COL11 DECIMAL(18,4),

      COL12 CHAR(8) CHARACTER SET LATIN CASESPECIFIC,

      COL13 DECIMAL(18,4),

      COL14 CHAR(8) CHARACTER SET LATIN CASESPECIFIC,

      COL15 DECIMAL(18,4),

      COL116 CHAR(1) CHARACTER SET LATIN CASESPECIFIC)

PRIMARY INDEX ( COL1 );

Thanks in advance