Support Article
Error during file export and import for decision table rules
SA-61855
Summary
An error occurs while exporting or importing a file for decision table rules in an environment.
Error Messages
The Flow Action post-processing activity pzImportToExcel failed: java.lang.NoSuchFieldError: CREATE_NULL_AS_BLANK
Steps to Reproduce
- Open any decision table
- Check-out the rule
- Import or export a file for decision table rules
Root Cause
A different version of Apache POI (POI 3.17) was used which was not shipped by default.
By default, Pega ships Apache-POI 3.15 which contains the following field in Row.java:
- @Removal(version="3.17")
- @Deprecated
- Public static final MissingCellPolicy CREATE_NULL_AS_BLANK = MissingCellPolicy.CREATE_NULL_AS_BLANK;
By importing Apache-POI 3.17, user has explicitly overridden the jar with an incompatible version of Apache-POI. That field is removed from the class.
Resolution
An enhancement request, FDBK-27492, has been created for consideration by Pega Product Management.
Published August 28, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.