SAP Knowledge Base Article - Preview

2118286 - HCPR: High Query Memory Consumption due to Non-Unique/Ambiguous Joins

Symptom

A BW query that is defined on a Hana CompositeProvider using Joins needs more memory (and/or more time to finish) than expected.


Read more...

Environment

  • SAP BW/4HANA All versions
  • SAP NetWeaver All versions

Product

SAP BW/4HANA 2.0 ; SAP BW/4HANA 2021 ; SAP BW/4HANA 2023 ; SAP NetWeaver 7.5

Keywords

time out, slow query, TSV_NEW_PAGE_ALLOC_FAILED, STORAGE_PARAMETERS_WRONG_SET, SYSTEM_NO_ROLL, Hana Composite Provider, ambiguous join, memory dump , KBA , BW-BEX-OT , OLAP Technology , BW-BEX-OT-OLAP , Analyzing Data , BW4-AE-CORE , Core Services , BW4-AE-DBIF , DB Interface Data Manager , How To

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.