We currently create this report in list viewer within the UMP. With the UMP going away (flash); we are trying to move the report to CABI. When trying to create a crossfeed report in CABI, we get a 100,000 bucket limit error.
We are trying to create a report with 54 devices, over a 1 week period using 1 minute intervals (would like a 5 minute interval but that is not an option). When we chose a 1 hour interval; the report will run for only 10 devices. More than ten devices causes this error. I will attach a screen shot of the error for your review.
2020-08-19 11:26:59,369 ERROR AsyncJasperPrintAccessor,pool-8-thread-585:321 - Error during report execution
net.sf.jasperreports.engine.JRRuntimeException: Crosstab bucket/measure limit (100,000) exceeded.
Release : 20.1
Component : UIM - CABI
- jaspersoft limit, configuration
This is a Jaspersoft error and here is the explanation and potential workaround:
https://community.jaspersoft.com/wiki/getting-crosstabbucketmeasurelimit-error-when-runnig-cross-tab-report-tibco-jasperreports
In this case, the customer increased the bucket size to 20,000,000 and ran the report.
62 devices, 7 days , 1 min sample. They were able to generate the csv file which took about 5 minutes.
Mem util went up to about 84% (out of 8GB). They may decide to increase RAM to at least 16 GB on the Jasperserver.
Report size:
10,084 rows
64 columns
Data point, three places (i.e., 1.00)