Unable to save dashboard to Spotfire library when the Data On Demand with in-DB connection is deleted.

Unable to save dashboard to Spotfire library when the Data On Demand with in-DB connection is deleted.

Enviroment:

Product: TIBCO Spotfire Desktop (standalone version)

Version:Prior to 6.5.3 HF 014 and 7.0.x HF 002

OS: All Supported Operating Systems

--------------------

Description:

Unable to save dashboard to Spotfire Library when the Data On demand with in-DB connection is deleted.

Symptoms

The following error is returned while trying to save the analysis to the library.

Error message: Could not publish

NullReferenceException at Spotfire.Dxp.Data:

Object reference not set to an instance of an object. (HRESULT: 80004003)

Stack Trace:

at Spotfire.Dxp.Data.OnDemand.ConnectorDataOnDemandSharedFunctions.GetLibraryDependenciesCore(ManagedDataConnection dataConnection)

at Spotfire.Dxp.Data.DataFunctions.DataFunctionImpl.GetLibraryDependencies()

at Spotfire.Dxp.Application.AnalysisApplication.AddDependencies(LibraryEntry entry, Document document)

at Spotfire.Dxp.Application.AnalysisApplication.SaveAs(LibraryEntry entry, Document document, LibraryItemMetadataSettings metadataSettings, DocumentSaveSettings saveSettings)

at Spotfire.Dxp.Forms.Application.FileUserActions.<>c__DisplayClass4.b__2()

at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

Cause:

This is a bug and is caused due to the removal of on-demand in-db data table but it does not clean up all the references from the analysis.

Resolution:

Apply the latest hotfx for 6.5.x and 7.x. as this issue was fixed in hotfix version 6.5.3 HF 014 and 7.0.x HF 002.