Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 935502 - Last Review: May 11, 2007 - Revision: 1.1
Error message when you configure the Content Query Web Part in SharePoint Server 2007: "The query cannot be completed because the number of lists in the query exceeded the allowable limit"
You add the Content Query Web Part to a Web page in Microsoft Office SharePoint Server 2007. Then, you configure the Content Query Web Part to query and to display the data that you want.
For example, you configure the Content Query Web Part by using the following API calls:
SPSite site = SPControl.GetContextSite(this.Context);
SPWeb web = site.OpenWeb();
SPSiteDataQuery query = (SPSiteDataQuery)getQuery();
DataTable items = web.GetSiteData(query);
When you do this, you receive the following error message:
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.
This issue occurs if the Content Query Web Part is configured to query more than 1000 lists. The Content Query Web Part does not support more than 1000 lists at the same time.
To resolve this issue, configure the Content Query Web Part to query fewer than 1000 lists.
A cross-list query across lots of lists may allocate lots of memory because the metadata for all the lists is held in memory at the same time. For example, if you configure the Content Query Web Part to query 5000 lists, as much as 500 MB of memory may be allocated to the operation. In this scenario, you may experience the issue that is mentioned in the "Symptoms" section.
For more information about how to customize the Content Query Web Part, visit the following Microsoft Web site:
APPLIES TO
- Microsoft Office SharePoint Server 2007
| kbtshoot kberrmsg kbexpertiseinter kbprb KB935502 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please