Web Player always times out when data reloads
I am using in-database approach of loading data into spotfire. There are two SQL queries which fetch data from the database and it requires date inputs which fetches data based on the date values entered by the user. There are no calculated columns in this report just simple data shown on tabular format and a few graps. The spotfire client works without any problem if I change the dates or reload the data. However when I deploy it in our spotfire servers and access web player in browser it loads the data initially but after I change the dates it gives it the error message at the bottom.
I have tried various configuration like Embed in Analysis, Save Loging Credenials with Connection Data Source and Save to Library to Cache Settings but nothing seems to work. I just need it to reload the data from database once the user changes the date just like it would on Spotfire client. Any advice is greatly appreciated.
Could not load on-demand data
The data source does not exist or it does not respond.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
SQL Server authentication
Update on this question :
I found the link below from Spotfire documentation https://docs.tibco.com/pub/spotfire/7.0.0/doc/html/data/data_overview.htm on Linked or Embedded Data it contains the paragraph below.
When you save data embedded, the Reload/Refresh options can be used to reload data from the original data source. This means that the embedded data may not necessarily be fixed and unchanged during the lifetime of an analysis. If a reload is done, then the latest data from the original source is fetched into the analysis. Hence, the analysis will contain a snapshot of the data from the latest time of refresh and save. Simply opening an analysis with embedded data will not cause a reload of the data.
Does it mean that if I save my analysis whose data contains records from let's say Jan 1 to Jan 5, once the web player is accessed by the user it will only hold data between Jan 1 to Jan 5 ? So if they choose another date like Jan 1 to Jan 4 or Jan 1 to Jan 6 it will not load the records contained on those date range becase it is not available on the analysis file( *.dxp ) ?
I wasn't able to make the date range load new data using the existing solution. What i did however was to query a whole month or whole year's data (not so efficient) and embed them in the analysis file. Then on my text area i have calculated columns which can filter dates in months or days. Another important thing I did when saving is to click on Review or Edit Settings it will show the Data Loading Settings window. On the window you can view how your Tables or Files are being loaded, on the dropdown for each Table or File I chose Stored Data or you can go to the bottom where it says "Change all applicable data sources to ... " then chose Stored Data in the dropdown and click ok. When I loaded the data in web player it is able to load all the data without any issues.
The only problem with this approach is that you would need to store huge amount of data in the analysis file which is not ideal because it would take time to load the web player. Also you can't fetch new data from the data source only archived information because it only saves the current state of data when you saved the analysis file.