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"
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:
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.
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 , KBA , BI-RA-AO-XLA , Excel Addin , Problem