Question

4
Replies
1740
Views
Close popover
Kiran Kumar Dangeti (KiranKumarD8724)
Bank of America

Bank of America
US
KiranKumarD8724 Member since 2013 1 post
Bank of America
Posted: August 3, 2016
Last activity: August 4, 2016
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

System Administration Upgrades Support Case Created
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.