SharePoint 2013 List threshold error and retrieving data – Unable to execute query: Error 0x80070024

If you get the following error when your users have less privileges than let’s say and admin:

Unable to execute query: Error 0x80070024The attempted operation is prohibited because it exceeds the list view threshold

This is due to the problem that an admin is not affected by list threshold limits while a normal user is bound by these restrictions. Now you could go to Central Admin and change the threshold value from the web application management BUT this is not advisable unless you really know that you are doing. Changing this value may affect the performance of the site in a negative way.

What to do instead is to index the list through a column. In my situation I made a query from an app and needed only the title column data. So I indexed this field. For more info check these links from Microsoft:

https://support.office.com/en-nz/article/Manage-lists-and-libraries-with-many-items-fba0c8b7-79bb-4ea4-9aff-bf145a689e8e#bm2

https://support.office.com/en-us/article/Manage-lists-and-libraries-with-many-items-b8588dae-9387-48c2-9248-c24122f07c59

https://msdn.microsoft.com/en-us/library/ff798465.aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s