Change Config File for Java Heap Error

 

Problem:

A Java Heap memory error can occur when saving Query results to Excel 8.0 or 12.0 when the result set is very large (in excess of 300,000 rows and 160 columns). This requires setting the Java heap size on the client using the steps below:

1. Edit the file C:\Program Files (x86)\ShowCase\9\proddata\config\showcase.cfg.
      
    
2. Open the file in a plain-text editor, such as Notepad.    
   
    
3. Under the GLOBAL PROPERTIES stanza, insert this line:
       showcasecorp.jvmMaxMemory=256
    
4. Save the file, and restart the ShowCase Query client (if it was running).