Symptom
After BW changes, the issue "Failed to fetch data" was raised in view mode when using a dimension with a hierarchy in SAP Analytics Cloud.
One of the GetResponse calls from the network trace (.HAR file, KBA 2280022) recorded the following message:
--------------------------------------------------------------------
Error reading the data of InfoProvider [...]
...
Error 2.999 has occurred in the BWA/SAP HANA server
...
Failed to lookup path 'H000Join';QueryId: [...][Request Info: Object Name = [...], FM Name = TREX_DBS_AGGREGATE]
...
Parallel processing of query [...] resulted in the following messages:
...
Error while reading data; navigation is possible
---------------------------------------------------------------------
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP Analytics Cloud
- SAP NetWeaver
- SAP BW/4HANA
- SAP S/4HANA
Product
Keywords
Failed to fetch data, TREX_DBS_AGGREGATE, InfoProvider, 'H000Join', HCPR, BEx query, CDS view, view mode , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-DBIF , Interface to Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.