Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

BIRT throws "A huge result set was found here". Ignore or panic?

When running some BIRT reports I see warning in the log:


 WARN com.ibm.team.repository                             - A result set of 13352 entries was seen.  The AstQuery is:

TimeSheetEntryQueryModel r = TimeSheetEntryQueryModel.ROOT;
<CUT>
java.lang.Throwable: A huge result set was found here
 at com.ibm.team.repository.service.internal.QueryService.cacheQueryResult(QueryService.java:381)
 at com.ibm.team.repository.service.internal.QueryService.doExecuteDataQuery(QueryService.java:311)
 <SO ON>

Is it OK or report can be incorrect? Which setting\threshold causes BIRT threat number as huge?

0 votes


Accepted answer

Permanent link

Vladimir,

This is just a warning. There is no data loss. Your report will still show all the data (if your server does not run out of memory). But as Daniel had said, you should redesign your report and avoid fetching all item instances of a certain kind (in this case you are fetching all Timesheet Entries in the system).

Vladimir Amelin selected this answer as the correct answer

2 votes

Comments

We use all known limitations in the query like project areas, for\to dates etc. But still it can fetch thousands of entries (repository contains about 200k of entries). Only way left is to split dataset artificially. For instance, make it fetch day by day or contributor by contributor. Anyway thanks for clarification, Rafik.


One other answer

Permanent link
 Vladimir,

  I would be worried.  BIRT reports are notorious for consuming large amounts of memory, and large data sets will consume large amounts of memory.  This will impact performance for ALL of your users.  When writing BIRT reports it is critical that you structure your queries to limit the size of query results, and avoid things like large table joins.

1 vote

Comments

 Thank you, Daniel. Actually we run such memory-consuming report in the night only (using CURL).

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,121
× 324
× 230

Question asked: Jan 31 '13, 7:46 a.m.

Question was seen: 7,584 times

Last updated: Jan 31 '13, 11:18 a.m.

Confirmation Cancel Confirm