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


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 iSystemInfo, Dictionary`2 iDataSourceIds)
at iObjectName, String iObjectType, Object iInfoObject, CoOpenTreeNode iParentNode, Int64 iSize, Boolean iDo1X)
at iModel, Int64 iDocumentSizeOnDisk, Boolean iDo1X)
at iOfficeDocument, CnAbstractBrowsingModel iModel, Boolean iDo1X)


 SAP BusinessObjects Analysis, edition for Microsoft Office


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:


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


SAP Analysis for Microsoft Office all versions