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

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

book

Article ID: KB0078234

calendar_today

Updated On:

Products Versions
Spotfire Analyst 7.11 to 10.2

Description

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.
 

Issue/Introduction

An analysis containing a SAP BW data source cannot be saved. The client either crashes or an error message appears: "Could not publish xxx.ArgumentException at mscorlib: An item with the same key has already been added. (HRESULT: 80070057)". The problem occurs when using the same value to define both limits of the range in the range prompt.

Environment

Windows

Resolution

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.

Additional Information

Keywords:
SAP BW, crash, error message, error, "An item with the same key has already been added", saving , data connection , BAPI 
Powered by Wolken Software