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

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