Highlighted
Micro Focus Expert
Micro Focus Expert
303 views

(OBR) Support Tip: VPrepareError could not be found in the en-US locale

When there is an issue executing SQL via ODBC with OBR you may receive an error such as:

The error message VPrepareError could not be found in the en-US locale.

Check that /opt/vertica/lib64/en-US/VerticaMessages.xml exists

This usually means a failure of some kind has occurred (see ResultBufferSize post for one possible error) however the default OBR configuration references the wrong location for the languages file required to provide the error text.

To correct this modify {PMDB_HOME}/config/vertica.ini for the correct path thus:

[Driver]
ODBCInstLib=/usr/lib64/libodbcinst.so
ErrorMessagesPath=/opt/vertica

Any process which is failing after this change should report the actual error so that you can handle it accordingly.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.