(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:
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.