JasperServer 6.4.3 integrated with both CAPM and Spectrum.
Reports exports fine from Spectrum in all formats and contain data. Reports can be generated for CAPM groups. However, when attempting to export a report to any format other than PDF for CAPM reports, only the header appears, there is no data:
Issue appears after upgrade of CAPM from version 3.7.x to 20.2.x. It does not affect Spectrum integrated with the same CABI JasperServer instance.
This is due to configuration of the JasperServer output to Excel format due to the following possible problems :
This can be debuted by enabling activity for class com.jaspersoft.jasperserver.war.action by do the following
CABI_HOME/apache-tomcat/webapps/jasperserver-pro/WEB-INF/logs/jasperserver.log
We should see output similar to:
2021-01-19 10:13:44,121 DEBUG ReportExecutionHyperlinkProducerFactory,http-nio-8080-exec-1:78 - Found report unit URI /public/ca/pm/reports/capm_topn
2021-01-19 10:13:44,121 DEBUG ReportExecutionHyperlinkProducerFactory,http-nio-8080-exec-1:78 - Found report unit URI /public/ca/pm/reports/capm_topn
2021-01-19 10:13:44,621 DEBUG ReportExecutionHyperlinkProducerFactory,http-nio-8080-exec-7:78 - Found report unit URI /public/ca/pm/reports/capm_topn
2021-01-19 10:13:44,621 DEBUG ReportExecutionHyperlinkProducerFactory,http-nio-8080-exec-7:78 - Found report unit URI /public/ca/pm/reports/capm_topn
2021-01-19 10:13:47,043 DEBUG ReportExporterAction,http-nio-8080-exec-10:587 - Creating new form object with name 'excelExportParams'
2021-01-19 10:13:47,043 DEBUG ReportExporterAction,http-nio-8080-exec-10:599 - Putting form object of type [class com.jaspersoft.jasperserver.api.engine.jasperreports.common.XlsExportParametersBean] in scope FLOW with name 'excelExportParams'
2021-01-19 10:13:47,043 DEBUG AbstractReportExporter,http-nio-8080-exec-10:93 - com.jaspersoft.jasperserver.war.action.ReportXlsxExporter, paginated: false exporting report 1497502182_1611011622481_2 at /public/ca/pm/reports/capm_topn
2021-01-19 10:13:47,043 DEBUG AbstractReportExporter,http-nio-8080-exec-10:408 - pagination parameters {paginated: false, maxPageHeight: null, maxPageWidth: null}
2021-01-19 10:13:47,043 DEBUG AbstractReportExporter,http-nio-8080-exec-10:124 - requested report pagination: {paginated: false, maxPageHeight: null, maxPageWidth: null}, current report pagination flag: true
2021-01-19 10:13:47,074 DEBUG WebflowReportContextAccessor,http-nio-8080-exec-10:88 - flow found [email protected]8db2 for id 1974570418_1611011463262_1
2021-01-19 10:13:47,074 DEBUG WebflowReportContextAccessor,http-nio-8080-exec-10:88 - flow found [email protected]8db2 for id 1974570418_1611011463262_1
2021-01-19 10:13:47,074 DEBUG WebflowReportContextAccessor,http-nio-8080-exec-10:88 - flow found [email protected]8db2 for id 1974570418_1611011463262_1
2021-01-19 10:13:47,621 DEBUG AbstractReportExporter,http-nio-8080-exec-10:196 - exported to buffer of size 4924
2021-01-19 10:13:47,621 DEBUG ResourceTypeMappingAction,http-nio-8080-exec-10:98 - found cached resolved type com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.ReportUnit for /public/ca/pm/reports/capm_topn
DX NetOps 20.2.x CAPM
CABI JasperServer 6.4.3
Broadcom Level 2 Sustaining Engineering created a configuration fix as per DE486800.
Please raise a Support ticket with the Debug output configured as per above and provide the resulting jasperServer.log