SAP Knowledge Base Article - Public

3367187 - Error: "GC overhead limit exceeded (max heap: <Number> MB)” when refreshing a report using a JDBC connection in Crystal Reports

Symptom

  • Error: "GC overhead limit exceeded (max heap: <Number> MB)"
  • Report with large data set return an error, but refresh successfully with smaller data set.
  • When refreshing a report using a JDBC connection in Crystal Reports, it fails with the error: 

    "Failed to retrieve data from the database.
     Details: Exception: [Error Message:] GC overhaead limit exceeded (max heap: <number> MB) + crystal reports
     GC overhead limit exceeded (max heap: <number> MB)"

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020  

Reproducing the Issue

  1. In Crystal Reports, create a new report connecting to a database using a JDBC connection.
  2. Add a couple of database fields to the report.
  3. When refreshing the report, it fails with the error:
    "GC overhead limit exceeded (max heap: <number> MB)"

Cause

  • JDBC connection does not have enough memory to handle large data set.

Resolution

  • Increase the JDBC connection JVM memory in the CRConfig.xml file:

    1. On the computer where Crystal Reports is installed, navigate to the CRConfig.xml file, which is by default at the following location:

         C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\
        
    2. Open the CRConfig.xml file in a text editor, like: Notepad.
         
    3. In the XML file, in the section: <DataDriverCommon>, locate the following lines:

         <JVMMaxHeap>64000000</JVMMaxHeap>
         <JVMMinHeap>32000000</JVMMinHeap>

      And increase the JVM values like:

         <JVMMaxHeap>512000000</JVMMaxHeap>
         <JVMMinHeap>64000000</JVMMinHeap>
        
      Note: You may need to increase the JVMMaxHeap to 128000000, for very large data set.
          
    4. Save the file.
         
    5. Restart Crystal Reports, for the change to be picked up.             

Keywords

CR, JVM, Heapsize, JDBC , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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