2525234 - Failed to connect to system when using reverse proxy to create live data connection to remote HANA system in SAP Analytics Cloud

SAP Knowledge Base Article - Public

2525234 - Failed to connect to system when using reverse proxy to create live data connection to remote HANA system in SAP Analytics Cloud

Symptom

  • Failed to connect to system when using reverse proxy to create live data connection to remote HANA system in SAP Analytics Cloud
  • Google Chrome Developer Tools shows:

         403 Forbidden

         The server refused to fulfill the request 

 

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Connect to SAP Analytics Cloud tenant
  2. Create a "Live Data Connection" > "SAP HANA"
  3. Choose "Path" as "Connection Type", and fill in the path of HANA system configured at httpd.conf file of Apache reverse proxy, and other required information
  4. Click OK 
  5. You get the error "Failed to connect to system" 

Cause

HANA restricts usage to particular origin hosts to make it more secure. The URL of Apache reverse proxy server is not included in the list defined at "allowOrigin" section under "cors" in .xsassess at the targeted remote HANA system.

Resolution

  1. Go to targeted remote HANA system's IDE Editor
  2. Log on
  3. Expand sap > bc > ina >service > v2
  4. Click .xsaccess 
  5. Locate "allowOrigin" section under "cors" and add the URL of Apache reverse proxy server.
  6. Save

 *Note: If you test the dispatcher rules for the remote HANA system by opening the following URL: https://<Apache Web Host>/<PATH>/sap/bc/ina/service/v2/GetServerInfo, it successfully returns the JSON response.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SERVER_ERROR_500, SAP Cloud for Planning, cloudforplanning, Cloud for Analytics, C4P, Cloud 4 Planning, HCP, C4A, BOC, SAP BusinessObjects Cloud, bobj, BW, ERP, UNX, SAP Analytics Cloud , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0