SAP Knowledge Base Article - Public

2193381 - Error HDB 02072: Cannot execute the query: query statement length exceeds engine capacities

Symptom

  • When grouping a field in the selection screen, the error "Error HDB 02072: Cannot execute the query: query statement length exceeds engine capacities" is thrown after selecting a number of records to group on.

HDB 02072.png

Environment

  • SAP Lumira Desktop

 

Cause

This issue can occur if too many records have been selected to group on.  Each field selected increases the length of the query sent to the engine - and if too many fields are selected then the resulting query will exceed the capabilities of the engine.

Resolution

  • Unfortunately there is currently no solution to this as this is a limitation of the product.  The only solution currently is to reduce the number of records being grouped on

Keywords

 BI Lumira HDB02072 HDB_02072 query length exceed , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , BI-LUM-SRV , SAP Lumira Server , BI-LUM-OD , SAP Lumira Cloud , BI-LUM-LIM , Lumira In-Memory Add-on to BOE , Problem

Product

SAP Lumira, desktop edition 1.0