It's all about the answers!

Ask a question

RQM Reporting Error: org.eclipse.datapools.connectivity.oda.OdaException maximum record count exceeded.


Rajesh Avanthi (10815145173) | asked Jul 15 '14, 12:57 a.m.
Under RQM v4.0.6, we are unable to generate dashboard report using the widget Test Case by
Test Environment(Live). Please find attached screenshot. Any inputs on why this error occurs ??

Comments
Donald Nong commented Jul 15 '14, 5:47 a.m.

You may have got a similar issue as this one:
https://jazz.net/forum/questions/157200/error-during-running-newly-deployed-report
Try the steps there, just replace "ccm" with "qm".

One answer



permanent link
Clara Forero (6212) | answered Jul 15 '14, 9:19 a.m.
JAZZ DEVELOPER
Hi Rajesh,

There is a server advanced property for reports: "Maximum Record Count" that sets the maximum number of records that can be read on a query.  If that number is exceeded the error will be displayed.  The recommendation would be to either tune the parameters of the report so it returns less records or increase the value of that property.  An issue with increasing the value could be low performance since users will be allowed to run huge queries that can end up affecting everybody.

Thank you,
Clara

Comments
Rajesh Avanthi commented Jul 16 '14, 10:09 a.m.

Thanks,

we have tried with the values suggested
Maximum Record Count  &  Maximum Query Result Set Size and still facing
the same error....
Any other inputs please??



Clara Forero commented Jul 16 '14, 4:41 p.m.
JAZZ DEVELOPER

Hi Rajesh,

What values have you tried for the mentioned properties? You can change Maximum Record Count to -1, so it will allow the maximum number of records, but then it will hurt the performance of the application for everybody.  Have you tried changing the parameters so less records are selected?

- Clara


Rajesh Avanthi commented Jul 18 '14, 7:36 a.m.

Thanks Clara

Interestingly, we only have total record count as 9 in this case. So do you still suggest that setting the Maximum Record Count to -1 would be helpful ??
Also is there any other report same as "Test Case by Test Environment(Live)", giving similar report output ?


Clara Forero commented Jul 21 '14, 3:06 p.m.
JAZZ DEVELOPER

Hi Rajesh,

I don't understand what you mean by "we only have total record count as 9 in this case".  Does it mean that the report returns only 9 records? or does it mean that the property is set at "9"?  If it seems to be an issue with the customer's environment, please open an escalation so we can gather all the necessary information.

Thanks,
Clara

Your answer


Register or 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.