Support Article
Error on exporting large number of records to Excel
SA-99340
Summary
Error occurs when exporting a large number of records (for example, report with 33,000 rows) to Excel.
Error Messages
[jsse-nio-8443-exec-3] [STANDARD] [ ] [UMCSales:01.01.01] (e_Obj_Report_Definition.Stream) ERROR - Section 'pzRDExportWrapper' execution error on page 'pegaInternalReportTempPage' of class 'Rule-Obj-Report-Definition'. 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) ~[poi-ooxml-4.0.1.jar:?] at org.apache.poi.xssf.usermodel.XSSFWorkbook.createCellStyle(XSSFWorkbook.java:750) ~[poi-ooxml-4.0.1.jar:?] at org.apache.poi.xssf.streaming.SXSSFWorkbook.createCellStyle(SXSSFWorkbook.java:864) ~[poi-ooxml-4.0.1.jar:?] at com.pega.pegarules.priv.desktop.reporting.export.excel.ExcelDataGridGenerator.fillDataCell(ExcelDataGridGenerator.java:111) ~[prpublic.jar:?] at com.pega.pegarules.priv.desktop.reporting.export.excel.StandardDataGridGenerator.generateDataRows(StandardDataGridGenerator.java:108) ~[prpublic.jar:?] at com.pega.pegarules.priv.desktop.reporting.export.excel.ExcelDataGridGenerator.generateDataGrid(ExcelDataGridGenerator.java:172) ~[prpublic.jar:?] at com.pega.pegarules.priv.desktop.reporting.export.excel.ExcelReportExporter.fillDataFromPage(ExcelReportExporter.java:181) ~[prpublic.jar:?] at com.pega.pegarules.priv.desktop.reporting.export.excel.ExcelReportExporter.processReportResults(ExcelReportExporter.java:132) ~[prpublic.jar:?] at com.pega.pegarules.priv.desktop.reporting.export.excel.ReportDefinitionExporter.calculateData(ReportDefinitionExporter.java:60) ~[prpublic.jar:?] at com.pega.pegarules.priv.desktop.reporting.export.ReportExporter.generateFile(ReportExporter.java:39) ~[prpublic.jar:?] at com.pega.pegarules.priv.desktop.reporting.export.ReportExportHandler.doExport(ReportExportHandler.java:21) ~[prpublic.jar:?] at com.pegarules.generated.html.ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.performStream_1(ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.java:188) ~[?:?] at com.pegarules.generated.html.ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.execute(ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.java:111) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4263) ~[prprivate-session.jar:?] at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4085) ~[prprivate-session.jar:?] at com.pega.pegarules.pub.runtime.AbstractActivity.showHtml(AbstractActivity.java:261) ~[prpublic.jar:?] at com.pegarules.generated.activity.ra_action_pzrdexportwrapper_ac209a966236b1665286ad25b65ce57b.step3_circum0(ra_action_pzrdexportwrapper_ac209a966236b1665286ad25b65ce57b.java:769) ~[?:?] at com.pegarules.generated.activity.ra_action_pzrdexportwrapper_ac209a966236b1665286ad25b65ce57b.perform(ra_action_pzrdexportwrapper_ac209a966236b1665286ad25b65ce57b.java:109) ~[?:?] at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2744) ~[prprivate-session.jar:?]
Steps to Reproduce
Unknown
Root Cause
A defect or configuration issue in the operating environment.
Resolution
This feature is implemented in Pega Platform 8.3.2.
Published March 25, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.