KNOWLEDGE BASE

Error: "TableauException: INTERNAL ERROR" When Accessing a View with a Live Connection to Amazon Redshift


Published: 27 Oct 2015
Last Modified Date: 18 Nov 2016

Issue

When accessing a view on Tableau Server that has a live connection to an Amazon Redshift database, the following error might occur:  
"Unknown Server Error -- An unexpected error occurred. If you continue to receive this error please contact your Tableau Server Administrator. TableauException: INTERNAL ERROR"
 
Additionally, when attempting to connect to Amazon Redshift using Tableau Desktop, the following error might occur:
"Invalid timestamp value <timestamp>. The year must be in the range [range] excluding 0"

Environment

  • Tableau Server 
  • Tableau Desktop
  • Amazon Redshift

Resolution

Option 1

Contact the Database Administrator to rewrite the date formula in a proper format, such as: 
  • No date fields have a year value of 0000.
  • And/Or month/day/year rather than the time of the day.

Option 2

Ensure that the Amazon Redshift driver is properly installed on the computer running Tableau Desktop and/or Tableau Server, by using the links below. Prior to installing the new version, please uninstall any existing versions. 

Cause

These error can occur for different reasons: 
  • The database had a field that contained the date "0001-01-01 00:00:00". Tableau Server does not recognize a year value of 0000.
  • A date is being expected in the month/day/year format rather than the time of day.
  • A timezone change occurred after a data migration from a SQL Server to Amazon Redshift; which caused all datetime fields to shift by -7 hours. Therefore, it changed the aforementioned date to have a year value of 0000 (instead of 0001).
Did this article resolve the issue?