Question

4
Replies
1688
Views
KiranKumarD8724 Member since 2013 1 post
Bank of America
Posted: 4 years ago
Last activity: 4 years 1 month ago
Closed
Solved

issue Parsing XLS file using Pega POI API in Pega 7.1.8

We are using Custom Pega POI API to parse XLS file in PRPC 6.2 SP1(refer the below PDN link) and it working fine in 6.2 but when we upgrade PRPC to 7.1.8 which throws below errors when parsing the XLS file.

 

 

https://pdn.pega.com/support-articles/unable-read-data-excel-sheet-when-file-type-xls

 

 

Error:

Caused by: java.lang.NoClassDefFoundError: com.pega.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller (initialization failure)

at java.lang.J9VMInternals.initialize(J9VMInternals.java:175)

at com.pega.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:161)

at com.pega.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:141)

at com.pega.apache.poi.openxml4j.opc.Package.<init>(Package.java:37)

at com.pega.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:87)

at com.pega.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:272)

at com.pega.apache.poi.util.PackageHelper.open(PackageHelper.java:37)

at com.pega.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:258)

at com.pegarules.generated.activity.ra_action_parseexceldata_adc19a2c786b8291b61efc90dc93046d.step6_circum0(ra_action_parseexceldata_adc19a2c786b8291b61efc90dc93046d.java:510)

at com.pegarules.generated.activity.ra_action_parseexceldata_adc19a2c786b8291b61efc90dc93046d.perform(ra_action_parseexceldata_adc19a2c786b8291b61efc90dc93046d.java:160)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10521)

at com.pegarules.generated.activity.ra_action_processemail_b4e22b5ea0f91dd22574bf20bfed9ddb.step5_circum0(ra_action_processemail_b4e22b5ea0f91dd22574bf20bfed9ddb.java:651)

at com.pegarules.generated.activity.ra_action_processemail_b4e22b5ea0f91dd22574bf20bfed9ddb.perform(ra_action_processemail_b4e22b5ea0f91dd22574bf20bfed9ddb.java:165)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)

at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)

... 19 more

Caused by: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;

at com.pega.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller.<clinit>(PackagePropertiesMarshaller.java:45)

at java.lang.J9VMInternals.initializeImpl(Native Method)

at java.lang.J9VMInternals.initialize(J9VMInternals.java:235)

at java.lang.J9VMInternals.initialize(J9VMInternals.java:202)

... 34 more

Low-Code App Development Upgrades SR Created
Moderation Team has archived post
Share this page LinkedIn