SAP Knowledge Base Article - Preview

3020905 - Error: 'Result set too large; data retrieval restricted by configuration...', when refreshing a report based on an SAP BW BEx query in Crystal Reports for Enterprise

Symptom

  • Error when refreshing a report based on a BEx Query.
  • Can successfully refresh the same report with different parameter values.
  • When refreshing a report based on an SAP BW Bex Query in Crystal Reports for Enterprise, it fails with the error:

    "Failed to execute query:
      ‘com.businessobjects.mds.olap.protocol.bics.BICSException: BW System <SAP BW System>:
      Result set too large (<Number> cells); data retrieval restricted by configuration (maximum = <Maximum Number> cells)’
      Redesign your query or contact the data source maintainer to solve the problem.
      
      Please take one of the following actions:
      - Click here to verify data source to fix this error.
      - Click here to use ‘set data source location’ to fix this error."


Read more...

Environment

  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
  • SAP Crystal Reports for Enterprise 4.3
        
  • SAP BW 7.4
  • SAP BW 7.5 

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

CR4E, CRFE, CRforE, CR for Ent , KBA , BI-RA-CRE , Crystal Reports for Enterprise , 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.