SAP Knowledge Base Article - Preview

2768895 - BW Hierarchy: Query entry is too big (DBMAN-099, Error 9.999 in HANA Server)

Symptom

Performance, memory or other errors (e.g Query entry is too big) happen for big hierarchies, sample symptoms:

  • using /ERP/WBSELMT hierarchy in custom Bex query.   However, the usage of a standard hierarchy triggers an issue in the corresponding query:   Bad request from application: Query entry is too big. It is accepted up to 40000000 characters. (DBMAN-099, <SystemID>) Error 9.999 has occurred in the BWA/SAP HANA server (DBMAN-901, <SystemID>)

  • Presentation hierarchy WBSH acts as a dynamic filter   and    Bad request from application: Query entry is too big. It is accepted up to 40000000 characters. (DBMAN-099, <SystemID>) Error 9.999 has occurred in the BWA/SAP HANA server (DBMAN-901, <SystemID>)


Read more...

Environment

  • SAP NetWeaver 7.5
  • SAP BW/4HANA

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP NetWeaver 7.5 ; SAP S/4HANA 1610 ; SAP S/4HANA 1709 ; SAP S/4HANA 1809

Keywords

Query entry is too big, DBMAN099, DBMAN 099, 9.999, 9999, WBSH, /ERP/WBSELMT, hierarchy , KBA , BW-BEX-OT-OLAP-HIER , Using Hierarchies , BW4-AE-CORE-HIER , Hierarchies (Runtime) , 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.