SAP Knowledge Base Article - Preview

2405472 - Error: "Query Limits Exceeded" when refreshing a report based off a Universe in Crystal Reports for Enterprise or in SAP BI LaunchPad

Symptom

  • When refreshing a report, it fails with the error: 'Query Limit Exceeded'
  • It is possible to refresh successfully a Web Intelligence document off the same Universe.   
  • When refreshing a report in SAP BI LaunchPad it fails with the error: 'Query Limit Exceeded...  [JRC00005414]---- Error code:0 [CRWEB00000119]'
  • In Crystal Reports for Enterprise, when refreshing a report based off a Universe that have a query limit set, it always displays the following error:
          
    "Query Limits Exceeded
     The query did not finish running because a size or time limit imposed by the data source was exceeded.

     Please do one of the following:
     - Apply additional filters to reduce the size of your result set.
     - Apply additional filters to speed up your query.
     - Contact your System Administrator."
      
     
    Error Message - Query Limit.png
     
      
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


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 BusinessObjects Business Intelligence Platform 4.1
  • SAP BusinessObjects Business Intelligence Platform 4.2
  • SAP BusinessObjects Business Intelligence Platform 4.3

Product

SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

CRFE, CR4E, CR for Enterprise, UNX limit , KBA , BI-RA-CRE , Crystal Reports for Enterprise , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , 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.