Newbie, Tableau Server

@Tariq Aziz​ 

Hi, TSM restart would work for a limited time. Change in the configuration keys is more recommended. You will have to monitor the RAM use. I recommend it to be 70% at average. If after you change the configuration keys, you still have level over 70%, I would suggest to increase RAM.

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego Martinez

Tableau Visionary and Forums Ambassador

@Jonathan Lee​ 

1. Regarding your first question, I wonder if you have try the answer in this knowledge base article: https://kb.tableau.com/articles/issue/error-check-that-the-server-is-running-and-that-the-url-is-correct

2. The second question is interesting. Since Tableau Server is installed on premises, you could have several options:

a. Your current option is good, you are protecting your info with a VPN. Your info is protected by the VPN and by the Tableau login.

b. You could ask to your IT team, to create some forwarding rules (NAT) and be able to access your Tableau Server from the Internet. This would require, they assign you some subdomain (i.e. http://tableau.yourcompany.com) and to open firewall to external communications using ports 443, and 80.

Check this:

https://help.tableau.com/current/guides/everybody-install/en-us/everybody_admin_config_ssl.htm

If this post assists in resolving the question, please "Upvote" it or "Select as Best" if it resolves the question. This will help other users find the same answer/resolution. Thank you.

Diego

you can use "BINS" and "LOD", just need to create :

1. calculated field named Day : day([sales_date])
2. create bin from Day (right click from field Day and click Create and choose Bins) named Day_Bin
3. for size of bins, input 1
4. if you want to show value total sales per day then create calculated field using LOD (Level of Detail) and choose Fixed Function, named your new field with Total sales per Day

{Fixed Year([Sales_Date]),Month([Sales_Date]), Day_Bin:Sum(ifnull([Sales],0))}

and then in canvas colums you can put : Year([Sales_Date]),Month([Sales_Date]), Day_Bin

and in canvas rows you can put : sum([Total sales per Day])

Hi @Tariq Aziz​ ,

I would like to add one point here, first stop the Tableau server (tsm stop) before making any changes on the tableau server deployed machine, also make sure that the MAC address, IP address and hostname of the machine are static. Any change in these address will make Tableau server in degrade / unlicensed state because tableau server licenses are mapped with Mac address of the machine.

Thanks & Regards

D. Santosh

Based on the information provided, it seems like there are a few potential issues that could be causing the data-source connection issues with your Tableau Server and Databricks database:

1. IP Whitelisting: As you mentioned, there could be an issue related to IP whitelisting in the new AWS environment. Verify that the IP address of the Tableau Server is whitelisted on the Databricks database server and that the necessary ports are open.
2. Driver Version: The driver version on the server machines is different from the user machines, which could be causing compatibility issues. Make sure that the same version of the driver is installed on both the Tableau Server and the user machines.
3. Network Connectivity: The fact that the ping request to the database server timed out when coming from the production machine, but succeeded when coming from the QA machine, suggests that there may be network connectivity issues that are preventing the Tableau Server from reaching the Databricks database.
4. Firewall: Check if there is any firewall blocking the connection.
5. Permission: Check if the Tableau Server has the necessary permissions to access the Databricks database.
6. Configuration: Check if the ODBC driver is correctly configured and the necessary environment variables are set.
7. Third-Party Security : If you are running any third-party security solutions, check if it is blocking the connection.

You can try to troubleshoot the issue by checking the log files of the Tableau server and the Databricks database, as well as trying to connect to the database using a different tool (such as the Simba ODBC Driver Manager) to see if the issue is specific to Tableau Server.

You can also contact Tableau Support or Databricks Support for additional help in troubleshooting the issue.