SAP Knowledge Base Article - Preview

2270580 - Error: 'HY000:OPERATION_TOO_LARGE:Exceeded 100000 distinct ids' when refreshing a report based on Salesforce.com from Crystal Reports

Symptom

  • Error when refreshing a report connecting to Salesforce.com
  • Other reports based on Salesforce.com refresh successfully in Crystal Reports. The error only occurs with specific reports.
  • When refreshing some report based on Salesforce.com in Crystal Reports, it fails with the error:
       
     "Failed to retrieve data from the database. 
      Details: HY000:OPERATION_TOO_LARGE:Exceeded 100000 distinct ids [Database Vendor Code 108]"     
     


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

CR, SForce, Saleforce, limit , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , 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.