ERROR: VISION: File abcd does not exist

0 Likes

This article explains why a table that should be loaded into syscat might not be available using AcuXDBC on a Linux operating system.

Problem:

A table is not available using AcuXDBC in a Linux environment. The .xfd file has been loaded, the FILE_PREFIX environment variable is correctly set, the Vision file is available, but AcuXDBC cannot see the table.

Using asql.sh, this is the error:

SQL (/? for help) ==> select count(*) from abcd;
select count(*) from art
***** ERROR: VISION: File 'abcd' does not exist

Resolution:

It's possible that the Vision file has an upper-case name, while the rest of the information (such as the table name inside the .xfd file) is lower-case.

Check the name of the Vision file, or set this variable in the acuxdbc.cfg file:

FILE_CASE UPPER

# Values for File_Case are Default (case ignored), 
# Lower (filename converted to lower case), and
# Upper (filename converted to upper case).
Old KB# 14213
Comment List
Related
Recommended