SAP Knowledge Base Article - Public

1294557 - How to increase JVM memory size for Crystal Reports when reporting off Salesforce.com?

Symptom

  • How to increase the memory for the Salesforce.com driver?
  • How to increase the JVM memory size when reporting off Saleforce.com in Crystal Reports?

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
        
  • Salesforce.com

Resolution

  • If the tables you report against are large, such as 30,000+ records, it is recommended that you can increase the JVM memory size to get a quicker response. Increasing JVM memory size is not required to run your reports successfully, but it will help you view your large reports in shorter time.
      
  • The Crystal Reports 2008 and 2011 Salesforce driver is Java-based and executes in a Java environment. The default JVM memory size is typically 32MB-64MB. You can increase it by changing the Crystal Reports configuration of the JVM in the file, CRConfig.XML.
      
  • The recommended JVM memory size is 64MB – 512MB.To increase the memory size to 64MB – 512MB, modify the JVMMaxHeap and JVMMinHeap in CRConfig.xml:
                  
    1. Navigate to the CRConfig.xml file, which is by default at the following location:
        
         - For Crystal Reports 2008: 
            
                 C:\Program Files (x86)\Business Objects\Common\4.0\java
         
         - For Crystal Reports 2011: 
              
                 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. Update the following line in the XML file, by increasing the value:
       
        <JVMMaxHeap>512000000</JVMMaxHeap>
        <JVMMinHeap>64000000</JVMMinHeap>     
          
    4. Save the file, and restart Crystal Reports.
         
         
  • If you change the JVMMaxHeap to 128000000 that should be sufficient for most users but you may need to increase it further. It will vary as to how much you need to increase your heap size to access your Salesforce.com instance.
          
         
  • Note:
    Crystal Reports 2013 and above does not use the same driver to connect to Salesforce.com.
    In Crystal Reports 2013 and above, it is now using the Simba Salesforce.com ODBC driver, the above information will not be relevent, since it is not a Java based driver.

Keywords

SForce, CR, memory, JVM, increase , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013