KNOWLEDGE BASE

Error "Fetch size 2048 exceeds the limit of 1000 for a single node configuration" When Opening Redshift Views


Published: 16 Jun 2017
Last Modified Date: 10 Jan 2020

Issue

After upgrading Tableau Sever, when opening published views which use a Redshift data source, the following error occurs: 

ERROR: Fetch size <value> exceeds the limit of 1000 for a single node configuration. Reduce the client fetch/cache size or upgrade to a multi node installation.;
Error while executing the query


 

Environment

  • Tableau Server
  • Amazon Redshift

Resolution

Install the most recent version of the Amazon Redshift driver on the computer running Tableau Server. See Driver Download; for more information. 

Additional Information

The odbc configuration file located at /etc/odbcinst.ini must include the information provided on our driver downloads page:
 
[Amazon Redshift (x64)]
Description=Amazon Redshift ODBC Driver(64-bit)
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so

Logs may indicate that Tableau Server attempts to use a PostgreSQL driver to connect to Redshift. If this is the case, request to see the file to confirm that the Redshift driver is listed in the odbcinst.ini file; otherwise Tableau Server will revert to the most relevant ODBC driver it has available in that file.

Discuss this article... Feedback Forum
Did this article resolve the issue?