The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator
You might have developed a functionality where data is being saved in a SharePoint list. By the time you developed this functionality it was working fine.As users adds the data , some day your functionality doesn't work. That means, the data which is present in the list is not being retrieved.
Don't be panic. Just open the LOG file which is present in 14 hive folder. You will come to know about this bug with the statement -"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator".
Now what you have to do is, go to central administration site.
1.Click on Manage web application
2.Select the web application on which your sitecollection is created.
3.Click on General settings and select Resource throttling
4.by default list view threshold would be 5000. your list might have data more than 5000. So , increase the number to required threshold limit. you can make it 10000, 20000 like this.
Do a iisreset and it should work fine. But...But...but
Guys this is not a good way to manage the list . It affects big time on the performance. So better maintain indexing to items by referring to ID column or some other column.
hope this may help someone
cheers
Pradeepa achar
Comments
Well this is not a good attempt all as you said it will hit the performance. Do you know the reason why?
Let me tell you...
If you increase the threshold number in web-application it will effect on all list/libraries in every site created under that web-app. Due to which your performance will hit badly as well not a good practice at all. The better way to handle this is to just disable threshold for ONLY that list which you are trying access. And to do that use the below PS script
$web = Get-SPWeb https://Site Collection Name/
$list = $web.Lists["List Name"]
$list.EnableThrottling = $false
Hope it helps you.