I am evaluating Cells Java, and one of my requirements is to be able to run on a multi-threaded application. I have no problems with converting Cells to PDF with 6 threads.
But I do get “java.lang.OutOfMemoryError: GC overhead limit exceeded” error when converting to HTML with only 3 threads. I am giving the program 8GB of memory, but only about 4GB is being used. It seems to me that the application is just opening too many temp files or objects and doesn’t do a good job closing and cleaning them. The following post about GC overhead is interesting - https://stackoverflow.com/questions/1393486/error-java-lang-outofmemoryerror-gc-overhead-limit-exceeded.
Here is an example Excel file I am using - https://storage.googleapis.com/csi-se/eboraks/big_excel_to_immitate_sharepoint-3.xlsx.zip
Error Stack:
Exception in thread “pool-1-thread-2” 2017-07-05 22:00:05 INFO ExcelConverter:32 - Start converting big_excel_to_immitate_sharepoint-4.xlsx
java.lang.OutOfMemoryError: GC overhead limit exceeded
at com.aspose.cells.zbrg.a(Unknown Source)
at com.aspose.cells.zbrm.a(Unknown Source)
at com.aspose.cells.zbad.a(Unknown Source)
at com.aspose.cells.zfl.a(Unknown Source)
at com.aspose.cells.zaao.l(Unknown Source)
at com.aspose.cells.zaao.d(Unknown Source)
at com.aspose.cells.zahz.a(Unknown Source)
at com.aspose.cells.zku.b(Unknown Source)
at com.aspose.cells.ConditionalFormattingResult.getColorScaleResult(Unknown Source)
at com.aspose.cells.ConditionalFormattingResult.a(Unknown Source)
at com.aspose.cells.Cell.a(Unknown Source)
at com.aspose.cells.zafu.d(Unknown Source)
at com.aspose.cells.zafu.e(Unknown Source)
at com.aspose.cells.zafu.a(Unknown Source)
at com.aspose.cells.zafu.b(Unknown Source)
at com.aspose.cells.zafu.a(Unknown Source)
at com.aspose.cells.zafk.a(Unknown Source)
at com.aspose.cells.zafk.b(Unknown Source)
at com.aspose.cells.zafk.a(Unknown Source)
at com.aspose.cells.zafm.b(Unknown Source)
at com.aspose.cells.zafm.a(Unknown Source)
at com.aspose.cells.zafn.a(Unknown Source)
at com.aspose.cells.Workbook.save(Unknown Source)
at com.aspose.cells.Workbook.save(Unknown Source)
at com.cambridgesemantics.se.aspose.ExcelConverter.run(ExcelConverter.java:78)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)