Getting java.lang.NullPointerException:null while executing report book in Jasper Server 7.8

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Custom reports created as report book formatting can not be executed in Jaspersoft 7.8.

Steps to reproduce:

• Create a custom studio report with Book report as main report and link sub reports to it in Jaspersoft server 7.8

Expected result: Report to execute fine as it did in 7.1.3

Actual result: Report fails with java.lang.NullPointerException:null

Jasperserver.log:

java.lang.NullPointerException: null2022-02-17T10:28:17,437 ERROR SecureExceptionHandlerImpl,http-nio-8089-exec-426:116 [someUser] - null
2022-02-17T11:55:34,400 ERROR SecureExceptionHandlerImpl,quartzScheduler_Worker-2:116 [] - The report was not completed. An error occurred while executing it.
2022-02-17T11:55:34,401 ERROR ReportExecutionJob,quartzScheduler_Worker-2:367 [] - The report was not completed. An error occurred while executing it.java.lang.NullPointerException: null
2022-02-17T11:55:34,402 ERROR SecureExceptionHandlerImpl,quartzScheduler_Worker-2:116 [] - error.generating.report
2022-02-17T11:55:34,402 ERROR ReportExecutionJob,quartzScheduler_Worker-2:367 [] - error.generating.report
org.quartz.JobExecutionException: Did not find report result for {paginated: null, maxPageHeight: null, maxPageWidth: null}

Environment

Jaspersoft 7.8

Cause

This ie being analysed as Jaspersoft defect JS-65406/Clarity Defect DE64382

Resolution

Workaround:

Ensure the main report is sending the connection parameter $P{REPORT_CONNECTION} to all book sub-report parts. You could edit the main book report in the source view and update it such that it contains the subreportParameter name such as it appears as it appears in the bold excerpt below:

<subreportParameter name="REPORT_CONNECTION">
  <subreportParameterExpression><![CDATA[$P{REPORT_CONNECTION}]]></subreportParameterExpression>
</subreportParameter>