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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.