Symptom
The chart fails to retrieve data when using Drill Up and Drill Down options in conjunction with linked analysis. When linked analysis is not applied, everything functions as expected.
"Destination host is unreachable!"
HAR log may show
.../bw/ina/GetResponse
502 Bad Gateway: Registered endpoint failed to handle the request.
wait time is 300 sec = 5 min
Console log may show
[Error] Kernel: at e [as constructor]
[Error] IOLayer: onHttpResponse: Http Status: 502 Bad Gateway
[INFO] Error getting result set queryKey=5 for application ID
Environment
Model relies on a live connection through a tunnel.
CDS View
SAP_BW Release 753
Issue can happen in SAPK-75XYYINSAPBW and SAPK-X00YYINDW4CORE
Cause
timeout in CL_BICS_INA_JSON_PARSER
The termination occurred in ABAP program or include "CL_BICS_INA_JSON_PARSER=======CP", in "_PUSH_BACK_PARSER". The main program was "SAPLBW_BICS_INA_TEST_TOOLS". Program "CL_BICS_INA_JSON_PARSER=======CP" has exceeded the maximum uninterrrupted runtime and has therefore been terminated. The maximum runtime of a program is set by system profile parameter "rdisp/scheduler/prio_[high|normal|low]/max_runtime". Once this limit has been exceeded, the system attempts to interrupt the SQL statement or to instruct the ABAP processor to terminate the program. It waits for a maximum of 60 seconds. If the program is then still active, the work process is restarted.
Resolution
Verify these notes are installed in the backend system holding the SAC data.
2635363 - InA: High runtime of JSON parser in case of batch requests
3247690 - InA: Maximum runtime hierarchy drill level
3066189 - InA: Automatic variable submit for data requests - Part III
3025401 - BICS: enhance RRI mapping adding semantical objects and metadata
3126410 - InA: Automatic variable submit for data requests - Part VII
3261094 - InA: Invalid filter or apply cartesian error message when loading SAC stories
3425381 - InA: Virtual root node support for level offset
3364468 - BW InA: Virtual Attribute <dimension>.path
3450900 InA: High runtime of JSON parser in case of batch requests (753 only)
2635363 which can not be implemented due to release 753, use 3450900
The issue can also be addressed with:
1. either reduce the Filters
2. and/or set a higher runtime in RZ11 transaction and try to reproduce. (parameter "rdisp/scheduler/prio_[high|normal|low]/max_runtime")
Keywords
KBA , BW-BEX-OT-BICS-INA , BW INA provider , LOD-ANA-DES , Story Design & Visualizations , Problem