SAP Knowledge Base Article - Preview

3520042 - Analysis for Office connection to HANA Cloud through HAA failing with "Could not get a valid X_CSRF token error"

Symptom

You have successfully deployed HANA Analytics Adapter (HAA) to create a connection between HANA Cloud database and Analysis for Office.

However, when trying to create the connection using HAA, the following error is reported:

Could not get a valid X_CSRF token at URL 'https://<haa-url>/sap/bc/ina/service/v2/GetServerInfo' (AUTHENTICATION_FAILED) 

In the network traces from browser generated when accessing URL https://<haa-url>/sap/bc/ina/service/v2/GetServerInfo, the following entry is recorded in response header:

"request": {
          "method": "GET",
          "url": "https://<haa-url>/sap/bc/ina/service/v2/GetServerInfo",
          "httpVersion": "http/2.0",
          "headers": [
            {
              "...
        },
        "response": {
          "status": 401,
          "statusText": "",
          "httpVersion": "http/2.0",
          "headers": [
           ...
            {
              "name": "www-authenticate",
              "value": "Bearer realm=\"oauth\", error=\"unauthorized\", error_description=\"An Authentication object was not found in the SecurityContext\""
            },
        ...
          ],


Read more...

Environment

  • SAP HANA Cloud
  • Analysis for Office (AFO)

Product

SAP HANA Cloud all versions

Keywords

HAA, Analytics adapter, AFO, Analysis for Office, HANA Cloud, oauth, unauthorized, X_CSRF , KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , BI-RA-AO-XLA , Excel Addin , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.