SAP Knowledge Base Article - Public

2643045 - Error in Analysis Office: "Value cannot be null. Parameter name: key"

Symptom

The following exception is occurring in Analysis Office:

Exception.png

In Analysis Office trace files, the following entries can be found:

====================================

General .NET Exception:
Value cannot be null.
Parameter name: key
at System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
at com.sap.ip.bi.pioneer.core.boe.CrBoeHandler.GetBoePlatformSerivce(CoBoeSystemInfo iSystemInfo)
at com.sap.ip.bi.pioneer.core.boe.CrBoeConnectionsHelper.UpdateSystemInfo(CoSystemInfo cSystemInfo)
at com.sap.ip.bi.pioneer.core.boe.CrBoeHandler.RefreshSystemFromBoe(CoSystemInfo iSystemInfo)
at com.sap.ip.bi.pioneer.core.connections.CrConnectionManager.GetBwSystemInfoDetail(CoSystemInfo iBasicInfo)
at com.sap.ip.bi.pioneer.core.connections.CrConnectionManager.HandleConnectionBwSystemInfoDoesNotExist(CoConnectionInfo iConnectionInfo, oolean& lConnectionExists, Boolean& lInfoHasError)
at com.sap.ip.bi.pioneer.core.connections.CrConnectionManager.HandleConnectionDoesNotExist(CoConnectionInfo iConnectionInfo, Boolean& ConnectionExists, Boolean& lInfoHasError)
at com.sap.ip.bi.pioneer.core.connections.CrConnectionManager.AutoLogon(CoConnectionInfo iConnectionInfo, Boolean& wasAlreadyPooled)
at com.sap.ip.bi.pioneer.core.connections.CrConnectionManager.Connect(CoConnectionInfo iConnectionInfo, CrModelApplication ModelApplication)
at com.sap.ip.bi.pioneer.core.models.CrDataProvider.EnsureLogon()
103012 Exception occurred while trying to connect to system XXX for data source XXX[msg.ErrorConnect]

====================================

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Open a local Analysis Office report that uses an OLAP connection defined in CMC;
  2. Try to logon to a pre-defined BI platform available in the list;
  3. Confirm the error.

Cause

The issue might be related to wrong configuration/characters of the pre-defined BOE systems in the configuration files of Analysis Office.

Resolution

Open the configuration files of Analysis Office where the BOE systems are defined.

Check if the pre-defined systems are correctly defined according to chapter To define a system connection to SAP BusinessObjects Business Intelligence. The chapter contains few examples of how the systems should be configured.

If it is not possible to identify the wrong character/configuration, delete all pre-defined BOE systems and add them again via Analysis Office (the BOE system entry is saved after a successful logon to BI platform).

Keywords

refresh, exception, error, refreshing, boesystems, bi platform, report, local , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions