Highlighted
Micro Focus Expert
Micro Focus Expert
385 views

(OBR) Support Tip: Setting the Vertica ODBC ResultBufferSize to avoid data processing issues

In OBR 10.2x, 10.3x you may encounter an issue where stream steps are failing or data is not consitently processed.

One known issue that leads to this is an issue where the Vertica ODBC message buffer cannot accommodate the responses from the Vertica Database.

An example error that may be seen:

(loader.log): FATAL [ ABCBatchID:6453502, ABCStreamID:Core@Dim_K_CI_Bridge, ABCStepID:DataLoad_Core_Dim_K_CI_Bridge, ABCProcessID:6593209 ][K_CI_Bridge]:[unixODBC][Vertica][VerticaDSII] (10) An error occurred during query preparation: Multiple commands cannot be active on the same connection. Consider increasing ResultBufferSize or fetching all results before initiating another command. (SQL-HY000) ;return value: 19

To address the issue please refer to the OBR Troubleshooting Guide (Error: Multiple commands cannot be active on the same connection).

In addition to this change, if OBR is running on Linux you should also make the following change to $PMDB_HOME/config/vertica.ini:

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

to

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

Without this change the ODBC client is unable to locate the language file for error messages and any error that is returned will be meaningless.

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.