SharePoint Content Structure and Reports Limit

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…

image

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 thoughts on “SharePoint Content Structure and Reports Limit

  1. Matz

    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

Comments are closed.