Dynamics Community Forum Thread Details

A quick find filter cannot have any child filters

While searching the contacts, suddenly in production we started getting the below error

Try this action again. If the problem continues, check the Microsoft Dynamics 365 Community for solutions or contact your organization's Microsoft Dynamics 365 Administrator. Finally, you can contact Microsoft Support. If you contact support, please provide the technical details.

Error Log shows the below error

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: A quick find filter cannot have any child filtersDetail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ActivityId>7535a531-f931-4de7-ab7e-908a362c9697</ActivityId>
<ErrorCode>-2147217118</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic">
<KeyValuePairOfstringanyType>
<d2p1:key>ApiExceptionSourceKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">Plugin/Microsoft.Crm.Common.ObjectModel.AccountService</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiOriginalExceptionKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">Microsoft.Crm.CrmException: A quick find filter cannot have any child filters ---> Microsoft.Crm.CrmException: A quick find filter cannot have any child filters
at Microsoft.Crm.Query.CrmSqlSelectCommandStrategy.QuickFindPredicateBuilder.CreateConditionBuilder(LogicalOperator logicalOperator, EntityMetadata entityMetadata, String tableAlias, DatabaseQueryTarget queryTarget)
at Microsoft.Crm.Query.CrmSqlSelectCommandStrategy.PredicateBuilder.BeginWritingFilter(LogicalOperator filterOperator, EntityMetadata entityMetadata, String tableAlias, DatabaseQueryTarget queryTarget)
at Microsoft.Crm.Query.SelectVisitor.Visit(FilterExpression criteria)
at Microsoft.Crm.Query.SelectVisitor.Visit(FilterExpression criteria)
at Microsoft.Crm.Query.SelectVisitor.Visit(EntityExpression entity)
at Microsoft.Crm.Query.SelectPlan.GenerateUnionInnerQuery()
at Microsoft.Crm.Query.SelectPlan.GetSQLStatement()
at Microsoft.Crm.Query.SelectPlan.<GetSql>b__3_0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)
at Microsoft.Crm.Query.QueryPlan.get_Command()
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, DatabaseQueryTarget queryTarget, PagingHelper pagingHelper, ExecutionContext context, Boolean needToSetRowVersion, Boolean isVersionNumberRequestedInRetrieve)
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.<>c__DisplayClass371_0.<DoRetrieveMultiple>b__0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, DatabaseQueryTarget queryTarget, ExecutionContext context)
--- End of inner exception stack trace ---
at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)
at Microsoft.Crm.Extensibility.PipelineInstrumentationHelper.Execute(Boolean instrumentationEnabled, String stopwatchName, ExecuteWithInstrumentation action, PipelineExecutionContext context)
at Microsoft.Crm.Extensibility.Pipeline.<>c__DisplayClass2_1.<Execute>b__0()</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiStepKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">16ccbb1b-ea3e-db11-86a7-000a3a5473e8</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiDepthKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">1</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiActivityIdKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">7535a531-f931-4de7-ab7e-908a362c9697</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiPluginSolutionNameKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">System</d2p1:value>
</KeyValuePairOfstringanyType>
<KeyValuePairOfstringanyType>
<d2p1:key>ApiStepSolutionNameKey</d2p1:key>
<d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">System</d2p1:value>
</KeyValuePairOfstringanyType>
</ErrorDetails>
<Message>A quick find filter cannot have any child filters</Message>
<Timestamp>2018-11-21T04:55:36.8901808Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>

Please advise

[quote user="bialix"]

13:34 CET: problem fixed in my organizations.

I'm able again to quick search account, users and contacts.

And the world is beautiful again.

In fact, CRM is working slower than anything I saw in my life, but it's nothing new.

[/quote]

Hi bialix, did you test some workaround mentioned in this post or MS Support Center?

Like:

1. Go to Settings > Customization > Customize the system.

2. Locate the Account entity and click on Views.

3. Look for the Quick search view for Accounts. It may appear as "Quick find view for active accounts". Double click to open it.

4. Click on "Edit filter criteria".

5. There's a filter to only search on active accounts. Delete the filter.

6. Save and close the view. Publish changes.

7. Refresh (Ctrl + F5) and try again.

Or it fixed by himself?

In our organizations we just can fix it settin same view and find colums in quick find view and find view for accounts and deleting filter to only search active acounts...

Quick Links

Leaderboard