1956016 - Error 'Number of members (x) exceeds 5,000; please do a search by element instead' is received from Crystal Reports For Enterprise

SAP Knowledge Base Article - Public

1956016 - Error 'Number of members (x) exceeds 5,000; please do a search by element instead' is received from Crystal Reports For Enterprise

Symptom

  • An error is received when refreshing reports
  • Error: 'com.businessobjects.mds.olap.protocol.bics.BICSException: Number of members (x) exceeds 5,000 ; please do a search by element instead. Number of members (x) exceeds 5,000 ; please do a search by element instead'

Environment

  • Crystal Reports for Enterprise 4.0 SP05 or higher
  • BW 7.x

Reproducing the Issue

  1. From Crystal Reports for Enterprise, create a new report against a BW query. The BW query should contain a variable which would prompt for more than 5000 records

  2. Refresh the report

Cause

A limit of 5000 records has been introduced with SP5 for BI 4.0 to avoid memory consumption issues

Resolution

  1. Locate file Config.ini file located at <INSTALLATION_DIR>\Program Files (x86)\SAP BusinessObjects\Crystal Reports for Enterprise XI 4.0\configuration
  2. Add the following line to the file: sap.sl.bics.bicslovlimit=xxxxx where xxxxx is the number of records to display
  3. For instance to extend the limit to 20000 the line should be sap.sl.bics.bicslovlimit=20000
  4. Save the Config.ini file 

Keywords

KBA , BI-RA-CR-DES , Crystal Reports Designer (CR20XX) , Problem

Product

Crystal Reports for Java all versions