CABI JasperServer Report Exports no data from CA Performance Management (CAPM) in all formats except PDF

Products

CA Performance Management - Usage and Administration

Issue/Introduction

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.

Cause

This is due to configuration of the JasperServer output to Excel format due to the following possible problems :

column size is not the same across the board
Cells are merged causing unexpected layout or order in the data
The report's header or footer causes unexpected layouts

This can be debuted by enabling activity for class com.jaspersoft.jasperserver.war.action by do the following

Log in to CABI server as superuser.
Go to Manage - Server Settings
Scroll down and add the com.jaspersoft.jasperserver.war.action with DEBUG
The output will be in the JasperServer log file:

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,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,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

Environment

DX NetOps 20.2.x CAPM

CABI JasperServer 6.4.3

Resolution

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