Java Excel Report Postprocessor - NullPointerException Error

Hi Everyone,

I have a Postprocessor java class that I expect is causing the NullPointerException  error because the Preprocessor worked 100%.

The problem is that the error message does not guide you properly. In other errors I could determine the row in the java class that is causing the error but not this error.

The error message from the server log file, message directly after the service was restarted:

STATUS server:main:(PPMTomcatMonitor.java:56):2020/03/16-19:52:45.638 SAST: *** Ready!
STATUS JSESSIONID=214D19E0A98E88DBDE448F19368B5923.dev,USERNAME= server:http-bio-8080-exec-1:(CryptixProperties.java:535):2020/03/16-19:53:32.474 SAST: Warning: failed to load the Cryptix properties file.
Make sure that the CLASSPATH entry for Cryptix is an absolute path.
ERROR :CommandRunner for com.kintana.rpt.server.KSCRunExcelReportCommand Batch ID: 35328:(KSCRunExcelReportCommand.java:306):2020/03/16-19:53:49.658 SAST: Error while running Excel Report with template epmo/EPMOPortfolioDashboardTemplateV1.xlsx
java.lang.NullPointerException
at org.apache.poi.xssf.usermodel.XSSFRow.removeCell(XSSFRow.java:491)
at com.mercury.itg.common.excel.service.ExcelExportServiceImpl.trimEmptyTrailingCellsAndReturnLastRow(ExcelExportServiceImpl.java:177)
at com.mercury.itg.common.excel.service.ExcelExportServiceImpl.findLargeDataInfo(ExcelExportServiceImpl.java:447)
at com.mercury.itg.common.excel.service.ExcelExportServiceImpl.generateDynamicStreamingExcelWorkbook(ExcelExportServiceImpl.java:387)
at com.mercury.itg.common.excel.exporter.ExcelReportExcelExporter.generateWorkbook(ExcelReportExcelExporter.java:35)
at com.kintana.rpt.server.KSCRunExcelReportCommand.execute(KSCRunExcelReportCommand.java:264)
at com.kintana.core.server.execution.CommandRunner.run(CommandRunner.java:120)
at java.lang.Thread.run(Thread.java:748)

The post processor class needs to remove the zero's from the table section which it has done but but I started at the wrong row and cell number, I fixed that in the java code and that change started the error message. I reverted back but error keeps on being the same.:

Excel Spreadsheet screenshot, excel file attached

Annotation 2020-03-1.jpg

The Java source code file attached in zip file

Any ideas on what I can do to understand where the error occurred?

Regards,

Alfred

EpmoPortfolioPoiClass.zip