SAP Knowledge Base Article - Public

2537388 - Error "An item with the same key has already been added" when opening or saving workbook in BI platform

Symptom

When opening or saving an Analysis workbook in BI platform using AO 2.4 SP4, the error below occurs:

"An item with the same key has already been added"

001.png

The entries below can be found in the traces of Analysis Office:

*****************************
General .NET Exception:
An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at com.sap.ip.bi.pioneer.controls.opendialogs.browsingmodel.CnBoeBrowsingModel.AddBoeIdOfBwDataSource(CoBwSystemInfo iSystemInfo, Dictionary`2 iDataSourceIds)
at com.sap.ip.bi.pioneer.controls.opendialogs.browsingmodel.CnBoeBrowsingModel.GetBoeIdsOfDataSources()
at com.sap.ip.bi.pioneer.controls.opendialogs.browsingmodel.CnBoeBrowsingModel.CreateObject(String iObjectName, String iObjectType, Object iInfoObject, CoOpenTreeNode iParentNode, Int64 iSize, Boolean iDo1X)
at com.sap.ip.bi.pioneer.controls.commands.CnCommandSaveDocument.CreateInfoObject(CnAbstractBrowsingModel iModel, Int64 iDocumentSizeOnDisk, Boolean iDo1X)
at com.sap.ip.bi.pioneer.controls.commands.CnCommandSaveDocument.SaveToServer(ICrOfficeDocument iOfficeDocument, CnAbstractBrowsingModel iModel, Boolean iDo1X)
at com.sap.ip.bi.pioneer.controls.commands.CnCommandSaveBase.ExecuteCommand()
*****************************

Environment

 SAP BusinessObjects Analysis, edition for Microsoft Office

Resolution

This issue is fixed in AO 2.4 SP5 and AO 2.5 SP1 or higher versions.

The instructions to download the latest version of Analysis for Office are available in section #2 in the link below:
- http://wiki.scn.sap.com/wiki/x/j41IGQ

Keywords

document, key, same, opening, open, save, saving, bi launchpad, bip, boe, workbook, report, error, exception , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions