AcuXDBC ERROR: VISION: Cannot open 'SYSTEM%DUAL',File not found

While attempting to load the XFD files to the System Catalog, we get the “ERROR: VISION: Cannot open 'SYSTEM%DUAL',File not found” error message.

You need to do the following in this sequence:

                genxconf

                ainit                      

The genxconf command creates the configuration file with the correct file prefixes.

The ainit command runs the cview.sql command which creates the table dual which is intended to be used as a single table for commands such as "SELECT USER() FROM DUAL".

After that users can load the XFDs to the System Catalog.