Error "Vertica VerticaDSII 20 An error occurred during query execution out of memory for query result" When Creating an Extract

Published: 22 Mar 2018
Last Modified Date: 05 Apr 2018


When creating an extract from Vertica, the following error might occur:

[Vertica][VerticaDSII] (20) An error occurred during query execution: out of memory for query result


  • Tableau Desktop 
  • Vertica


This error indicates that Vertica is running out of RAM when executing the query. Work with your Vertica admin to make the necessary adjustments. For more information, see Vertica - ResultBufferSize in the Vertica Documentation. 


This error is not specific to Tableau, it is being presented by Vertica and indicates that Vertica is running out of RAM while collecting the result set for the query.

Additional Information

It may be helpful to change the ResultBufferSize via a TDC customization if the resulting data set is excessively large. Consult with your Vertica Admin on the value for this buffer or for more information about this Vertica ODBC driver customization. 

Example TDC entry: Setting the ResultBufferSize to 3GB.

<customization name='odbc-connect-string-extras' value='ResultBufferSize=3000000000;' />
Important: Tableau does not test or support TDC files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining TDC files requires careful manual editing, and there is no support for sharing these files.
Did this article resolve the issue?