System.Exception: Increase buffer size, buffer size is 8192, but row could be 32102

Abhishek_2

Post upgrading ADO.net drivers to vertica 8; from Vertica 5; COPY statements break with Follwoing error "System.Exception: Increase buffer size, buffer size is 8192, but row could be 32102".

Any help is appreciated.

Thanks,
Abhishek

Jim_Knicely

Hi,

In the Vertica 8.0 ADO.net driver, the "RowBufferSize" connection property was renamed to "ResultBufferSize". The default size of "ResultBufferSize" is 8192.

See:
https://my.vertica.com/docs/8.0.x/HTML/index.htm#Authoring/ConnectingToHPVertica/ClientADO/UpdatingADO.NETClientCodeFromPreviousDriverVersions.htm

Maybe change th value of ResultBufferSize?