Technology Tips and News
SP2010 - I'm SCA of a site collection...
I need to rename a site, (site settings, title etc), but when I rename and try to save, it says "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator."
ok I understand the problem, but I don't have access to Central Admin and increase the Treshold or whatever.
I need to do that within the Site collection - I've rights use Sandbox solution.
Please advise how to rename the site? (LINK)
Hi, Admins have got a bigger threshold. Easiest would be to ask a site collection admin to change it.
If that is a issue it is possible that the admins can configure a List view threshold to allow larger queries during off peak times.
Hi, Admins have got a bigger threshold. Easiest would be to ask a site collection admin to change it.
If that is a issue it is possible that the admins can configure a List view threshold to allow larger queries during off peak times.
I'm site collection administrator. I don't see any possiblitie in Site Actions,
I just try to rename the site and I get the treshold.
How to see which list gives the treshold?
How to rename the site without increasing the treshold on Central admin. (I don't have rights to goto Central Admin, I need to request, which will not taken).
Hi, Then you might need to be a farm administrator.
The threshold can be seen in Central Admin if you go to the Web Application and then on the drop down under General Settings there is a option for resource Throttling.
FYI: Dont change any throttling values without doing research. Items like list view threshold can have a very negative impact.
Hi, Then you might need to be a farm administrator.
The threshold can be seen in Central Admin if you go to the Web Application and then on the drop down under General Settings there is a option for resource Throttling.
FYI: Dont change any throttling values without doing research. Items like list view threshold can have a very negative impact.
Hi EnthemD,
you can go to view all site content (url of your site followed by _layouts/viewlsts.aspx) and then look at the item counts on your lists and libraries and you'll be able to find the ones that are greater than the threshold.
SharePoint default List view threshold is 5000 for regular users, and 20000 for auditors and administrators (farm admins).
Please note: there could be more than one list or library that exceeds the threshold. when you find one greater than 5000 see if you can open it and then open settings. This will show you the threshold setting. Also there might be lists inside subsites that are over the thre
Hi Stacey,
thank you so much. I indeed saw it in in (View all site content) there was a document library showing 8046 and the treshold was 5000. And this document had also many many folders, sub folders etc.
Also my feeling is when there is a treshold you can't do much in that list/library, like save document library as template....
So what's normal way in fact. If there is treshold and the user keeps uploading files in library or add items to list... ??
You can't.
If you've breached the threshold various activities cannot be performed until/unless you reduce the number below the limit. This includes any actions that would require hitting all items at once (such as adding columns or re-naming the list)
You'll either need an admin to do it, to find out if you've got a scheduled 'large query window' or to have the list excluded from the threshold limit.
It's probably SharePoint's biggest structural weakness at the moment. That and the 2GB limit.
As Alex said, it is one of the biggest weaknesses in SharePoint.
You need to decide when and how you are going to reduce the size of the list. And put a governance policy (written document that is vetted through management) in place that states that lists need to be below the default 5000 item limit.
I DO NOT recommend increasing the limit, although I have seen companies do this. All it leads to is the eventual crash of your farm and many, many more lists that then need to be paired down.
to fix your issue though, you could increase the limit, then export the list to excel, then decrease the limit back to default 5000 and then do your work in excel by parsing the list into however many you want, based on some criteria that you decide (date, unit numbers, or what ever makes sense)
then import the excel files to new lists, after you have the new lists imported, business could test, then you could increase the limit one more time, so you can delete the original list.
and for renaming the site, if you don't want to do all the list work, you could increase the limit, and rename the site with set-spsite, assuming you're using host named site collections. If you're using path based, you could export the site, then create the site and all its subsites, and perform the import; which is one more reason why HNSC is the way
You can do that but it's not easy.
Ask your admin if they will exclude that list from the threshold temporarily during down time to allow you to make the change. One lesser known trick is to modify the list/library to exclude it from the threshold using PowerShell or another management tool. They can then re-set it.
Or, as a final option, ask the admin to perform the action on your behalf as they may have the higher 20k limit by default.
You can do that but it's not easy.
Ask your admin if they will exclude that list from the threshold temporarily during down time to allow you to make the change. One lesser known trick is to modify the list/library to exclude it from the threshold using PowerShell or another management tool. They can then re-set it.
Or, as a final option, ask the admin to perform the action on your behalf as they may have the higher 20k limit by default.
You're correct, in order to even work on that list, the threshold would have to be increased, momentarily, or a window would need to be set as Alex advised.
when you bring it into excel, you can determine the breakdown, then you would create two or three spreadsheets and upload them, each, as new lists.
in re may damage farm, wouldn't damage immediately, unless you have a lot of large lists. and you run the risk of getting a lot of large lists if you just increase the threshold without taking action on the large lists to reduce their size so you can set the threshold back.
if you ran into an issue after increasing the threshold, with your farm, you might have to increase server resources, cpu and memory. IF you run into an issue. I have upped the limit to 50K before in a farm that had lists and the servers had 4 cpu and 24 GB ram, did the work, then decreased threshold without issue.
This is strange, my answer which is the same as excepted answer was un-suggested as answer by a moderator... Hemendra Agrawal...Why would he do that?
Sorry but that is a joke...There are people proposing answers for my questions all the time. Remove the link if we are not suppose to use it. The user never selected an answer, the moderator changed it probably to one of his buddies.
Thought i would try and get a bit more involved in the forum but there is not really a point is there.
It does serve a purpose but it's not generally considered polite to suggest your own answers and is best avoided unless the answer is blindingly obvious. Or if the original poster has said that it worked and forgotten to mark an answer themselves.
MSDN points have a significant element of randomness, it can be irking to see someone else post the same thing you did and get points for it, but I try to remember two things. Firstly they really don't matter much and secondly in the end it probably averages out. In this thread no single post answers the question but together we got enough information through.
This topic is archived. No further replies will be accepted.
Other recent topics
Click here to get your free copy of Network Administrator. Over 25 plugins to make your life easier