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="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
<ErrorCode>-2147220970</ErrorCode> <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" /> <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!