The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
33 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 ...
0
votes
2answers
21 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 ...
1
vote
2answers
74 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
47 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 ...
2
votes
2answers
354 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
223 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
190 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
260 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
0answers
147 views

Powershell query for specific throttling/threshold errors?

We are in the midst of upgrading to SP2010 (by web app, 10 down; 4 to go) and many of our 2007 sites have "megalists"- the throttling in place in 2010 results in the lists/library views not working ...
0
votes
2answers
219 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 + ...
7
votes
1answer
1k 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 ...
0
votes
2answers
209 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 ...
0
votes
1answer
182 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 ...
2
votes
2answers
1k 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 ...
8
votes
3answers
4k views

“View exceeds list view threshold” even when it doesn't

I have a document library in SharePoint Foundation 2010 which contains over 10,000 items, arranged in folders such that no folder contains more than 2000 items. I've created a public view called ...
5
votes
7answers
5k views

What are good ways around the List View Threshold?

I'm trying to use data from a SharePoint list in SSRS (Reporting services). The report isn't too big - only a few dozens rows, but for each row I need to add data from a second list, which (currently) ...