3485977 - intermittent 502 bad gateway error when retrieving data from HANA Cloud in Data Analyzer

502 bad gateway error when retrieving data from HANA Cloud in SAC Data Analyser, stories or in AFO (Analysis for Office)

InA result set Parsing Exception: Error on remote server: (502) Invalid gateway. 

(com.sap.ip.bi.bics.dataaccess.resource.impl.ina.exceptions.INARuntimeException-RESULTSET_PARSING)

SAP Analytics Cloud 1.0

SAP HANA Cloud DB

HANA Analytics Adapter (HAA) is used to to establish the connection between Analysis for Office and the HANA Cloud

Increase timeout setting (INCOMING_CONNECTION_TIMEOUT) on HAA

Change  this timeout via HAA deployment, e.g. by changing the configuration in the HAA mta.yaml file (need redeployment):

INCOMING_CONNECTION_TIMEOUT: 600000    <--- this is the default value in ms.

Or push the changes of the configuration to the existing running HAA via

cf set-env <your haa srv> INCOMING_CONNECTION_TIMEOUT 600000
cf restage <your haa srv>

Please align AO timeout HanaHttpConnectionTimeout as well:

2539597 - Error: "The remote server returned an error: (500) Internal Server Error" in HANA scenario - SAP for Me

2539597 - Error: "The remote server returned an error: (500) Internal Server Error" in HANA scenario - SAP for Me

502 Bad Gateway, HANA Cloud, AFO, InA, INARuntimeException, RESULTSET_PARSING, HANA Analytics Adapter (HAA), INCOMING_CONNECTION_TIMEOUT, HanaHttpConnectionTimeout , KBA , HAN-DB-ENG-MDS , SAP HANA Multidimensional Services MDS / InA , Problem