SAP Knowledge Base Article - Public

2407842 - The data cannot be displayed because the query returned too many records in SAP BusinessObjects Cloud

Symptom

When drilling though hierarchies with too many members you receive the error message:

Code: GENERIC_ERROR

Component: sap.fpa.ui.pa.reportEngine.Table
Message: The data cannot be displayed because the query returned too many records. Please try filtering your data.

Examining the main menu > Monitor > Traces shows the following error:

Message: oVersionInfo is undefined

Stack:

Exception@/sap/fpa/services/core/system/Exception.xsjslib:106
exceptionToMessage@/sap/fpa/services/core/system/Exception.xsjslib:425
@/sap/fpa/services/core/rest/Rest.xsjslib:525
handleRequest@/sap/fpa/services/GetResponse.xsjs:320
@/sap/fpa/services/GetResponse.xsjs:343

Environment

  • SAP BusinessObjects Cloud 2016.24

Reproducing the Issue

  1. Create a story using a model with thousands of members in a hierarchy
  2. Create a canvas and a table that uses that hierarchy
  3. When you try to drill down, the error appears 

Cause

This issue is still under investigation.

Resolution

This issue is still under investigation.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating facility at the top right-hand corner of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Bug Filed

Product

SAP Analytics Cloud 1.0