Skip to content

Latest commit

 

History

History
184 lines (125 loc) · 4.04 KB

tableau.md

File metadata and controls

184 lines (125 loc) · 4.04 KB
Raw

Tableau

Tableau is a widely used visualization tool.

https://www.tableau.com/

Tableau User Authentication

Can use LDAP integration.

Often this will use your short form username of first letter of first name followed by surname, all lower case eg. for Hari Sekhon the username will be hsekhon.

Admin UI Port
8850

SSH Config

Add this SSH config block to your ~/.ssh/config to make SSH connections easier:

cat >> ~/.ssh/config <<EOF
Host tableau
  TCPKeepAlive yes
  ServerAliveInterval 300
  HostName x.x.x.x
  IdentityFile ~/.ssh/tableau-ec2-user.pem
  User ec2-user
EOF

then you can use the shortened SSH form of just:

ssh tableau

Tableau Server Administration

sudo su - tableauadmin
tsm status

output should look like:

Status: RUNNING

Edit the tableauadmin user's crontab:

crontab -e

and put this in it to clean up disk space every midnight:

0 0 * * * tsm maintenance cleanup -a

Troubleshooting

Disk Space

Logs

Logs were taking up 134GB out of 200GB root disk space causing disk full errors even on tsm maintenance cleanup -a and du | sort type commands.

/tmp was only a few KB but clearing that allowed the few KB for du | sort to work again:

sudo rm -fr /tmp/*

Found that this deeply embedded log path /var/opt/tableau/tableau_server/data/tabsvc/logs was taking up the space with 5500 log files.

Cleared logs older than 7 days to free up space:

find /var/opt/tableau/tableau_server/data/tabsvc/logs -type f -mtime +7 -exec rm -f {} \;

and added this cron to prevent it recurring:

0 0 * * * find /var/opt/tableau/tableau_server/data/tabsvc/logs -type f -mtime +7 -exec rm -f {} \;

but Tableau was still gave this next error in the web UI: Unable to proceed because of an error from the data source / Unable to connect to the Tableau Data Extract Server "" (which previously used to work).

Unable to proceed because of an error from the data source / Unable to connect to the Tableau Data Extract Server ""

Web UI still giving this error (used to work before out of disk space issue):

Unable to proceed because of an error from the data source

Try connecting again. If the problem persists, disconnect from the data source and contact the data source owner.

Try again

Could not find Hyper hosts to connect to.
Unable to connect to the Tableau Data Extract Server "". Check that the server is running and that you have access privileges to the requested database.

Tableau server still had error:

tsm status
The server encountered an unexpected error processing the request. Look at the server logs for more information.

See '/home/tableauadmin/.tableau/tsm/tsm.log' for more information.

tsm restart
Stopping service...

Service failed to stop properly.


See '/home/tableauadmin/.tableau/tsm/tsm.log' for more information.

500 - Server Error

Had to kill processes, but can't do this at tableauadmin since the processes are owned by tableau user switch to it from ec2-user:

sudo su - tableau

Do not kill -9, just regular kill to allow graceful termination and avoid risking data loss:

ps -ef |
grep '/tableau/tableau_server/' |
grep -v 'pgsql' |
awk '{print $2}' |
xargs kill
tsm stop
tsm start
Starting service...
Starting service...
The last successful run of StartServerJob took 11 minute(s).

Job id is '21', timeout is 30 minutes.