All Forums Tools
grzegorz_osik 2 posts Joined 11/15
02 Aug 2016
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

You must sign in to leave a comment.