OBR loader process fails with "Consider increasing ResultBufferSize" error

  • KM02818363
  • 15-Jun-2017
  • 15-Jun-2017

Summary

OBR loader process fails with "Consider increasing ResultBufferSize" error

Error

In OBR 10.x the following error seen in loader.log

 

DBD::ODBC::db DESTROY failed: [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

Fix

To fix this problem add the below line in /opt/HP/BSM/PMDB/config/odbc.ini

 

ResultBufferSize = 0