Hello

I have set list threshold value in my web application as "5000" , I have one list named "MyTasks" having more 7000 items when I apply the group by to that list from list setting , its throwing below error :

Attempted to use an
object that has ceased to exist. (Exception from HRESULT: 0x80030102
(STG_E_REVERTED)),

If I set list  threshold value as "10000" , then its working , however different list with more than 5000 items working fine with group by on "5000" list threshold value.

Can anyone please let me know what can be the issue with "MyTasks" list.

Thanks and Re

Hello,

You have to index the column on you are doing the "Group by", and all columns you use for filtering/sorting.

You can find those settings in List settings > indexed columns.

Please tell me if it's working now !

• Edited by Aurélien Prévot Thursday, October 10, 2013 12:20 PM

Hello,

You have to index the column on you are doing the "Group by", and all columns you use for filtering/sorting.

You can find those settings in List settings > indexed columns.

Please tell me if it's working now !

• Edited by Aurélien Prévot Thursday, October 10, 2013 12:20 PM

Hello,

You have to index the column on you are doing the "Group by", and all columns you use for filtering/sorting.

You can find those settings in List settings > indexed columns.

Please tell me if it's working now !

• Edited by Aurélien Prévot Thursday, October 10, 2013 12:20 PM

Thanks for your kind reply and time !

I have checked following approach

1) created index columns - Didn't work

2) columns are not more than 24 too.

3) increased threshold value - Worked - I don't want to increase threshold value more than 5000

4) If I save the template of "MyTasks" list with content and create another list named "MyTasksTest" using same template - "MyTasksTest" is working with group by for same items.

However I am still not getting what can be the issue with "MyTasks" list and I cant use the 4th approach as I need to find the cause of "MyTasks" list.

Can you please let me know what should be the reason now ?

Thanks and Re

Did you create a view filter on the indexed column to bring the total results returned to <5,

Hi Trevor Seward,

Thanks to look over on this issue.I did as per you said, but when I click on "OK" button its redirecting to _vti_bin/owssvr.dll?CS=65001 url and displays "The page can not be found" when apply group by, while only filtering items working with view

Well , there is an item level permissions too , If I remove item level permission then group by works...that is what I found in new created list using template where item level permission was not there and hence it was grouping the item even it was more than 5000.

above issue we observer through sql profiler tool while querying list with item level permission and without permission , with item level permission the load over list was high and hence somewhere its got wrong and groupby didnt worked.

Can you please help me out on this further ?

Hi Dipti, 

What I've found when adding indexes to lists that already have more than 5000 items, is the existing list items need to be manually updated to create the indexes on the new fields. 

One way to do this, is to iterate through all list items (using PowerShell) and call the SPItem.Update (or SystemUpdate) method on each list item. You're best to do this out of working hours, and be aware that it does create a new version of the item if versioning is enabled on the list. To get around this, you can call SPItem.SystemUpdate($false).

E.g.

$w = Get-SPWeb "http://devmy102"
$l = $w.GetList("http://devmy102/lists/mybigtasklist");
foreach($item in  $l.Items){$item.SystemUpdate($false)}

Hi Matthew ,

Thanks for your suggestions, however that approach also didn't work.

I believe there is issue of item level permission settings at this list.

Do you have any reference link that specify that with 5000 list items level permissions cant work with group by view when threshold limit is 5000 ?

Thanks for your time,

Hi Dipti, 

What fields have you created indexes on, and which fields are you using to groupby? Did you create the indexes before the list items were added to the list?

Have you read the following documentation on Managing large lists: http://office.microsoft.com/en-gb/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx

Hi Matthew ,

Thanks for your kind reply, however we have following limits at requirement :

1) must be 5000 threshold limit

2) there is item level permission in list which is required in default view ( allitems.aspx )

I tried to increase unique permission limit at web application level though it didn't work.

there are two index field 1) Title - Single line of text 2) Status - Choice

Indexes created before list item added and after list item added not working.

however in same web application there is another list with 90K items with 5000 threshold limit but there group by is working with no item level permission.

Please let me know your further opinion for resolution

Thanks,

Hi Dipti,

I suggest export to excel try applying same filter and group and get rows, if its more than 5000, increase your view's threshold limit, (OR if you have U2U builder run same query filter and get row count...)

OR

can you check your list for some wrong data entered (either blank data entered for required field, or different data in data type mismatch or validation)... Over all your aggregate function calculation(group by) throwing error...

I am not sure but to me it seems data issue either way (wrong data or data limit)...

Thanks for your time and reply,

Well , I do not want to increase threshold limit as for the same threshold limit with other list having more than 5K items - group by is working. regarding the second option there is no wrong data in list because If I remove the item level permissions group by is working for the same list and hence it seems that due to over load of item level permission calculation its breaking the group by to work ahead, would you please let me know that is that the right assumption ? If yes then is there any reference links that can say that item level permission wont work with threshold list limit about 5K ?

Looking forward for your answers.

Thanks and Regards,

Hi Dipti,

Thanks for confirming doubts, I found a link which mentions its default 5K and it might cause problem when unique permissions are set, please read para-1 and para-last.

http://blogs.msdn.com/b/dinaayoub/archive/2010/04/22/sharepoint-2010-how-to-change-the-list-view-threshold.aspx