3357342 - The remote server returned an error: (400) Bad Request when connect to a HANA system

Symptom

Analysis Office encounters error like below:
"Analysis Office currently is not able to establish a connection"
"One or more errors occurred"
"The remote server returned an error: (400) Bad Request"

In AO Trace, below log could be observed:

------
"Messages":[{"Number":42001,"Type":2,"Text":"InformationAccess Service GetServerInfo is not available. Install the SAP HANA EPM-MDS plugin."
Logon to SystemId: HANADEV, SystemName: HANADEV_, Scheme: http, HostName:, Port: , SystemDescription: HANADEV, AuthType: Basic, ProxyServer: , ProxyServerPort: , ProxyServerUser: failed: One or more errors occurred. [Inner Exception: The remote server returned an error: (400) Bad Request.]
General .NET Exception [929e-e242-68]:
One or more errors occurred.
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)

Environment

SAP Analysis for Microsoft Office 2.8

Reproducing the Issue

1.Open AO

2.Click insert Data Source

3.Select Data Source for Analysis

4.Connect to HANA system

Cause

Missing SAP HANA EPM-MDS plugin.

Resolution

Install the SAP HANA EPM-MDS plugin as per note below:

2456225 - Installation and update of the SAP HANA EPM-MDS component

Keywords

AO, Analysis for Excel, Analysis for Office, A4O, AFO , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product