Error exporting CrossTab Report / Adhov view in Advanced Reporting.

Document ID : KB000100561
Last Modified Date : 08/06/2018
Show Technical Document Details
Issue:
When exporting Crosstab Report / Adhov 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.

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 corsstab bucket limit.
Additional Information:
JasperSoft Community reference:
https://community.jaspersoft.com/wiki/getting-crosstabbucketmeasurelimit-error-when-runnig-cross-tab-report-jasperreports-server