Highlighted

cfspreadsheet out of memory for large Excel xlsx files

New Here ,
Mar 03, 2017

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.

Views

778

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

cfspreadsheet out of memory for large Excel xlsx files

New Here ,
Mar 03, 2017

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.

Views

779

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 03, 2017 0
Advocate ,
Mar 06, 2017

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 06, 2017 0
BKBK LATEST
Adobe Community Professional ,
Mar 06, 2017

Copy link to clipboard

Copied

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 06, 2017 1