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
Barclays
IN
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;
Pegasystems Inc.
US
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.
Barclays
IN
Thank you @Rachit_Agarwal will check provided article.
facing issue for OOB reports as well.
Pegasystems Inc.
US
Hi Ganesh
Would you be able to upgrade the latest release of Pega 8 and see whether this is still an issue?
Also, which OOTB report did you try?
If you try to export to PDF, does that work?
Thank you,
Bhuvana.
American Express Services Europe Ltd
GB
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
Barclays
IN
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;