• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

1.1K

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

Votes

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
Community Expert ,
Mar 06, 2017 Mar 06, 2017

Copy link to clipboard

Copied

LATEST

Votes

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
Resources
Documentation