Datasource Not Reflecting a Structure Change on the Database After Being Replaced
Published: 25 Jul 2016
Last Modified Date: 10 Sep 2017
IssueWhen trying to upload a new data source to Tableau Online or Tableau Server to overwrite an old data source, and using this new data source to replace the old one in Tableau Desktop, workbooks behave as if they are still connected to the old published data source.
Additionally, the following behaviors can occur:
- The following error message might occur: "An error occurred while communicating with the data source: Invalid column name. Statement could not be prepared."
- New column names are not reflected.
- Workbook shows the new pill as red and an exclamation mark in front of the field in the dimensions pane; they these exclamation marks disappear after saving, closing and re-opening the affected workbook.
- Tableau Server 9.3.0 - 9.3.6, 10.0.0
- Windows Server 2012
- Microsoft SQL Server
- MAC OS
- Upgrade to Tableau Server 9.3.7, 10.0.1, 10.1 or a newer version. For more information, see Upgrade Tableau Server.
- After upgrading Tableau Server, open a command prompt as an administrator, navigate to the Tableau Server bin folder (located by default at C:\Program Files\Tableau\Tableau Server\<version>\bin) and enter the following commands:
tabadmin set DataServerRefreshMetadataPerSession true
CauseThis behavior is related to a known issue (ID: 524007) which has been corrected in more recent versions.
Additional InformationBecause the solution can have some performance trade-offs, the setting which corrects this issue (tabadmin set DataServerRefreshMetadataPerSession
) is turned off by default.