Skip to main content
henryc62208508
henryc62208508
Participant
March 3, 2017
Question

cfspreadsheet out of memory for large Excel xlsx files

  • March 3, 2017
  • 2 replies
  • 1327 views

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.

This topic has been closed for replies.

2 replies

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
March 6, 2017

See my post a moment ago in: CFSpreadsheet fails to read atleast one row if the excel file size is big

H
haxtbh
Inspiring
March 6, 2017

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices