Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 May 2005 @ 09:13:10 GMT

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

Subj:   Re: Error while importing a file in bteq
From:   Victor Sokovin

  In the data file i have the following text  

     > 7839
  Following is the error which i am getting  

     >  *** Growing Buffer to 18763
     >  *** Error: Import data size does not agree with byte length.
     >             The cause may be:
     >                 1) IMPORT DATA vs. IMPORT REPORT
     >                 2) incorrect incoming data
     >                 3) import file has reached end-of-file.
     >  *** Warning: Out of data.
     >  *** Finished at Wed May 25 11:42:45 2005

If you mean that there should be only one record in the file, check the file size. On Windows, it should be 6 byte; on Unix - 5 byte.

If the size is greater than that then you probably managed to add an "empty" record, which might have caused this problem. Sometimes, non- printable characters can get into the file. To see them you could use a hex editor, for example. The editor will help get rid of the unwanted characters.



  <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: 15 Jun 2023