How to manually refresh the data connection cache on TIBCO Spotfire Web player when caching settings are done through data connections

How to manually refresh the data connection cache on TIBCO Spotfire Web player when caching settings are done through data connections

The data retrieved from a data connection can be cached as per the settings found here:

For TIBCO Spotfire 7.14.0 and lower:

• Edit > Data Connection Properties > Data Connection Settings > Cache Settings.

For TIBCO Spotfire 10.0.0 and higher:

• Data> Data Connection Properties > Data Connection Settings > Cache Settings

If the data has already been cached by the report since it was loaded on the Web Player and set to expire at 1:00 AM the next day (for example), but the data needs to be refreshed before then (perhaps the daily update of data in the data source was late), this is a method to force a new load and cache of the data. The data connection cache cannot be overwritten before it expires if it is already present on TIBCO Spotfire Web Player. As a workaround, you can perform the following steps to force a reload and re-cache of the data:

1. Open the TIBCO Spotfire Analyst with a new session (this will load fresh data)
2. For TIBCO Spotfire 7.14.0 and lower:

• Go to Edit > Data Connection Properties > Data Connection Settings > Cache Settings and change the cache expiration time (this will generate new cache) and click OK. 

    For TIBCO Spotfire 10.0.0 and higher:

• Go to Data > Data Connection Properties > Data Connection Settings > Cache Settings and change the cache expiration time (this will generate new cache) and click OK.

3. Save the analysis

Now open the analysis on TIBCO Spotfire Web Player and the new data will be loaded and the cache will be updated. Doc: Details on Data Connection Settings – Cache Settings

• https://docs.tibco.com/pub/sfire-analyst/10.10.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connect/connect_details_on_data_connection_settings_cache_settings.htm