Tableau Support
...
Broad has three Tableau servers running concurrently on separate local VMs (two other machines run Tableau Desktop), which can be accessed via Remote Desktop (note that you'll often receive a warning that the certificates have the wrong names – this is okay). Reports published to the primary server are replicated onto both the dev and beta servers every night. If the primary server is unavailable, users can access all their same reports with live data using tableau-dev or tableau-beta. Icinga monitoring means BITS will be paged if the server goes down, so let tableau-admins know in advance if there is planned maintenance.
Server | Tableau Server version | Purpose | IP address | Hardware config | Windows version | Icinga |
---|---|---|---|---|---|---|
tableau | 2018.1.15 (July 26, 2019) 2018.1.6 (December 11, 2018) 10.4.11 (October 6, 2018) 10.4.10 (August 26, 2018) 10.4.7 (June 25, 2018) 10.3.11 (June 3, 2018) | primary production | 192.168.196.109 | 40GB RAM, 8 cores | Server 2008 R2 |
|
tableau-dev | 2018.1.16 (August 23, 2019) 2018.1.10 (April 4, 2019) 2018.1.8 (January 2, 2019) 2018.1.6 (December 11, 2018) 10.4.12 (October 17, 2018) | emergency backup | 192.168.196.49 | 32GB RAM, 8 cores | Server 2008 R2 |
|
tableau-beta | 2018.1.15 (July 25, 2019) 2018.1.14 (June 26, 2019) 2018.1.13 (June 18, 2019) 2018.1.12 (April 24, 2019) 2018.1.11 (April 4, 2019) 2018.1.10 (February 26, 2019) 2018.1.9 (February 2, 2019) 2018.1.8 (January 2, 2019) | testing | 69.173.67.31 | 32GB RAM, 8 cores | Server 2008 R2 | |
tableau-test | 2019.3 beta | evaluation | 192.168.196.21 | 32GB RAM, 8 cores | Server 2016 | |
tableau-ts-beta | Desktop 2018.1 | Desktop terminal server | 69.173.67.23 | 12GB RAM, 2 cores | NT 6.1 |
...
- On the target server you're going to upgrade, confirm that there are no current users: (e.g. https://tableau-dev.broadinstitute.org/#/server/analysis/ActionsbyRecentUsers)
- Log in to VM of target server (e.g. tableau-dev).
Command prompt: C:\> tabadmin stopIn the start menu, Add or Remove Programs, right click on Tableau Server & "uninstall" (this takes a while)- On target VM, navigate to the newly downloaded file, open it, accept all defaults during setup/installation.
- Paste in the User (e.g CHARLES\tableau_auth) & password (initialization takes quite a while)
- Once it's done (it'll try to launch IE), trash any *.tsbak from C:\ProgramData\Tableau\Tableau Server\ & any tabsvc.bak* from C:\ProgramData\Tableau\Tableau Server\data\ and empty the recycle bin.
- Ensure that the server is back online.
- (Major upgrade only) Start > Environmental Variables / System variables (Edit and change TABLEAU_BIN to C:\Program Files\Tableau\Tableau Server\#.#\bin) Save & Close.
- (Major upgrade only) Restart Windows to force PATH variable to re-source %TABLEAU_BIN%. Confirm updated path using "where tabadmin" command
- Test & validate reports on server, including backups & restores from prod to upgraded dev/beta.
- Update the version in the Server Summary table at the top of this page.
...