KNOWLEDGE BASE

Error "Computing the current visualization has exceeded the resource limit" Occurs When Connecting Amazon Redshift With ODBC Driver 1.4.27 Or Newer


Published: 20 Jun 2021
Last Modified Date: 23 Aug 2021

Issue

When connecting Amazon Redshift from Tableau Server with ODBC driver 1.4.27 or newer, the following error occurs.

Resource Limit Exceeded
Computing the current visualization has exceeded the resource limit.
Use the back button to return to a valid view.

User-added image

Environment

  • Tableau Server 2021.1 or newer
  • Amazon Redshift ODBC driver version 1.4.27 or newer
  • Linux

Resolution

Workaround:
Follow the below steps to downgrade the Amazon Redshift ODBC version to 1.4.20 (or older).

1. Uninstall the currently installed Redshift ODBC driver.
Example:
On RHEL and RHEL-like Linux distributions
sudo rpm -evh AmazonRedshiftODBC-64bit

On Debian and Ubuntu Linux distributions
sudo apt-get remove --purge amazonredshift-64bit

2. Download Amazon Redshift ODBC driver version 1.4.20 (or older).
The previous version of the ODBC driver can be found on Amazon Redshift page. See Use previous ODBC driver versions in certain cases.

On RHEL-like distributions, including CentOS,
download 'AmazonRedshiftODBC-64-bit-1.4.20.1001-1.x86_64.rpm'. 

On Ubuntu and Debian,
download 'AmazonRedshiftODBC-64-bit-1.4.20.1001-1.x86_64.deb'

3. Install and configure the Redshift ODBC driver.
For detailed instructions, see Driver Download. Please select Redshift and Linux from the links.

On RHEL-like distributions, including CentOS,
$ sudo yum --nogpgcheck install AmazonRedshiftODBC-64-bit-1.4.20.1001-1.x86_64.rpm

On Ubuntu and Debian,
$ sudo gdebi AmazonRedshiftODBC-64-bit-1.4.20.1001-1.x86_64.deb

4.. Edit '/etc/odbcinst.ini' 

$ sudo vi /etc/odbcinst.ini

*You can copy and paste the below. 
[ODBC Drivers]
Amazon Redshift (x64)=Installed

[Amazon Redshift (x64)]
Description=Amazon Redshift ODBC Driver (64-bit)
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so

5.. Edit '/opt/amazon/redshiftodbc/lib/64/amazon.redshiftodbc.ini'  

$ sudo vi /opt/amazon/redshiftodbc/lib/64/amazon.redshiftodbc.ini

*You can copy and paste the below. 
[Driver]
## - DriverManagerEncoding is detected automatically.
##   Add DriverManagerEncoding entry if there is a need to specify.
ErrorMessagesPath=/opt/amazon/redshiftodbc/ErrorMessages
LogLevel=0
LogPath=/tmp
#SwapFilePath=/tmp
DriverManagerEncoding=UTF-16
ODBCInstLib=libodbcinst.so

6. Restart Tableau Server
tsm restart

Cause

The issue is related to the Redshift ODBC driver. It's under investigation by the Tableau development team currently.
Did this article resolve the issue?