Ad Hoc Report- Large result set issue

[Kumar_rahul]

Hi All,

I have topics which typically return large result sets, in the range of 3,00,000 records. Each time I try to create a report I get an error screen with message "An error occurred. Check the server's logs for details.". PFA the server log.

1) What can be done to overcome this problem given that I can in no way optimize the query, as it is a simple select statement?

2) The second statement in the log is "limit of cat column unique values is 32767". What exactly does it mean? Does it any way refer to the number of maximum records that the Ad Hoc report can support (In which case it is approximately 10th of what actually my topic fetches)?

Thanks and Regards,
Kumar Rahul. [file name=log-f37707589494bdda9fefb76ded3c1655.txt size=9449]

[mdahlman]

Hi Kumar,

 

This was a known bug in JasperServer 2.0 where a short was used when an int was needed. It was fixed in JasperServer 2.1.

 

(So I guess that means the issue will still exist if you have over 2,147,483,647 rows... but hopefully that won't cause any real problems.)

 

Regards,

Matt

Post edited by: mdahlman, at: 2008/04/14 19:41