XQE-V5-0013 (The number of rows retrived exceeds the limit of '1250000'.)

[superman99]

Hello, I am using Cognos Analytics 11.2. I have a list report for which I get an error. I tried to changed the maxRowRetrieved for the Query but still it does not work. Appreciate any guidance.

[MFGF]

Hello, I am using Cognos Analytics 11.2. I have a list report for which I get an error. I tried to changed the maxRowRetrieved for the Query but still it does not work. Appreciate any guidance.

Hi,

Is this an Active Report? If so, go to the Properties pane, choose Report, then click the ellipsis next to the "Active report properties" property. In the dialog that opens, look for the "Maximum query rows" setting and increase it to whatever you want it to be.

Cheers!

MF.

[superman99]

Thank You for your reply. No, it is not an active report. It is a regular list report.

[MFGF]

Thank You for your reply. No, it is not an active report. It is a regular list report.

Hi,

Ok - as a final sanity check, is the "Maximum rows retrieved" property of the query that feeds the list set to a specific value, set to 'All' or set empty?

Are there any other queries in the report?

Cheers!

MF.

[superman99]

I did change the Maximum rows retrieved within the Query to "ALL" and it did not work, so I changed it to a value "9250000" which also did not work.

The list report is using that query. In addition, there are quite a few queries and I am using it Direct SQL.

[MFGF]

I did change the Maximum rows retrieved within the Query to "ALL" and it did not work, so I changed it to a value "9250000" which also did not work.

The list report is using that query. In addition, there are quite a few queries and I am using it Direct SQL.

Is it possible the error is being triggered by a different query in the report? Have you checked the property for all queries?

Cheers!

MF.

[superman99]

I ran all the queries including the one which is giving an error in "view tabular data" and they all work fine. As soon I try to export it into excel that is where I am getting an error.

[MFGF]

I ran all the queries including the one which is giving an error in "view tabular data" and they all work fine. As soon I try to export it into excel that is where I am getting an error.

Hi,

"View tabular data" will only display data one page at a time and won't retrieve the entire data set in one go (just like running a report interactively in HTML). This means you can't rely on the View Tabular Data feature to test your queries to see if they exceed row limits. You really need to check the Maximum Rows Retrieved property of each query.

I'm wondering what you're trying to achieve with a list report that retrieves over a million and a quarter rows and dumps it into Excel? It doesn't sound like a report that could be delivering much insight?

Cheers!

MF.

[superman99]

You are spot on. I found that there is an issue with the SQL statement where it is bringing unnecessary rows. I am working on it to fix it but I want to thank you for your guidance. I believe this the only platform where I could get advise. Much appreciated.