Tuesday, April 28, 2020

Tableau Upgrade from 2019.2.5 to 2019.3.6


1.       Login to TSM service and bring down it from dos prompt.
C:\Users\admtableau> call tsm login -s https://indlbtap11.btorg.com-u admtableau -p Password123

C:\Users\admtableau> tsm stop

2.       Create a Backup of Tableau server (DATA + Installation directory)
C:\Users\admtableau> call tsm settings export -f D:\Backup\Tableau_Settings.json

C:\Users\admtableau> call tsm maintenance backup -file Tableau_Content_bkp -d --username admtableau --password Password123
3.       Current version is 2019.2.5
4.       Execute installer of 2019.3.6 as Administrator

 


It will locate and check the existing installation directory and extracts the system verification.
 





It will install the new binaries in the same existing installation directory.

 


This installation will be done at the same location with the earlier version no need to specify installation directory.
 







Select Automatically launch the upgrade script and click OK.





Entire log of the above command prompt-
Upgrading Tableau Server to version 20193.20.0323.1703. See log file at D:\Table
au_Server\logs\app-upgrade.log for progress.
Install directory D:\Tableau_Server
Config file: "D:\Tableau_Server\data\tabsvc\config\workgroup.yml"
Validating Tableau Server version.
Verifying that the new packages have been installed on all cluster nodes.
Stopping service...
Verifying Tableau Server is stopped.
Verifying that there is only one deployed Tableau Server Coordination Service en
semble.
Verifying that Tableau Server has been initialized.
Verifying licensing state.

Product usage data is enabled - by default the option to help us improve Tableau
 Server by sending us Tableau Server usage data has been enabled. You can disabl
e this on the TSM Maintenance page, or using the TSM command line. For more info
rmation about product usage data, see the help: https://onlinehelp.tableau.com/c
urrent/server/en-us/usage_data_server.htm

Reconnecting to asynchronous job...
Job id is '10', timeout is 60 minutes.
6% - Retrieving the topology to deploy.
13% - Retrieving the configuration to deploy.
20% - Validating the new topology.
26% - Determining if server needs to be started.
33% - Disabling all services.
40% - Waiting for the services to stop.
46% - Updating nodes to new topology.
53% - Waiting for topology to be applied.
60% - Updating nodes to new configuration.
66% - Disabling all services.
73% - Waiting for the services to stop.
80% - Reconfiguring services.
86% - Waiting for services to reconfigure.
93% - Enabling all services.
100% - Waiting for the services to start.
Backing up repository.
Upgrading TSM services.
Updating configuration.
Reconnecting to asynchronous job...
Job id is '11', timeout is 10 minutes.
Updating Tableau Server Coordination Service.
Updating Tableau Server Client File Service.
Generating new credentials.
Reconnecting to asynchronous job...
Job id is '12', timeout is 10 minutes.
16% - Generating password123s.
33% - Generating search server ssl certificate.
50% - Generating Elastic Server SSL certificate.
66% - Generating key store.
83% - Promoting configuration.
100% - Waiting for services to reconfigure.
Updating remaining services.
Updating Tableau Server Service Manager.
Restoring repository.
Updating repository version in Tableau Server Coordination Service.
Updating repository.
Reconnecting to asynchronous job...
Job id is '13', timeout is 120 minutes.
10% - Enabling the database services.
20% - Waiting for the database services to enable.
30% - Putting the repository into local trust mode.
40% - Creating roles and databases.
50% - Running migrations against the primary database.
60% - Setting the next active repository.
70% - Taking the repository out of local trust mode.
80% - Disabling database services.
90% - Waiting for database services to disable.
100% - Upgrading database
Updating asset keys.
Reconnecting to asynchronous job...
Job id is '14', timeout is 120 minutes.
100% - Checking if asset key upgrade is needed.
Rebuilding search index.
Reconnecting to asynchronous job...
Job id is '15', timeout is 120 minutes.
14% - Disabling all services.
28% - Waiting for the services to stop.
42% - Starting backup restore services for search server reset.
57% - Resetting search server.
71% - Starting search server.
85% - Configuring search server.
100% - Stopping backup restore services.
Reconnecting to asynchronous job...
Job id is '16', timeout is 120 minutes.
25% - Enabling the services required for indexing.
50% - Connecting to Vizportal Maintenance.
75% - Rebuilding the search index.
100% - Disabling the services used for indexing.
Updating data directory version.
Reconnecting to asynchronous job...
Job id is '17', timeout is 40 minutes.
6% - Retrieving the topology to deploy.
13% - Retrieving the configuration to deploy.
20% - Validating the new topology.
26% - Determining if server needs to be started.
33% - Disabling all services.
40% - Waiting for the services to stop.
46% - Updating nodes to new topology.
53% - Waiting for topology to be applied.
60% - Updating nodes to new configuration.
66% - Disabling all services.
73% - Waiting for the services to stop.
80% - Reconfiguring services.
86% - Waiting for services to reconfigure.
93% - Enabling all services.
100% - Waiting for the services to start.
Running post-upgrade steps on all cluster nodes.
Reconnecting to asynchronous job...
Job id is '18', timeout is 10 minutes.
33% - Installing backup services.
66% - Running post-upgrade.
100% - Uninstalling backup services.
Verifying licensing state.
Tableau Server has been upgraded to version 20193.20.0323.1703.

C:\Windows\system32>


Start Tableau Server. You can do this from the TSM web UI or from a command prompt:
 


 
 

From a command prompt:
    Open a command prompt as administrator. Enter this command:
C:\Users\admtableau> call tsm login -s https://indlbtap11.btorg.com -u admtableau  -p Password123
C:\Users\admtableau>tsm start
Starting service...
Job id is '19', timeout is 30 minutes.
Service was started successfully.

C:\Users\admtableau> 






 


Login to TSM web UI and re register.