XQE Error

[Greg]

I have a DMR model using DQM and have built an active report based on it.  When I run I'm getting the following XQE error.

XQE-V5-0013:  The number of rows retrieved exceeds the limit of '5000'. Please increase maxRowsRetrieved hint for the query 'LoadLevels'.

Not sure what it's trying to do.  LoadLevels is not one of the queries in my report so it must be something that XQE is doing in the background to satisfy the report.  It's just a simple list report with a count and % Total.

Anyone seen this before? 

Thanks.
Greg

[marchaq]

Hi Greg,

Did you ever figure this one out? It just started happening in our environment also... Thanks!

[MFGF]

Hi,

Sounds like you are hitting the default row maximum for the Active Report? In Report Studio go to File > Active Report Properties and increase the "Maximum query rows" value to something larger than the number of rows your report will retrieve.

Cheers!

MF.

[marchaq]

Exactly right! Thanks a lot!

[losjims]

Hi guys

I am getting the same error message when using Cognos Workspace Advanced - just adding a Measure and large Member set....

Any ideas where I can amend the setting (if any)?

Thanks

[MFGF]

Hi guys

I am getting the same error message when using Cognos Workspace Advanced - just adding a Measure and large Member set....

Any ideas where I can amend the setting (if any)?

Thanks

Are you sure it's the exact same message? The message above is in an Active Report and occurs where the report's maximum row limit is breached. If you're using Cognos Workspace Advanced, you can't be creating an Active Report, so the only other reason I can think of for you seeing a similar message is that your package has a governor defined which limits the amount of data a report will retrieve.

If you have access to Framework Manager and your metadata model, open the model and on the Menubar select Project > Edit Governors and see what is in the "Maximum number of retrieved rows" value. Setting this to 0 will turn off the governor.

Once you have made this change you will need to re-publish your package.

Cheers!

MF.

[losjims]

Many thanks for the reply

For sure I am not using Active reports - actually this is the error if I use Report Studio (from the cognserver.log)

10.53.253.171:0   26505   2015-01-15 15:45:09.150   +7   5241DD24E950A9D03EF305F81A795C6EBE808B63788E42A4C659AD0295AA9CFD   qdvsvy2q898dvj2q9wCls2484G22jhvMMv2jjGw2   248w44jyy4j2qd4yvMw8sh2yM29vdMy2hl4sCGyC      -1837402368   RSVP   5005   1   Audit.RTUsage.RSVP   Response   ReportService      Failure   XQE-V5-0013 The number of rows retrieved exceeds the limit of '50000'. Please increase maxRowsRetrieved hint for the query 'singleTabularQuery'.

--------------

And this is the error when doing the same type of report in Workspace Advanced.

10.53.253.171:0   26505   2015-01-15 15:45:09.145   +7   5241DD24E950A9D03EF305F81A795C6EBE808B63788E42A4C659AD0295AA9CFD   qdvsvy2q898dvj2q9wCls2484G22jhvMMv2jjGw2   qdvsvy2q898dvj2q9wCls2484G22jhvMMv2jjGw2      -1392843008   RSVP   5005   3   Audit.RTUsage.RSVP   Execute   Report ReportService   /content/folder[@name='Ungdung_ToanNganh']/adHocReport   Failure   RSV-SRV-0063 An error occurred while executing the 'asynchRunSpecification_Request' command. XQE-V5-0013 The number of rows retrieved exceeds the limit of '50000'. Please increase maxRowsRetrieved hint for the query 'singleTabularQuery'.    <parameters><item name="model"><![CDATA[/content/folder[@name='Ungdung_ToanNganh']/folder[@name='BIDV-MIS']/folder[@name='Packages']/folder[@name='Cube']/package[@name='Phân tích Tiền vay (Cube)']/model[@name='model']]]></item></parameters>

-------------

Also the Governor setting was 250,000 - which I thought was strange as the error mentioned 50,000 - anyway - I set the Governor to 0 and also increased some settings in the qfs_config.xml (such as MaxNumberofMembers etc) and this seemed to help.

BTW - this is a DMR Model on top of Netezza.

So - in summary, I suppose my question is this....where is the limit of 50000 being set / used?

Thanks again..

[cognos810]

Hello losjims,
Netezza has a user/group based restriction mechanism as well and can be applied on user tables and views. Can you check with the Netezza owner/admins, if such a limit is set?

-Cognos810