Symptom
- Previewing the analytic model results in the error: "The query executed with errors. 502 Bad Gateway: Registered endpoint failed to handle the request."
- Variable selection in SAP Datasphere Analytic Model takes too long
- Data Preview in SAP Datasphere is slow
Environment
- Analytic Model
Reproducing the Issue
- Open the SAC Story in SAP Analytics Cloud
- Observe the error message: "502 Bad Gateway: Registered endpoint failed to handle the request." or
- Open the value help for the variable selection in Analytic Model
Cause
- The issue is caused by a remote access that retrieves a large dataset from a remote ABAP table
Resolution
- Apply a global filter to reduce the volume of data being processed (see SAP Datasphere: Using Filters)
- Persist the underlying table which access the data remotely to improve performance
See Also
- Refer to: SAP Datasphere: Using Filters
- Refer to: SAP Datasphere: Dynamic Default Variables
Keywords
502 bad gateway, analytic model preview error, sap analytics cloud, remote scan, large dataset, performance issue, global filter, persist table, filter, dynamic default variables, remote access , KBA , DS-MD-AM , Analytic Model , DS-MD , Modeling (Data Builder) , Problem
Product
SAP Datasphere all versions