The On-Demand settings of dxp files created or modified in Spotfire 14.0 or 14.1 may under some conditions be lost

The On-Demand settings of dxp files created or modified in Spotfire 14.0 or 14.1 may under some conditions be lost

book

Article ID: KB0070525

calendar_today

Updated On:

Products Versions
Spotfire Analyst 14.0, 14.1

Description

The On-Demand settings of dxp files (analyses) that have been created or modified in Spotfire 14.0 (using any version below hotfix HF-007) or 14.1 (using any version below hotfix HF-003) may be lost.

The following are the conditions for the issue to occur:
1. An analysis containing a data table has been created that retrieves data from an Information Link, and is configured as On-Demand, using Information Model elements for On-Demand input settings.
Note: It doesn't matter in what version this was created (i.e. it can have been created in a pre-14.x version).
2. After the analysis was created, the On-demand input settings from the previous step have been altered to use other Information Model elements (columns) with the original ones no longer present in the Information Model.  
3. The analysis has been opened in the affected versions (Spotfire 14.0 (any version below hotfix HF-007) or 14.1 (any version below hotfix HF-003)) and saved again.
 
The result is that the existing On-Demand settings are lost, and attempting to view the On-Demand settings may result in an error like the following:  

2024-02-13T23:17:18,332+01:00 2024-02-13 22:17:18,332 root [88] WARN  Spotfire.Dxp.Application.WebView.WebViewDecoupling [(null)] - Decoupled WebViewRead failed for method 'GetProducerInformationAndSettings' of 'Spotfire.Dxp.Web.Forms.Data.Canvas.DataTablesCanvasWebView': Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
   at Spotfire.Dxp.Data.OnDemand.BaseDataOnDemandImpl.DataHistoryParameterVisitor.Visit(DataOnDemandFilterParameter parameter)
   at Spotfire.Dxp.Data.OnDemand.BaseDataOnDemandImpl.GenerateDataHistoryCore()
   at Spotfire.Dxp.Data.Producers.ExternalColumnProducer.GenerateDataHistory(Boolean includeChildProducers)
   at Spotfire.Dxp.Web.Forms.Data.Canvas.DataTablesCanvasWebView.GetProducerInformationAndSettings(DataTablesCanvas model, JsonBundle args)
   at Spotfire.Dxp.Web.Forms.Data.Canvas.DataTablesCanvasWebView.InvokeReadImpl(String method, String args, DataTablesCanvas snapshotNode, ReadContext context)

Environment

All

Resolution

To prevent further issues, make sure to upgrade to the latest available hotfixes:
  • For Spotfire 14.0 LTS, the issue has been addressed in hotfix HF-007
  • For Spotfire 14.1, the issue has been addressed in hotfix HF-003
Please refer to the hotfix page in the Spotfire community for more information and download links:
https://community.spotfire.com/articles/spotfire/list-of-hotfixes-for-tibco-spotfire-clients-analyst-web-player-consumer-business-author-and-automation-services/

NOTE: The hotfixes mentioned above prevent further issues, but the on-demand settings for any dxp files that are already affected must be repaired. If Library versioning is used, consider restoring an older version that has not been saved in any of the affected versions, or saving an older version as a separate file and manually comparing/copying On-Demand settings from it to the current version of the analysis.

Issue/Introduction

The On-Demand settings of dxp files (analyses) that have been created or modified in Spotfire 14.0 (using any version below hotfix HF-007) or 14.1 (using any version below hotfix HF-003) may be lost. Apply the latest hotfix to prevent further issues. Already affected dxp files need to be repaired.

Additional Information