PEGA 8.1.2: OOB Report definition export to excel not working
I have ran the report definition and from report browser from action I have clicked on export to excel.
getting below error in log file:
2019-03-05 18:15:59,889 [ default task-972] [ STANDARD] [ ] [ CSHL:01.01.01] (e_Obj_Report_Definition.Stream) ERROR Proprietary information hidden| Proprietary information hidden GaneshWalunj - Section 'pzRDExportWrapper' execution error on page 'pegaInternalReportTempPage' of class 'Rule-Obj-Report-Definition'. org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : org.apache.xml.serializer.ToXMLSAXHandler cannot be cast to org.apache.xml.serializer.SerializationHandler
Tracer save attached
Accepted Solution
This issue is for Jboss/Oracle environment resolved by running below SQL script on DB
update PegaRULES.pr_engineclasses set pzcodeset='pega-enginecodenouse' where PegaRULES.pr_engineclasses.pzjar like '%serializer%' or PegaRULES.pr_engineclasses.pzjar like '%xalan%';
commit;
Can you check the SA article.
https://community.pega.com/support/support-articles/export-excel-fails-null-pointer-exception
Also, can you check the OOTB Reports as well.
Thank you @Rachit_Agarwal will check provided article.
facing issue for OOB reports as well.
Hi Ganesh,
We also faced same issue in 8.1.3. We have upgraded our application from 7.3.
Initially report export was working fine. But issue started when there was a patch update happened in the server level.
We followed the steps given from the below link which resolved the issue. I suggest you to try this once.
Thanks,
Veera
Accepted Solution
This issue is for Jboss/Oracle environment resolved by running below SQL script on DB
update PegaRULES.pr_engineclasses set pzcodeset='pega-enginecodenouse' where PegaRULES.pr_engineclasses.pzjar like '%serializer%' or PegaRULES.pr_engineclasses.pzjar like '%xalan%';
commit;