Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Sep 2004 @ 11:47:59 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Fastload/fastexport and length problem
 
From:   amarnath.ram

Hi,

What is the problem and how do I fix it?

Problem: The fastexport completes without any error. The fastload comes out with the following error.

     **** 23:18:42 Number of recs/msg: 220
     **** 23:18:42 Starting to send to RDBMS with record 1
     **** 23:18:42 Bad file or data definition.
     **** 23:18:42 The length of: SS_STATION in row: 1 was greater than
                   defined.
                   Defined: 50, Received: 6400
          -------------------------------------------------------------------
          =                                                                 =
          =          Logoff/Disconnect                                      =
          =                                                                 =
          -------------------------------------------------------------------

     **** 23:18:42 Logging off all sessions
     **** 23:18:42 Total processor time used = '0.43 Seconds'
          .        Start : Tue Sep 21 23:18:40 2004
          ..        End   : Tue Sep 21 23:18:42 2004
          .        Highest return code encountered = '12'.
     **** 23:18:42 FastLoad Paused

NOTE: The client and server machines are same. Even the fastload and fexp are used from the same tuf package tuf800.

=====

I am doing the fastexport of a table and trying to load the data using fastload.


Here is the Source table
--------------------------------------

     show table Dealer_sale_service_station;

      *** Text of DDL statement returned.
      *** Total elapsed time was 1 second.

     -------------------------------------------------------------------
     CREATE SET TABLE CSS.Dealer_sale_service_station ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           SS_station VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
           SS_stationid SMALLINT,
           SS_Emailid VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
           SS_Address VARCHAR(200) CHARACTER SET LATIN NOT CASESPECIFIC,
           SS_Phone VARBYTE(15))
     UNIQUE PRIMARY INDEX ( SS_stationid )
     UNIQUE INDEX ( SS_Phone );

Here is the Destination table
--------------------------------------

     show table Dealer_sale_service_tmp;

      *** Text of DDL statement returned.
      *** Total elapsed time was 1 second.

     --------------------------------------------------------------------
     CREATE SET TABLE CSS.Dealer_sale_service_tmp ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           SS_station VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
           SS_stationid SMALLINT,
           SS_Emailid VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
           SS_Address VARCHAR(200) CHARACTER SET LATIN NOT CASESPECIFIC,
           SS_Phone VARBYTE(15))
     UNIQUE PRIMARY INDEX ( SS_stationid );

Here is the fastexport script.
--------------------------------------

     .logtable css.css_logtbl;

     .logon leo/dbc,dbc;

     database css;

     .begin export;

     .export outfile Dealer_sale_service_station.fout format fastload;

     sel * from Dealer_sale_service_station;

     .end export;

Here is the fastload script:
--------------------------------------

     .sessions 2;

     .errlimit 2;

     .logon leo/dbc,dbc

     database css;

     DEFINE FILE=./Dealer_sale_service_station.fout;

     begin loading Dealer_sale_service_tmp errorfiles error_adsss,
     error_bdsss;

     insert into Dealer_sale_service_tmp.*;

     end loading;

     .logoff

     .quit

regards

Amar



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016