Tableau Support
...
tableau-admins@broadinstitute.org (group of Analytics and BITS staff to ask or alert regarding downtime)
...
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 server 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 | ||
|---|---|---|---|---|---|---|---|---|
(tableau01) | 2019.4.4 (June 12, 2020) 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 According to whatsmyip My Public IPv4 is: 69.173.127.109 | 40GB RAM, 8 cores, 240GB storage | Windows Server 2016 Datacenter |
| ||
(tableau01-dev) | 2019.4.4 (May 8, 2020) 2018.1.18 (November 4, 2019) 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 | 69.173.127.108 | 32GB RAM, 8 total processors (2 sockets x 4 cores each), 230GB storage | Windows Server 2016 |
| ||
| tableau-beta | 2019.4.4 (March 9, 2020) 2019.4.2 (January 24, 2020) 2019.4.1 (January 7, 2020) 2019.3.0 (December 12, 2019) 2018.1.18 (October 25, 2019) 2018.1.17 (September 25, 2019) 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 | 192.168.196.21 | 32GB RAM, 8 cores, 120GB storage | Windows Server 2016 | |||
| tableau-ts | Desktop 2018.1 | Desktop terminal server | 10.200.96.32 | 12GB RAM, 2 cores | Windows Server 2016 Datacenter |
...
| Script | Purpose | tableau | tableau-dev | tableau-beta |
|---|---|---|---|---|
tableau-backup tableau-cleanup | copy logs and data to \\krypton\TABLEAU_Backups remove old logs and data (>30 days) | 130a | 100a (logs only)100a (logs only) | n/a |
| tableau-restore-from-prod | restore production data onto server | n/a | 230a230a | n/a |
| Time | Events |
|---|---|
| 100a | tableau-dev and tableau-beta stop, backup their logs, and restart |
| 130a | tableau stops, backs up its production logs and data, and restarts |
| 230a | tableau-dev and tableau-beta stop, restore production data, and restart |
...
- 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.
...
Broad's Tableau Servers run on Windows Server 2008 R2 (aka Windows NT 6.1). Tableau will require Windows Server 2012 starting in 2020 and Windows Server 2016 starring in 2021.Datacenter