Error exporting CrossTab Report / Adhov view in Advanced Reporting.
search cancel

Error exporting CrossTab Report / Adhov view in Advanced Reporting.


Article ID: 100561


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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

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


CA PPM SaaS and CA PPM On Premise


This error is related to the JasperReports Library property:



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

For On Premise Customers:
This limit is configured in 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: