Loading

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

Publish Date: Apr 13, 2024
Description
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


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

This error can also occur on Amazon Redshift on Windows. Please refer to this article if you are experiencing this error on WIndows. 
Additional Resources
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.
Knowledge Article Number

001473523

 
Loading
Salesforce Help | Article