Missing Data Issue while using opening the report

[Abhilesh Gupta]

if we open the dashboards by browser the data are not fetched and Spotfire prompts the error in the picture below (using the analyst there are no issues and the data are fetched correctly) 

tss-azumw21005.westeurope.azure.st.com-e4a66b68-42a7-4b4f-90b3-7e406833ae86-20240209061129.zip

[Dave Leigh]

Hi Abhilesh

We have seen this error with other customers.  It is usually caused by the HTTPS request to the Azure Databricks site being refused by a Web Proxy or Firewall.  In those cases the request was being redirected to a web page stating that the request was refused, which was an HTTP page for a human to read, hence the ODBC driver did not understand the response.

If this is the first time you are deploying to the Web Player, please confirm that the server in question has access to the following URLs as listed in the Installation Guide:

• https://login.microsoft.com/*
• https://<databse name>.azuredatabricks.net/*
   

If the Web Player was previously working and is now failing, then you should check with your IT team to see if any changes were made that would prevent the server accessing these URLs.

The Connector allows the Web Proxy settings to be specified for just Web Player connections, so this might also be required in your environment.

Cheers
Dave

[Abhilesh Gupta]

Hi Dave

we have checked our firewall configuration & it seems to be fine. We have also aligned the drivers on all the servers. 

But the issue is still persists. 

Could you please suggest.

[Fabien GRABHERR]

Thank you Dave,

I confirm that your idea was the correct one, we realized that some of the databricks URL were not reachable from node managers (and TSS as well by the way), and after fixing with network team problem is now solved.

Thanks for your usual efficient support.

Fabien