The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [list-view-threshold]

The list view threshold is a value defined in Central Administration that limits the number of items that may be viewed or acted upon at a time, and is intended to prevent a performance impact that may be incurred if such an action is taken. This may be bypassed at the administrator's discretion by using object model code, or during specific hours of the day (usually overnight).

Filter by
Sorted by
Tagged with
0
votes
1answer
129 views

Can the list view threshold be configured for a specific content database, instead of for a web application?

The List View Threshold is configured via Central Administration for a specific web application. If I have more than one content database for a given web application, is it possible to have separate ...
3
votes
2answers
3k views

How to run ReST query to a list when the item count is more than the List View Threshold?

I have a list that contains around 16000 items and will be growing. The List View Threshold is set to the default value of 5000 (SP 2010). I have nothing to do with the SP list views and UI for this ...
0
votes
2answers
2k views

How to filter a people/user column that has been indexed

I have a long list (more than 5,000 items) and due to view threshold I indexed some columns. One of them is a people/user column. When I want to create a view that filters on the User column, then it ...
0
votes
2answers
225 views

Overcome List View Threshold with OR filter?

I have a list that multiple different people of different roles have to use. There are "submitters", "targets" and "managers" (specifically called "Created By", "Assigned To" and "DM", erspectively, ...
8
votes
3answers
7k views

BCS External Content Type with 20,000+ items (O365)

We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and ...
1
vote
2answers
3k views

How to use an index with list view threshold

I have a list with 20,000 records that I have been trying to deal with. Threshold is at the default 5k. I was under the impression that if I index a column, filter on it, and my results are under 5k, ...
4
votes
5answers
672 views

Error in my custom webpart: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

I am using sharepoint 2010. I have created a custom webpart. In this webpart it is possible to add a new item. Before I add this new item, I need to select some values from drop down boxes. In the ...
0
votes
2answers
138 views

Is SharePoint the right content management solution for flat file storage?

Our org currently uses SharePoint 2010 to manage an Image library. This library currently contains about 12k+ images of about 4-8mb (considered to be low resolution images) each. The motive behind ...
0
votes
0answers
225 views

View error on AllItems.aspx

This error just cropped up and has me puzzled. This view cannot be displayed because it exceeds the list view threshold (10000 items) enforced by the administrator. ...but what has me scratching my ...
1
vote
1answer
8k views

How can I configure a View filter/index to go around the item threshold?

I want to create a paginated view that shows me ALL the items, 30 items at a time. I have a list with 8000 items. The item limit is 5000 items, so I got this error on the "All Items" view: This ...
2
votes
3answers
407 views

SharePoint big list limitations

I have a scenario where there might be potentially more than 25 thousand documents in a single document library. Can a single document library SharePoint handle that number of items? What would be ...
2
votes
1answer
1k views

Threshold limit reached with a calendar month view

I'm perfectly aware about the threshold thing. I know I need to reduce my query. However, here, it's for a calendar... I use the below query: <query> <Query> <Where> <...
3
votes
4answers
15k views

Error - while exporting a Sharepoint List (Export to Excel)

Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues. Note: He is ...
2
votes
1answer
643 views

Cannot retrieve all items from large SharePoint list via Excel data connection

I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset ...
1
vote
1answer
629 views

Impact of using Daily Time Window for Large Queries

What would be the impact on perfomance if i configure Daily Time Window for Large Queries instead of increasing list view threshold? Does it mean the same as increasing list view threshold for a ...
0
votes
1answer
140 views

List View Threshold Error - Based on User

I have a SP list with over 29K items. Because of the LVT, I have created views where the number of items returned are under 5K. I have an indexed column, Tester (Name and Group), which the views ...
3
votes
2answers
677 views

Why am I NOT receiving an SPSiteDataQuery throttled exception?

I am unsuccessfully attempting to cause an SPQueryThrottledException locally in order to debug a problem a customer is having. I'm using SPSiteDataQuery to query several sites which contain 4000 to ...
8
votes
1answer
3k views

List View Lookup Threshold Exception not thrown when submitted without Query element

SharePoint 2010 includes a list view lookup threshold as part of its resource throttling. Columns that count as a lookup include Lookup, taxonomy (managed metadata), and User (PersonOrGroup) The ...
2
votes
1answer
1k views

Attempted operating is prohibited because it exceeds the list view threshold enforced by the administrator

I am trying to access a SharePoint library via Outlook. To do this, I went to the document library, clicked on Library Tools > Library > Connect to outlook. In outlook I get the error: Can error ...
0
votes
1answer
129 views

Large list - List view Threshold - SP 2010

For a project requirement client wants - saving 1 million document in a flat document library. Though document size is low, total data is not more than 9 GB. Due to Threshold settings can we store 1 ...
1
vote
2answers
1k views

Sharepoint list view threshold maximum limit?

I have a client who has already exceeded default sharepoint threshold. Is understand that it is not advisable to increase the default limit but in my case i am left with no other option than to ...
0
votes
1answer
1k views

Error exporting list to excel - permissions for resource throttling ceiling

What level of permissions have to be assigned to a user account in SharePoint 2010 for them to qualify as an "administrator" and therefore grant them access to the higher ceiling for resource ...
3
votes
2answers
3k views

SPQuery works on libraries under the list view threshold, but not over

So I am building a webpart which enumerates all doclibs in the current web, grabbing all checked out files and listing them in a table, allowing a user to apply some required metadata and check in ...
4
votes
1answer
566 views

SharePoint List View Threshold Error on Delete and Re-load of Data

Foremost, I am not an administrator of SharePoint site and have very limited controls on my page. Earlier, I had created a list (custom list with Datasheet view). I had created over 20 views (one ...
7
votes
3answers
841 views

Is it recommended to store high volume transaction data in SharePoint Lists?

I need to devise a solution strategy for an internal application that will take inputs from rfid tags and those records will to be stored "somewhere". Now this somewhere needs to be choice a between a ...
2
votes
1answer
1k views

delete large list in SharePoint2010

I have a List in sharePoint with 64095 items , I want to delete list completely , but I can't delete list beacuse of number of items. The error message is similar to: The attempted operation is ...
0
votes
1answer
223 views

SharePoint as digital documents library and search function

I want to use Sharepoint as a digital document library and the listview threshold limit is getting in the way, I want to increase the threshold limit to a very big number... lets say a million (1,000,...
0
votes
2answers
611 views

SPQueryThrottledException when doing file.Item

So I have a document library with sub folders in SP2010 "FI\Supporting Docs\F1234" & "FI\Supporting Docs\F1235" the F123 is created for each incident we deal with. There are currently 5000 + ...
0
votes
2answers
325 views

increase List threshold or Custom Filter?

I have a list over 200,000 items in it. It's on normal threshold (2,000 items per view). Users want large threshold but there is price for that. SQL traveling/transaction, server overhead and the ...