Jump to content
Changes to the Jaspersoft community edition download ×
  • Getting crosstab.bucket.measure.limit Error When Runnig a Cross Tab Report In TIBCO JasperReports® Server


    tchen
    • Features: JasperReports Server Version: v6.2.1, v6.2.0, v6.1.0, v6.0.1 Product: JasperReports® Server

    Question/Problem:

    User has created a cross tab report and tested it in TIBCO Jaspersoft® Studio. But when running the report on the server, user got the following error:

    [toc]
    net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.crosstab.bucket.measure.limit
    

    User wants to know what this error means and "how to fix it so that we can run the cross tab report on the server".


    Answer/Suggested Resolutions:

    The crosstab calculation engine performs all calculations in memory. In case large volumes of data are processed, it could be possible to run out of memory due to the large number of totals and aggregation variables that the engine keeps track of.

    To avoid the situation in which the JVM raises an OutOfMemory error, and thus triggers memory reclaim procedures with potentially serious effects on the application’s overall behavior, a crosstab governor has been put in place. This is basically a simple memory consumption test that the engine performs when filling a crosstab, to check whether a given memory threshold has been reached. When the limit is reached, the program raises an exception that can be caught and dealt within the caller program, preventing a more serious OutOfMemory error from occurring.

    The governor threshold is given as an integer number representing the maximum number of cells multiplied by the number of measures in the generated crosstab. It can be set using the net.sf.jasperreports.crosstab.bucket.measure.limit configuration property. This property defaults to -1, meaning that the crosstab governor is disabled by default. In JasperReports® Server deployment, this limit is configured in jasperreports.properties file under deployed jasperserver-proWEB-INFclasses directory. The default size is 100,000.

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

    User can increase the limit in the above jasperreports.properties file property setting to avoid the error. However, we caution users to consider performance impact on the server when increasing the limit, instead redesign report and reduce the amount of buckets being generated whenever possible to work around the issue.


    TTC-20181009


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...