KNOWLEDGE BASE

Data Sources Fail to Publish and Extracts Fail to Refresh After upgrading to Tableau Server 2022.1.5


Published: 01 Sep 2022
Last Modified Date: 08 Sep 2022

Issue

After upgrading to Tableau Server 2022.1.5 in a multi-node environment, all extract and data source refresh attempts fail. 

The following error message can be seen in the logs: 

java.lang.RuntimeException: encountered issue for storing separate reduced tdsx for site: 'x' datasource: 'xxxxx'

Attempts to publish data sources also fail with the following error message:

Internal Server Error: Tableau Runtime Exception

Environment

  • Tableau Server 2022.1.5
  • Multi-node environments

Resolution

Option 1

  • Upgrade to Tableau Server 2022.1.6 or later.


Option 2

Take the following steps. These steps may be taken with Tableau Server running.

Windows - The steps below assume Tableau Server is installed in the default location. 
1. Make a backup copy of the C:\Program Files\Tableau\Tableau Server\packages\tdsservice.20221.22.0823.1450\tdsservice.war-classpath.json file
2. Download the tdsservice.war-classpath.json file attached to this article
3. Copy the downloaded tdsservice.war-classpath.json file  to  C:\Program Files\Tableau\Tableau Server\packages\tdsservice.20221.22.0823.1450\ and overwrite the existing file
4. Open an administrative command prompt
5. Copy the the netty jars from the C:\Program Files\Tableau\Tableau Server\packages\vizportal.20221.22.0823.1450 to C:\Program Files\Tableau\Tableau Server\packages\tdsservice.20221.22.0823.1450 
copy "C:\Program Files\Tableau\Tableau Server\packages\vizportal.20221.22.0823.1450\netty*" "C:\Program Files\Tableau\Tableau Server\packages\tdsservice.20221.22.0823.1450\"
6. Run the following command to uninstall tdsservice 
"C:\ProgramData\Tableau\Tableau Server\data\tabsvc\services\tdsservice_0.20221.22.0823.1450\uninstall.cmd"
7. Run the following command to install tdsservice 
"C:\ProgramData\Tableau\Tableau Server\data\tabsvc\services\tdsservice_0.20221.22.0823.1450\install.cmd"
8. Run the following command to enable tdsservice 
"C:\ProgramData\Tableau\Tableau Server\data\tabsvc\services\tdsservice_0.20221.22.0823.1450\enable.cmd"

Repeat steps 1-8 on each node with Data Source Properties Service configured
Linux - The steps below assume Tableau Server is installed in the default location. 
1. Make a backup copy of the /opt/tableau/tableau_server/packages/tdsservice.20221.22.0823.1450/tdsservice.war-classpath.json file
2. Download the tdsservice.war-classpath.json file attached to this article
3. Copy the downloaded tdsservice.war-classpath.json file to  /opt/tableau/tableau_server/packages/tdsservice.20221.22.0823.1450/ and overwrite the existing file
sudo cp ./tdsservice.war-classpath.json /opt/tableau/tableau_server/packages/tdsservice.20221.22.0823.1450/
4. Copy the the netty jars from the /opt/tableau/tableau_server/packages/vizportal.20221.22.0823.1450/ to /opt/tableau/tableau_server/packages/tdsservice.20221.22.0823.1450
sudo cp /opt/tableau/tableau_server/packages/vizportal.20221.22.0823.1450/netty* /opt/tableau/tableau_server/packages/tdsservice.20221.22.0823.1450/
5. Login as the unprivileged user, by default tableau 
sudo su -l tableau
6. Run the following command to uninstall tdsservice 
/var/opt/tableau/tableau_server/data/tabsvc/services/tdsservice_0.20221.22.0823.1450/uninstall.sh
7. Run the following command to install tdsservice 
/var/opt/tableau/tableau_server/data/tabsvc/services/tdsservice_0.20221.22.0823.1450/install.sh
8. Run the following command to enable tdsservice 
/var/opt/tableau/tableau_server/data/tabsvc/services/tdsservice_0.20221.22.0823.1450/enable.sh

Repeat steps 1-8 on each node with Data Source Properties Service configured

Cause

This behavior is related to a Known Issue with ID 1454344 which is resolved in version 2022.1.6 and newer.
Did this article resolve the issue?