Copy link to clipboard
Copied
cfspreadsheet is used to read a large Excel (xlsx) file with more than 200,000 records always results in out of memory error "GC overhead limit exceeded The specific sequence of files included or processed"
"javax.servlet.ServletException: ROOT CAUSE:
java.lang.OutOfMemoryError: GC overhead limit exceeded"
Is there an alternative way to read large Excel file with ColdFusion? I'm having ColdFusion 10.
Thank you.
Copy link to clipboard
Copied
What do you have the memory allocation set to in Coldfusion? How much memory is available on the server?
This means you have run out of memory, which is not surprising as its a big file. But if CF is using only 512MB then it will need to be increased until it works.
You can see whats allocated using the Java & JVM page in the Administrator console
Copy link to clipboard
Copied
See my post a moment ago in: CFSpreadsheet fails to read atleast one row if the excel file size is big