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.

Regards,

Victor