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"
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