Learning BI and Data Analytics Tools

 Backfill status https://<servername>/api/metadata/v1/control/backfill/status

1. Change the hyper.temp_space_timeout to 80% or so and preserve some space on your nodes.            tsm configuration set -k hyper.temp_disk_space_limit -v '80%' 2. Update the backgrounder.timeout_tasks to include the Web authoring tasks. https://help.tableau.com/current/server/en-us/cli_configuration-set_tsm.htm           tsm configuration set -k backgrounder.timeout_tasks -v "refresh_extracts, increment_extracts, single_subscription_notify, check_data_alert, generate_flow_model, run_flow, encrypt_extracts, decrypt_extracts, rekey_extracts, extract_encryption_maintenance, refresh_extracts_via_bridge, increment_extracts_via_bridge, extract_operations_maintenance, generate_thumbnails, update_metrics_for_view, upgrade_extract_storage, create_extracts_web_auth" 3. Run the following TSM commands to enable in-frame authentication:            tsm configuration set -k wgserver.saml.iframed_idp...

1. Mount EFS Mount point on all the nodes and provide the user id for tableau run the ownership on the mount.  2. stop the services using tsm stop   3. stop Administrative services on all nodes using below command.                /opt/tableau/tableau_server/packages/scripts.2021x.xx.xxxx.x/stop-administrative-services  4.Contact your infra team to change all tableau user id to same on all servers and change the ownership of files where the old UID and GID is the owner of them. IG GID is 991       U pdate UID and GID manually in /etc/passwd and /etc/group file      find / -group 991 -exec chgrp -h tableau {} \;         find / -user 991 -exec chown -h tableau {} \;         cd /etc/systemd/system/         cp -p user@ .service user@new_gid.service         chmod +x user@new_gid.service    ...

When Tableau Gateway services are not starting after restart and you see below error in the httpd log use the commands with root access replacing the version of gateway server version. (13)Permission denied: AH00072: make_sock: could not bind to address 0.0.0.0:80 no listening sockets available, shutting down setcap CAP_NET_BIND_SERVICE=+eip /u01/tableau/data/tabsvc/services/gateway_0.xx.xx.xx/apache/bin/httpd

 To find Mount points size on the servers. : df -k To find current directory size : du -sh To find the current subdirectories and file sizes of current directory: du -h To find the current subdirectories and file sizes of current directory with sort: du -h |sort -h

Text Renders As Square Boxes Instead Of Expected Non-English Character Issue: A text in a view becomes full of squares after publishing this view to Tableau Server, and the expected characters that were formatted and displayed correctly and nicely in Tableau Desktop can no longer be seen.  Resolution: Work with the Server Administrator or your IT team to perform the steps below: Install NOTO CJK fonts or another font package that contains the missing glyphs Run [tsm stop] command to shut down Tableau Server. Reboot Linux OS. Run [tsm start] command to start up Tableau Server.

Create Users using Tableau API and Python User file will be in the format of userid, roleof the user. user1,Explorer user2,Creator User3,Viewer import tableauserverclient as TSC import csv userfile= open('C:/Users/myartha/Documents/Python Files/users_06112020.csv') usr = csv.reader(userfile) sourceusers=[] createdusers=[] pat = 'PersonalAccessToken'  #your personal access token created on the UI server = TSC.Server('<servername>') # provide your server URL siteid='siteid'   #yoursiteid from the server. This is not the nameof the site but id of the site tokenName = 'UserGroupScript'  #provide your Token name used when creating personal access Token server.version='3.6' ta = TSC.PersonalAccessTokenAuth(token_name=tokenName, personal_access_token=pat, site_id=siteid) with server.auth.sign_in_with_personal_access_token(ta):     userlist, pagination_item=server.users.get()     for user in userlist:         sourceusers.append(u...