Error on Vantage while trying to read .txt file

I am getting this error while trying to open a file to read.
Screenshot 2024-03-12 at 2.27.15 PM

What does this error mean?

1 Like

Hi @kalomorich,

This error occurs when the file being read is empty, or if using a SQL query, then the target of the query is empty/key-value pairing is broken/the SQL syntax is incorrect. A file which only contains Column Headers is also considered empty, like the image below:

image

For the error text specifically, the “records” the error refers to are the data in the input file. Files are read from the “current record” which exists between the BOF and EOF, so if either of those return True during a read call, then an error is produced. BOF and EOF stand for “Beginning of File” and “End of File” respectively.

Thank you,
Dan

2 Likes