Skip to main content

My Sites showing error: Failed to retrieve items!

Hitesh Bansal
  • Updated

Overview

The My Sites section is not pulling content and showing an error: Failed to retrieve items!

mceclip0.png

When this happens, the browser Console may also indicate the following:

BONZAI ERROR: The attempted operation is prohibited because it exceeds the list view threshold.

mceclip1.png

 

Solution

Note: The following solution will work on any of the Bonzai features that use 'Favourites', like Site Directory, Document Portal, etc.
  1. Check if the 'Favourite Sites' list shows more than 5000 items
    Information: An item is added to this column each time a user adds a favourite.
    Favourite_Sites.png
  2. Remove items from the column so it shows 5000 or lesser items
    Remove.png
  3. Open the List Settings
    List_Settings.png
  4. Scroll down
    Scroll.png
  5. Under the 'Columns' section, click 'Indexed Columns'
    Columns.png
  6. Click 'Create a new index'
    Create.png
  7. Add "Favourite Site User" as an indexed column to bypass the threshold limit in Sharepoint. This allows the Web Parts to work even when exceeding 5000 list items.
    mceclip0.png

Testing

  1. Click 'Add More' under 'My Sites' and add more Favourites
    Test.png
  2. The 'My Sites' section should load without the error
    Working.png

Related Articles

Error: 'Failed to retrieve items!' and '503 Service Unavailable' on Bonzai Web Parts