Tableau Server became an Error Status after Importing and Applying Old Configuration and topology data to Tableau Server 2024.2

When backing up and restoring configuration files between different versions, it is best practice to import only the configuration using the "--config-only" options.

Example:

tsm settings import -f TS202301.json --force-keys --config-only

If you have already imported and applied the old configuration file to Tableau Server 2024.2.x and Tableau Server became an error status, Please try the following steps:

 1. Open a command prompt as an administrator and run the following command to stop Tableau Server.

tsm stop

    If the status of Tableau Server is shown as an error in the TSM Web UI, you can skip this step.

2. Execute the following script to stop the administrative services of Tableau Server.

• Linux: sudo /opt/tableau/tableau_server/packages/scripts.<Build number>/stop-administrative-services
• Windows: C:\Program Files\Tableau\Tableau Server\packages\scripts.<Build number>\stop-administrative-services.cmd

3. Edit the servicestate.json manually, delete the statements about statsservice. By default, servicestate.json located in the following directory:

• Linux: /var/opt/tableau/tableau_server/data/tabsvc/tabadminagent/0/servicestate.json
• Windows: C:\ProgramData\Tableau\Tableau Server\data\tabsvc\tabadminagent\0\servicestate.json

Example:

"statsservice.20242.24.0910.0334" : {
"configurationMTime" : 1728627111688,
"currentState" : "DEPLOY_FAILED",
"requestedState" : "DISABLED"
}

4. Reboot OS

5. Confirm TSM services started automatically

tsm status -v

6. Open a command prompt as an administrator and run the following command to change the number of Statistical Service to 0.

tsm topology set-process --count 0 --process statsservice --node <nodeName>

tsm pending-changes apply

7. Sign in to the Tableau Services Manager (TSM) web UI and go to the “Configuration” > “Topology” page. Then change the number of each of the processes to the same values before importing the topology, and then apply the changes.

• VizData Service
• VizData Native Service

    These two services were added from 2024.2. There is no topology data in the old configuration file you imported which caused the number of these two processes became 0 so we must add these processes back. As VizData Service and VizData Native Service is required for an installation of Tableau Server 2024.2.x.

8. Start Tableau Server