Having problem with crosstab while filling data

[mmrajuk_jasper]

 

First, let you clear with my situation.

 

I am running the report(jrxm file) using JasperServer(V:3.0). I knew that my report query will return huge data back to the JasperServer.

 

My report is using crosstab to fill that data.While filling it was throwing the following exception.

 

Error Trace:

net.sf.jasperreports.engine.JRRuntimeException: Crosstab bucket/measure limit (100000) exceeded.

 

net.sf.jasperreports.engine.JRRuntimeException: Crosstab bucket/measure limit (100000) exceeded.

at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.checkBucketMeasureCount(BucketingService.java:985)

 

Find whole error trace in the attachement.

 

I googled it. But, nothing I got.

 

I am wondering, where I can define the limit for the Croostab bucket/measure?

 

How can I resolve this problem?

 

Please, can you reply me as early as possible? This is very urgent work for me.

[lucianc]

Edit $TOMCAT/webapps/jasperserver/WEB-INF/classes/jasperreports.properties and change the value of the net.sf.jasperreports.crosstab.bucket.measure.limit property.

HTH,

Lucian

[kuzman]

Hi,

I also have the same problem.

I have modified the bucket limit. After I got out of memory problem.

After I have tried to increase the TOMCAT memory on WinXp, I have changed the --JvmMx 512 parameter to 1024 or more. After this I can not start the TOMCAT service. It starts only with max 900 (meg).

I have loked into the logs, and the tomcat says:

could not reserve enough space for object heap..

In the taskmanager I have seen there is 1,7G free memory....

How can I give more memory to the TOMCAT service?

 

Zs