We ran into an interesting issue this week where all reports at the site collection level within "Content Structure and Reports" stopped working. The log included the following error:
Query Execution threw SPException: The query cannot be completed because the number of lists in the query exceeded the allowable limit
10/10/2008 11:38:19.16 w3wp.exe (0x09F8) 0x07F8 CMS Site Management 622h
Unexpected SMReportsData GetQueryResults – Query Execution threw SPException: The query cannot be completed because the number of lists in the query
exceeded the allowable limit. For better results, limit the scope of the query to the current site or list or use a custom column index to help reduce the number of lists.
My esteemed colleague Carlos Fernandez uncovered the following fix…
The default lists limit for the query generated by these reports is a 1000, so running the reports at the site collection level caused SharePoint to exceed this amount when the site contained more than 1000 page libraries. Populating the CAML List Type with:
<Lists BaseType="1" MaxListsLimit="0"/>
3 Comments
We have come accross this issue as well, that’s why we use external DB for our usage reports…
you can see solution architecture on our web site – http://www.intlock.com
Thanks
Uri
We have the exact same problem.
I did as described above, but without seeing any changes when running the reports.
Still get the error message in the Sharepoint logs.
Any ideas?
Thanks!
/Matz
Found what was wrong! MaxListsLimit shall be MaxListLimit, without the “s”!