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: 08 Jul 2022

Issue

When connecting Amazon Redshift from Tableau Server with ODBC driver 1.4.27 or 1.4.34, 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 1.4.34
  • Linux

Resolution

Resolution:
Follow the below steps to upgrade the Amazon Redshift ODBC version to 1.4.40 (or newer) or 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.40 (or newer) or 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.40.1000-1.x86_64.rpm'
OR
download 'AmazonRedshiftODBC-64-bit-1.4.20.1001-1.x86_64.rpm'. 

On Ubuntu and Debian,
download 'AmazonRedshiftODBC-64-bit-1.4.40.1000-1.x86_64.deb'
OR
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.40.1000-1.x86_64.rpm
OR 
$ 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.40.1000-1.x86_64.deb
OR
$ 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.
Did this article resolve the issue?