SAP Knowledge Base Article - Public

2801567 - "Unable to retrieve data from the datasource. Error: [Bad Gateway]" error appears in SAP Analytics Cloud

Symptom

When opening a story based on HANA Live Connection, the following error appears in SAP Analytics Cloud (SAC):
"Unable to retrieve data from the datasource. Error: [Bad Gateway]"

Environment

  • SAP Analytics Cloud
  • Live Data Connection to SAP HANA

Reproducing the Issue

  1. Logon to SAC.
  2. Open a Story based on HANA Live Connection.
  3. Notice that the chart does not retrieve any data and the error message appears. 

Cause

The issue is caused by a long-running query on the HANA database.

Resolution

Set the SQL Execution Hints in the Calculation view according to the following SAP Note: 2509161 - Set SQL Execution Hints in Calculation View via HANA Studio Modeler.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predicitive , Problem

Product

SAP Analytics Cloud 1.0