Teradata Parallel Transporter - error with automatic schema

Tools & Utilities

Teradata Parallel Transporter - error with automatic schema

Using Teradata parallel transport with simplified syntax we get error 

TPT02638: Error: Conflicting data length for column(3) - "sr_abo_netto_do_oferty". Source column's data length (16) Target column's data length (8).

Source table:

CREATE SET TABLE DB_APL_CM_TEMP.tt_konwersje_oferty ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
oferta_id INTEGER,
linia VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
sr_abo_netto_do_oferty DECIMAL(20,2),
karencja INTEGER,
oferta_kat VARCHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
sr_subsydium DECIMAL(20,2),
data_wstawienia DATE FORMAT 'YY/MM/DD',
oferta_nazwa VARCHAR(60) CHARACTER SET UNICODE NOT CASESPECIFIC,
abo_brutto DECIMAL(20,2),
nr_oferty BYTEINT)
PRIMARY INDEX ( oferta_id );

Target table:

CREATE SET TABLE DB_APL_CM_TEMP.tt_konwersje_oferty ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
oferta_id INTEGER,
linia VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
sr_abo_netto_do_oferty DECIMAL(20,2),
karencja INTEGER,
oferta_kat VARCHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
sr_subsydium DECIMAL(20,2),
data_wstawienia DATE FORMAT 'YY/MM/DD',
oferta_nazwa VARCHAR(60) CHARACTER SET UNICODE NOT CASESPECIFIC,
abo_brutto DECIMAL(20,2),
nr_oferty BYTEINT)
PRIMARY INDEX ( oferta_id );

Script:

Set SelectStmt = 'LOCKING TABLE DB_APL_CM_TEMP.tt_konwersje_oferty FOR ACCESS SELECT * FROM DB_APL_CM_TEMP.tt_konwersje_oferty ';
SET SourceTdpId = 'dbc';
SET SourceUserName = 'QA_ROOT';
SET SourceUserPassword = '********';

/* LOAD */
SET TargetTable = 'DB_APL_CM_TEMP.tt_konwersje_oferty';
SET TargetTdpId = 'dbi';
SET TargetUserName = 'QA_ROOT';
SET TargetUserPassword = '********';

/* LOAD SPECIFIC */
SET LogTable = 'QA_ROOT_TPP_WD.LT_tt_konwersje_oferty';
SET ErrorTable1 = 'QA_ROOT_TPP_WD.ET_tt_konwersje_oferty';
SET ErrorTable2 = 'QA_ROOT_TPP_WD.UV_tt_konwersje_oferty';

USING CHAR SET ASCII
DEFINE JOB TransferData
(
APPLY $INSERT
TO OPERATOR ( $LOAD )
SELECT *
FROM OPERATOR ( $EXPORT );
);

Teradata Parallel Transporter Version 15.00.00.00