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
- In Crystal Reports, create a new report connecting to a database using a JDBC connection.
- Add a couple of database fields to the report.
- 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:
-
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\
- Open the CRConfig.xml file in a text editor, like: Notepad.
- 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.
- Save the file.
- 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