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"/>

About these ads

3 Comments

  1. Posted October 17, 2008 at 2:47 pm | Permalink

    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

  2. Matz
    Posted February 2, 2011 at 6:10 am | Permalink

    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

  3. Matz
    Posted June 8, 2011 at 2:52 pm | Permalink

    Found what was wrong! MaxListsLimit shall be MaxListLimit, without the “s”!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 292 other followers

%d bloggers like this: