Support Article
IllegalStateException occurs when exporting large decision table
SA-50294
Summary
IllegalStateException occurs when exporting a large decision table.
Error Messages
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:789) ~[poi-ooxml-3.15.jar:?]
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.createCellStyle(XSSFWorkbook.java:715) ~[poi-ooxml-3.15.jar:?]
at com.pega.pegarules.session.internal.document.workbook.PRWorkbookAPOI.createCellStyle(PRWorkbookAPOI.java:91) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.document.workbook.PRCellStyleFactory.getClonedOldStyle(PRCellStyleFactory.java:151) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.document.workbook.PRCellStyleFactory.getFormatCellStyle(PRCellStyleFactory.java:121) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.document.converter.AbstractWorkbookConverter.addDataFormat(AbstractWorkbookConverter.java:262) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.document.converter.AbstractWorkbookConverter.generateWorkBook(AbstractWorkbookConverter.java:221) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.document.converter.DecisionTableWorkbookConverter.generateWorkBook(DecisionTableWorkbookConverter.java:80) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.document.converter.AbstractWorkbookConverter.exportDocument(AbstractWorkbookConverter.java:80) ~[prprivate.jar:?]
at com.pegarules.generated.activity.ra_action_pzexportdecisiontable_b56405dda7cf4c267e00f41e0adad242.step2_circum0(ra_action_pzexportdecisiontable_b56405dda7cf4c267e00f41e0adad242.java:251) ~[?:?]
at com.pegarules.generated.activity.ra_action_pzexportdecisiontable_b56405dda7cf4c267e00f41e0adad242.perform(ra_action_pzexportdecisiontable_b56405dda7cf4c267e00f41e0adad242.java:87) ~[?:?]
at
com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3597) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646) ~[prprivate.jar:?]
... 50 more
Steps to Reproduce
- Open a decision table with multiple rows.
- Click Export on the decision table rule.
- Repeat Steps 1 and 2, while tracing the export.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Apply HFix-40835.
Published March 20, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.