Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Query builder error on Custom entity.

Posted on by 65

Hi, 

We are facing Query builder error after deploying a custom entity. We face same issue in QA instance and could not find any Dynamics CRM errors in Event viewer. It got resolved after 1 day with out doing any changes in CRM or in server. Now we are facing same issue after Production deployment. This issue is not consistent. When I refresh the page again it is opening the form/Advanced find results. 

Need help on resolving this issue.

*This post is locked for comments

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: Query builder error on Custom entity.

    It might happen in the following scenario, though I don't know if that's the case..

    - You have deployed those views to another environment

    - The views are using some lookup references in the filter criteria

    - Those lookups were missing in the target environment

    - When you tried to open the query builder, you got that error

    But, then, you used a tool like data loader (or scribe.. or SSIS) to move required lookup references from the source to the target environment, and that fixed the views.

  • Padma Korada Profile Picture
    Padma Korada 65 on at
    RE: Query builder error on Custom entity.

    Yes. It got resolved after 1 day both in QA and Production instances. It might be issue with Cache. But we haven't faced this issue when deployed from DEV to TEST instance.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Query builder error on Custom entity.

    Will it be possible for you to reset IIS on production? You will have to be careful about that. This seems like a cache issue and resetting IIS might solve the issue.

  • Padma Korada Profile Picture
    Padma Korada 65 on at
    RE: Query builder error on Custom entity.

    Below is the  downloaded log file.

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: The entity with EntityId = 'c891be75-2386-41de-8069-069fabbcd4de' was not found in the MetadataCache.Detail:

    <OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance&quot; xmlns="schemas.microsoft.com/.../Contracts&quot;>

     <ErrorCode>-2147217150</ErrorCode>

     <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic&quot; />

     <Message>The entity with EntityId = 'c891be75-2386-41de-8069-069fabbcd4de' was not found in the MetadataCache.</Message>

     <Timestamp>2017-05-05T04:46:08.903583Z</Timestamp>

     <InnerFault i:nil="true" />

     <TraceText i:nil="true" />

    </OrganizationServiceFault>

  • ashlega Profile Picture
    ashlega 34,475 on at
    RE: Query builder error on Custom entity.

    Hi, do you have any screen shots/log files/error messages?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans