Crash or error message when trying to save an analysis containing an SAP BW data source – Revvity Signals

Date Posted: 2019-05-24
Product: TIBCO Spotfire®

Problem:

Crash or error message when trying to save an analysis containing an SAP BW data source

Solution:

An analysis containing a SAP BW data source cannot be saved. Spotfire Analyst either crashes or an error message appears.

Example of error message:

Error message: Could not publish THE_NAME_OF_SOMETHING.
 
ArgumentException at mscorlib:
An item with the same key has already been added. (HRESULT: 80070057)

Stack trace when crashing:

Stack Trace:
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at Spotfire.Dxp.Data.Access.NamedValues.WriteToXml(XmlWriter writer)
   at Spotfire.Dxp.Xml.XmlExtensions.WriteElement(XmlWriter writer, String localName, IEnumerable`1 items)
   at Spotfire.Dxp.Data.Access.Modeling.VirtualJoinView.WriteToXmlCore(XmlWriter writer)
   at Spotfire.Dxp.Xml.XmlExtensions.WriteElement(XmlWriter writer, String localName, IEnumerable`1 items)
   at Spotfire.Dxp.Data.Access.Modeling.DataConnectionModelling.WriteToXmlCore(XmlWriter writer)
   at Spotfire.Dxp.Data.Access.Modeling.DataConnectionLink.WriteToXmlCore(XmlWriter writer)
   at Spotfire.Dxp.Data.Access.Modeling.DataConnection.WriteToXmlCore(XmlWriter writer)
   at Spotfire.Dxp.Xml.XmlExtensions.WriteElement(XmlWriter writer, String localName, IEnumerable`1 items)
   at Spotfire.Dxp.Data.Access.Modeling.DataAccessPlan.WriteToXmlCore(XmlWriter writer)
   at Spotfire.Dxp.Data.Access.Loader.DataArchiveReaderWriter.Write(DataAccessPlan dataAccessPlan, ZipWriter zipWriter)
   at Spotfire.Dxp.Framework.Persistence.DxpFileContributorRegistry.OnWriteToDxp(DocumentLocationType documentLocationType, ZipWriter zipWriter)
   at Spotfire.Dxp.Framework.Persistence.PersistenceManager.Save(DocumentTypes documentType, DocumentNode doc, IDocumentSaveSettings settings, Stream targetStream)
   at Spotfire.Dxp.Framework.Persistence.PersistenceManager.Save(DocumentTypes documentType, DocumentNode doc, IDocumentSaveSettings settings, String fileName)
   at Spotfire.Dxp.Application.AnalysisApplication.SaveAs(LibraryEntry entry, Document document, LibraryItemMetadataSettings metadataSettings, DocumentSaveSettings saveSettings)
   at Spotfire.Dxp.Forms.Application.FileUserActions.<>c__DisplayClass9.<SaveAsLibrary>b__7()
   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

Cause:
The problem occurs when using the same value to define both limits of the range in the range prompt.
This is a known issue in version 10.2 and lower.

Solution:
Upgrade to version 10.3.0 or higher, where the issue has been addressed.

Workaround (if using version 10.2 or lower):
Do not use the same value to define both limits in the range prompt. Keywords:
SAP BW, crash, error message, error, "An item with the same key has already been added", saving , data connection , BAPI