CRM 2016 Advanced Find Error

I had a strange scenario where users would get this error message whenever they tried to use Advanced Find:

So as you do, you get them to download the log file and send it across to you.
This was the error message in the log file

Unhandled Exception: System.ServiceModel.FaultException1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Privilege Type Append not defined on entity 'UserQuery'.Detail: <OrganizationServiceFault xmlns:i="" xmlns=""> <ErrorCode>-2147220970</ErrorCode> <ErrorDetails xmlns:d2p1="" /> <Message>Privilege Type Append not defined on entity 'UserQuery'.</Message> <Timestamp>2016-08-11T22:50:56.4880068Z</Timestamp> <InnerFault i:nil="true" /> <TraceText i:nil="true" /> </OrganizationServiceFault>

Awesome, the problem is stated here == Privilege Type Append not defined on entity 'UserQuery' == so we simple need to go to the security role and ensure the Append property is set on the UserQuery right?Simple, except when you open up a security role that option isnt available!

Whats going on here?! I raised a support ticket with Microsoft and basically the issue was with something gone strange with the Hierarchical modelling.
The steps to follow to resolve this are:

  • Login into CRM as system admin
  • Navigate to Settings > Security > Hierarchy Security
  • Ensure that 'Saved View' is part of the excluded entities:
  • Click on 'Save and Close' and that should fix it!

A very random error message which I hadn't seen before and hopefully this will help others that might come across this!