Known Issue: Exception when converting RTX to Excel if there are more than 64000 cells

Symptoms

The Convert_RTX_toExcel process will fail and return an exception if there are more than 64000 cells in the file. The error message is:

The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook

Cause

When working with a template excel file, a new cell style is created for every cell. For large files this caused an exception, since the maximum amount of cell styles is limited to 64000.

Workaround

There is no workaround available. A fix is available from RMF 9.2.9.0.

Affected version

RunMyFinance 9.2.8.x and below

Resolution

This issue is fixed from RunMyFinance 9.2.9.0.

Cell styles are now cached. Before setting a new cell style, the cache checks if the cell style already exists  and uses it instead of creating a new one.

Reference 

ROSO-7598

Error

-- JOB RUN STACK TRACE --
com.redwood.scheduler.script.api.ScriptEngineEvaluationException
at com.redwood.scheduler.script.java.impl.Java.evaluateCallableInt(Java.java:183)
at com.redwood.scheduler.script.java.impl.Java.evaluateCallable(Java.java:136)
at com.redwood.scheduler.script.java.impl.Java.evaluate(Java.java:108)
at com.redwood.scheduler.scriptjobservice.impl.ScriptJob.execute(ScriptJob.java:145)
at com.redwood.scheduler.systemjobservice.api.JobWorker.runProcessExecute(JobWorker.java:264)
at com.redwood.scheduler.systemjobservice.api.JobWorker.processExecute(JobWorker.java:201)
at com.redwood.scheduler.systemjobservice.api.JobWorker.doWork(JobWorker.java:122)
at com.redwood.scheduler.systemjobservice.api.JobWorker.doWork(JobWorker.java:1)
at com.redwood.scheduler.infrastructure.workqueue.WorkQueueWorker.run(WorkQueueWorker.java:72)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: com.redwood.scheduler.infrastructure.exception.ReplacementException
at com.redwood.scheduler.infrastructure.util.ExceptionUtil.wrap(ExceptionUtil.java:243)
at com.redwood.scheduler.script.java.impl.Java.evaluateJava(Java.java:224)
at com.redwood.scheduler.script.java.impl.Java.lambda$2(Java.java:108)
at com.redwood.scheduler.script.java.impl.classloader.ThreadContextRunnable.call(ThreadContextRunnable.java:48)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
... 1 more
Caused by: java.lang.reflect.InvocationTargetException
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.redwood.scheduler.script.java.impl.Java.evaluateJava(Java.java:220)
... 6 more
Caused by: java.lang.IllegalStateException: The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook
at org.apache.poi.xssf.model.StylesTable.createCellStyle(StylesTable.java:830)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.createCellStyle(XSSFWorkbook.java:744)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.createCellStyle(XSSFWorkbook.java:122)
at com.redwood.scheduler.custom.fl.base.work.excel.PoiConvertRtxToExcel.copyRow(PoiConvertRtxToExcel.java:440)
at com.redwood.scheduler.custom.fl.base.work.excel.PoiConvertRtxToExcel.execute(PoiConvertRtxToExcel.java:260)
at com.redwood.scheduler.custom.fl.base.work.excel.ConvertRtxToExcel.execute(ConvertRtxToExcel.java:53)
at com.redwood.scheduler.custom.Jobdefinition_CUS_Robotics_Convert_RTX_toExcel.execute(Jobdefinition_CUS_Robotics_Convert_RTX_toExcel.java:user code 17)
at com.redwood.scheduler.custom.Jobdefinition_CUS_Robotics_Convert_RTX_toExcelStub.jcsExecute(Jobdefinition_CUS_Robotics_Convert_RTX_toExcelStub.java:48)
... 11 more