cfspreadsheet out of memory for large Excel xlsx files

New Here ,
Mar 03, 2017 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

872

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
community guidelines
Advocate ,
Mar 06, 2017 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
community guidelines
Adobe Community Professional ,
Mar 06, 2017 Mar 06, 2017

Copy link to clipboard

Copied

LATEST

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
community guidelines