2112323 - "Index was outside the bounds of the array" exception when inserting data source from BI platform

You are getting the exception "Index was outside the bounds of the array" when trying to insert a data source from BI platform.

The log file of Analysis for Office contains the entries below:

===================================
 - Critical: General .NET Exception:
 Index was outside the bounds of the array.
    at com.sap.ip.bi.pioneer.core.boe.CrOlapConnectionInfoObjectWrap.get_ConnectionParameters()
    at com.sap.ip.bi.pioneer.core.boe.CrOlapConnectionInfoObjectWrap.GetConnectionType()
    at com.sap.ip.bi.pioneer.core.boe.CrOlapConnectionInfoObjectWrap.get_ConnectionType()
...
===================================

SAP BusinessObjects Analysis, edition for Microsoft Office

When trying to insert a data source from BIP, the checking of connections is required in order to filter out the relevant connections for Analysis for Office. However, there is a corrupted OLAP connection in BI platform which may be causing this issue.

In order to fix this issue, the corrupted connection must be removed or fixed in your BI platform.

How to Find the Corrupted Connection

1. Record the trace of Analysis for Office by foolowing the instructions of SAP note 2129389;
2. Open the trace and search for the error "Index was outside the bounds of the array";
3. Search for the last line with "###BIPcall" in some of the rows before the error;
4. This line should contain a SQL statement which you can execute in your BI Query Builder;
5. In Query Builder, the SQL will retrieve the objects from BI platform (in this case the OLAP connections);
6. Now you have to check those connections one by one in your CMC in order to find out the corrupted one (e.g: try to edit the connection) and then fix or remove it from your BI platform.

insert, data source, bounds, array, index, connections, BIP, BOE, analysis, office, outside, OLAP, connection , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , How To