Symptom
The following exception is occurring in Analysis Office:
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
- Open a local Analysis Office report that uses an OLAP connection defined in CMC;
- Try to logon to a pre-defined BI platform available in the list;
- 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