Monday, March 7, 2016

Unable to Connect to Published Data Sources When Opening a Downloaded Workbook from Tableau Server


I recently upgraded Tableau server from 9.1.2 to 9.1.3 to fix an issue with Data Server Data source. After upgrade we found below issue during the testing.

While opening a downloaded workbook from tableau server we received “Tableau Server Sign In” but URL greyed out and also URL is not correct as it is replaced by host name.


Normally you should receive a prompt to log in to the Tableau server, instead the server name field default to http://localhost and is unavailable for edit.

When we try to connect we got following error and not able to connect to published data source.

Cannot connect to Tableau Server. Please check the server name and port and try again. Internet communication error: SSL peer certificate or SSH remote key was not OK (analysis-server1)



It looks like the tableau server is not configured to recognize all the alias host names used to connect to the server. I have followed below steps to update the URL and port and able to resolve the issue.


1. Open command prompt as an administrator and go to the Tableau Server bin folder.
cd C:\Program Files\Tableau\Tableau Server\9.1\bin
2. Run the following command:
tabadmin set gateway.public.host "name"

where name is the URL used to connect to Tableau Server. For example:
tabadmin set gateway.public.host "analysis.oracleracexpert.com" 

3. If Tableau Server is configured for SSL, you must also run the following command:
tabadmin set gateway.public.port 443

4. Apply the configuration changes, and restart Tableau Server using following commands
tabadmin config
tabadmin restart



If a load balancer or proxy is in front of Tableau Server, the headers are not set.  Please refer to the following Knowledge Base article for information on the required headers

Reverse Proxy Server URL Reverts to Internal URL

Regards,
Satishbabu Gunukula, Oracle ACE

6 comments:


  1. This is really a great post. Thank you for taking time to provide us some of the useful and exclusive information with us. Keep on blogging!!


    SEO Training in Chennai

    ReplyDelete
  2. I must be thankful for sharing your ideas.Thank you for the good writeup.its a brellint job.please visit here for more detail:
    Packers and Movers Delhi
    http://packers-and-movers-delhi.in/packers-and-movers-dwarka-delhi
    http://packers-and-movers-delhi.in/packers-and-movers-gurgaon
    http://packers-and-movers-delhi.in/packers-and-movers-ghaziabad

    ReplyDelete
  3. It is one of the awesome site in my view as far as my knowledge is concerned about this kind website. Thanks for sharing!
    Packers And Movers Gurgaon

    ReplyDelete