Archives of the TeradataForum
Message Posted: Wed, 25 May 2005 @ 09:13:10 GMT
| Subj: || || Re: Error while importing a file in bteq |
| From: || || Victor Sokovin |
| ||In the data file i have the following text|| |
| ||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