Overview
Error displaying in place of widget. This error is due to the list item threshold being exceeded with more than 5000 items in the Favorites_AK list.
Error message:
Error Occurred: {{widget instance ID}} : Error querying Favorites_AK: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. undefined
Resolution
To resolve this issue, do the following:
- In SharePoint, go to Favorites_AK list
- From the gear icon (Settings) on top on the right hand side, you should be able to click on List Settings.
- On the bottom of the columns section, you want to click on indexed columns.
- Click on "create a new index" and select "Created By" from the drop down menu under primary column for this index, as shown in the image below, then click "Create".
- Refresh all cache and try reloading the page.
NOTE: The effect should be immediate. If not, retry the last step in 5 minutes.