Support Article
Export to Excel option does not work correctly
SA-100289
Summary
In a report definition, which has controls configured for its columns, Export to Excel option does not work correctly.
Error Messages
com.pega.pegarules.pub.PRRuntimeException: Section 'pzRDExportWrapper' execution error on page 'pegaInternalReportTempPage' of class 'Rule-Obj-Report-Definition'. : java.lang.String incompatible with java.util.Date
at com.pegarules.generated.html.ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.execute(ra_stream_pzrdexportwrapper_8a003fbd0799660a40b7054ec93dd4aa.java:117) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4202) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4024) ~[prprivate.jar:?]
at com.pega.pegarules.pub.runtime.AbstractActivity.showHtml(AbstractActivity.java:261) ~[prpublic.jar:?]
at com.pegarules.generated.activity.ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.step2_circum0(ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.java:705) ~[?:?]
at com.pegarules.generated.activity.ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.perform(ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.java:92) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10961) ~[prprivate.jar:?]
at com.pegarules.generated.activity.ra_action_exportsearch_5fc7da3b491ee3d4be9cc4a7aa5b5bd9.step2_circum0(ra_action_exportsearch_5fc7da3b491ee3d4be9cc4a7aa5b5bd9.java:233) ~[?:?]
at com.pegarules.generated.activity.ra_action_exportsearch_5fc7da3b491ee3d4be9cc4a7aa5b5bd9.perform(ra_action_exportsearch_5fc7da3b491ee3d4be9cc4a7aa5b5bd9.java:98) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646) ~[prprivate.jar:?]
... 60 more
Caused by: java.lang.ClassCastException: java.lang.String incompatible with java.util.Date
at com.pega.pegarules.priv.desktop.reporting.export.excel.ExcelDataGridGenerator.fillDataCell(ExcelDataGridGenerator.java:108) ~[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:59) ~[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:4202) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4024) ~[prprivate.jar:?]
at com.pega.pegarules.pub.runtime.AbstractActivity.showHtml(AbstractActivity.java:261) ~[prpublic.jar:?]
at com.pegarules.generated.activity.ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.step2_circum0(ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.java:705) ~[?:?]
at com.pegarules.generated.activity.ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.perform(ra_action_pzrdexportwrapper_1c30a81b24468857090a0faf8383edfc.java:92) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10961) ~[prprivate.jar:?]
at com.pegarules.generated.activity.ra_action_exportsearch_5fc7da3b491ee3d4be9cc4a7aa5b5bd9.step2_circum0(ra_action_exportsearch_5fc7da3b491ee3d4be9cc4a7aa5b5bd9.java:233) ~[?:?]
at com.pegarules.generated.activity.ra_action_exportsearch_5fc7da3b491ee3d4be9cc4a7aa5b5bd9.perform(ra_action_exportsearch_5fc7da3b491ee3d4be9cc4a7aa5b5bd9.java:98) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2695) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646) ~[prprivate.jar:?]
... 60 more
Steps to Reproduce
- Create a report definition
- For a column, give control as pxDateTime and another custom control which displays only a date from the DateTime value
- Run the report and export it
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
This issue is addressed in the Pega Platform 8.2.4 and 8.3.1 Patch releases.
Published February 17, 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.