Bruce 365

CRM 2016 Advanced Find Error

Bruce Sithole -

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=8.0.0.0, 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!