SAP Knowledge Base Article - Preview

2118286 - HCPR: High Query Memory Consumption due to non-unique joins

Symptom

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


Read more...

Environment

  • SAP NetWeaver Business Warehouse 7.3
  • SAP NetWeaver Business Warehouse 7.31
  • SAP NetWeaver Business Warehouse 7.4
  • SAP NetWeaver Business Warehouse 7.5
  • SAP BW/4HANA 1.0
  • SAP BW/4HANA 2.0

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

time out, slow query, TSV_NEW_PAGE_ALLOC_FAILED, STORAGE_PARAMETERS_WRONG_SET, SYSTEM_NO_ROLL, Composite Provider, ambiguous join , 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.