Skip to main content
Question

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

  • December 11, 2017
  • 1 reply
  • 8 views
Abhishek_2
Forum|alt.badge.img+1

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

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • December 12, 2017

    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?

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement