SAP Knowledge Base Article - Public

3092666 - Error "[78a1-2f54-e5] Index was out of range" when inserting a query in Analysis Office

Symptom

The error below occurs when trying to insert a query in Analysis Office:

"[78a1-2f54-e5] Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"

Error.png

The trace of AO (see SAP note 2129389) contains the following entries:
-------------------------------------------------
General .NET Exception [78a1-2f54-e5]:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
at System.Collections.Generic.List`1.RemoveAt(Int32 index)
at com.sap.ip.bi.pioneer.common.connectivity.CoRecentDataSourceInfoList.Add(IDataSourceInfo value)
at com.sap.ip.bi.pioneer.controls.uiservices.CnDataSourceSelectorService.ShowDatasourceDialog(Boolean iFormulaMode)
at com.sap.ip.bi.pioneer.controls.uiservices.CnDataSourceSelectorService.GetDataSourceInfo(Boolean iFormulaMode)
-------------------------------------------------

Environment

SAP BusinessObjects Analysis, edition for Microsoft Office

Cause

The issue occurs when the option "Maximum Number of Entries in Recent List" is set to 0 as shown below:

Recent List.png

Resolution

The error is fixed in Analysis Office code, as described in SAP note 3092711.

As a workaround, the option "Maximum Number of Entries in Recent List" can be changed to a value higher than 0 to avoid the error:

Go to File tab -> Analysis -> Customize Analysis -> Options -> Change the setting

This value can also be maintained in AO setting RecentListSize. See SAP note 2083067.

See Also

3092711 - AO: Fixed exception that occurs when inserting a query and Recent List Size setting is set to 0

Keywords

recent list, 78a1-2f54-e5, crash, exception, index, range, non-negative, , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions