Question
Bank of America
US
Last activity: 4 Aug 2016 4:37 EDT
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://collaborate.pega.com/question/unable-read-data-excel-sheet-when-file-type-xls-pega-86
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)
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://collaborate.pega.com/question/unable-read-data-excel-sheet-when-file-type-xls-pega-86
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
Accepted Solution
Bank of America
US
Hi Kevin,
we are getting same error when i click on "lookup java class" .
we have modified our code to use org.apache package(3.6) instead of com.pega.apache package and it is working fine now( we have imported few POI API jars into PRPC)
Regards,
Kiran
Pegasystems Inc.
US
It is possible during upgrade you also upgraded JDK? If you use SMA>>Advanced>>ETier Runtime Environment and then enter com.pega.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller in the java class name text box and then click "lookup java class" button, did you get the same error?
Accepted Solution
Bank of America
US
Hi Kevin,
we are getting same error when i click on "lookup java class" .
we have modified our code to use org.apache package(3.6) instead of com.pega.apache package and it is working fine now( we have imported few POI API jars into PRPC)
Regards,
Kiran
Pegasystems
IN
This error is discussed in the link provided below. It is an issue with IBM Java 6. Moving to IBM Java 7 solves the problem. This has been fixed in version 7.2 of the Pega platform.