Tableau Support
...
| Server | Tableau Server version | Purpose | IP address | Hardware config | Windows version | Icinga | |
|---|---|---|---|---|---|---|---|
(tableau01) | 2021.4.10 (Nov 25, 2022) 2021.4.2 (July 13, 2022) 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 | 64GB RAM, 8 cores, 240GB storage | Windows Server 2016 Datacenter |
| |
(tableau01-dev) | 2021.4.10 (Sept 21, 2022) 2021.4.2 (April 29, 2022) 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 | 50GB RAM, 8 total processors (2 sockets x 4 cores each), 230GB storage | Windows Server 2016 | ||
| tableau-beta | 2021.4.10 (Sept 6, 2022) 2021.4.2 (Jan 13, 2022) 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 (temporarily increased to 150GB for latest upgrade) | Windows Server 2016 | ||
| tableau-ts | Desktop 2019.4 | Desktop terminal server | 10.200.96.32 | 12GB RAM, 2 cores | Windows Server 2016 Datacenter |
...
Microsoft Remote Desktop Connection (RDC) is used from the Macs to gain access to the servers. A similar program is used from Windows. You must be a member of the tableau-admins group to access the servers. Once logged in, open a Command Prompt to run the tabadmin command line program. NOTE 2018-12-11: TABADMIN WILL CHANGE IN 2018.2 ONWARD
https://help.tableau.com/current/server-linux/en-us/tsm.htm#commands
| command | command (2018.2+) | purpose |
|---|---|---|
tsm status tsm status -v | check whether server is running list status of each service | |
| tsm stop | stop server | |
| tsm start | start server | |
| tsm restart | restart server (stop then start) |
...
If you need to stop a background task (e.g. an extract refresh that is taking a long time, neither succeeding nor failing), the instructions here work well: https://community.tableau.com/docs/DOC-8920 (note: this problem can occur when a manual refresh is begun right before an automatic refresh starts)
Upgrading Server (admins) https://help.tableau.com/current/server/en-us/upgrade.htm
Consult with lab and BITS to plan upgrade schedule.
...
- 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).
- 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 by logging in on web (e.g. https://tableau01-dev.broadinstitute.org )
- (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
- Test backups & restores from prod to upgraded dev/beta by enabling and running Task Scheduler scripts on VM. .tsbak files are written to \\kr\Tableau_backups\Database\TABLEAU01-DEV, for example. Disable backups on non-production VMs. Disable all schedules on tableau-beta server.
- Update the version in the Server Summary table at the top of this page.
...