Error exporting CrossTab Report / Adhov view in Advanced Reporting.

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When exporting Crosstab Report / Adhoc view in Advanced Reporting to excel it returns:

Error Message:
Crosstab bucket/measure limit (100,000) exceeded.

Environment

CA PPM SaaS and CA PPM On Premise

Cause

This error is related to the JasperReports Library property:

net.sf.jasperreports.crosstab.bucket.measure.limit

Resolution

By default this property is set to 100,000 in JasperReports Server.

For On Premise Customers:
This limit is configured in jasperreports.properties file under deployed <Jasperserver>\WEB-INF\classes\ directory. However, we caution users to consider performance impact on the server when increasing the limit.

Tibco Document Reference 

For SaaS Customers:
This limit cannot be increased as the JasperSoft server is a multi-tenant environment and increasing such limit can have major performance impact for others as well.

Suggestions is to redesign report to reduce the amount of buckets being generated whenever possible to avoid the limit eg. by putting in a Filter to limit the number of records generated. Or try change the format to a Table instead of Cross Tab which will not hit the crosstab bucket limit.

Additional Information

JasperSoft Community reference:
https://community.jaspersoft.com/wiki/getting-crosstabbucketmeasurelimit-error-when-runnig-cross-tab-report-jasperreports-server