Hi, @RoyceLithgo,

I have verified in my system, GI is showing a record count for 10 million records as well.

Could you please let us know how much huge data you are trying to retrieve in the GI?

Thanks for the reply @Naveen B. I found that the problem had to do with some sort of corruption with the Site Map. When I removed the Query from the UI and added it back again (no other changes made at all), the record count appeared. So weird. 

That's great Thanks for sharing the update.

Hi @RoyceLithgo ,

I have also seen this message with complex custom GIs.  It can be intermittent, and in my experience it seems to be associated with the runtime of the query, not necessarily the final number of records returned.  In addition to the warning message, we noticed that aggregate totals do not display in this situation.  If you continue to have issues, depending on your requirements, a workaround may be to build a custom report using Report Designer.  On the report you can of course include the aggregate totals, and there is also the ability to define an Excel export if needed.

Laura

To calculate the count *and* display the results, the system needs to run two queries. To ensure responsiveness of the application, the Generic Inquiry system will wait for a predetermined amount of time (a few seconds -- I don’t remember the exact length). If the count of records is not returned in the allotted time, the query is canceled and the GI will only display the records.

More than likely, this means that you have a complex join expression or condition that requires full table scans instead of faster clustered index operations.

Analysis of the SQL Query Execution plan through SQL Management Studio is recommended in such cases. In some cases it can simply be because you’re missing a field in the relationship (ex: joining by OrderNbr instead of OrderType,OrderNbr). You might be missing an index somewhere as well.

Thanks a lot @Gabriel Michaud for the detailed explanation.

Thanks for this thread, and the suggestions, very useful.  We are on a SaaS model so SQL analysis will be tricky.  Sometimes we get this error and sometimes we don’t.  I have a particular (fairly simple) GI on the table AUAuditValues, which I am sorting by change date descending (the other indices don’t work for us) and this is where we sometimes see it.  Maybe it’s internet speed related.  Currently ± 3 million records.

“ In some cases it can simply be because you’re missing a field in the relationship (ex: joining by OrderNbr instead of OrderType,OrderNbr). “

This is what fixed my GI, tightening up the joins caused the records to display. 

Thanks Gabriel!

is it possible to extend the time allowed for the record count query?

when the results are not calculated, the data cannot be exported to excel.

Hi All,

I just had this same issue, but none of the solutions listed worked…

However, when I added a grouping clause, it started working perfectly. I still have absolutely no idea why this would help, but a solution is a solution, right?

-Aaron