KNOWLEDGE BASE

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

Issue

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

Environment

  • Tableau Desktop 
  • Vertica

Resolution

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. 

Cause

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?