Support Article
Export to excel from Reports is not working
SA-76170
Summary
Export to Excel functionality from any report fails with an error.
Error Messages
Caused by: java.lang.NoSuchMethodError: org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(Ljava/lang/String;)
Steps to Reproduce
- Navigate to My Reports in the CPMInteractionPortal.
- Select a category (for example, Throughput reports).
- Execute a report from that category (for example, Case Volume - Resolved).
- Select 'Export to Excel' from the Actions menu when the report loads.
Root Cause
A defect or configuration issue in the operating environment.
Conflicting old POI related JARs (3.11) remained in the database.
poi-ooxml-3.11-20141221.jar
poi-3.11-20141221.jar
poi-excelant-3.11-20141221.jar
poi-scratchpad-3.11-20141221.jar
poi-ooxml-schemas-3.11-20141221.jar
While in Pega Platform 7.4, JAR 3.15 is used. poi-ooxml-3.15.jar
poi-ooxml-schemas-3.15.jar
poi-3.15.jar
poi-scratchpad-3.15.jar
Resolution
Perform the following local-change:
- Stop the servers.
- Backup the database.
- Run Delete from the pr_engineclasses where pzjar is '%poi%3.11%'.
- Perform a Commit.
- Start the servers.
Tags:
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.