web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Query Builder Error wh...
Microsoft Dynamics CRM (Archived)

Query Builder Error while exporting and publishing the customization

(0) ShareShare
ReportReport
Posted on by Balaji Karpurapu 193

When trying to export a solution I created and publishing the imported solution, I get a Query Builder Error - The specified record type does not exist in Microsoft Dynamics CRM.  Even if click on Publish All Customizations, same error message is coming.  Looking at the log file, I see The entity with ObjectTypeCode = 10007 was not found in the MetadataCache.Detail.   It would very helpful and grateful, if any valuable suggestion to it get resolve.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Query Builder Error while exporting and publishing the customization

    Have you found any solution to this?

  • Balaji Karpurapu Profile Picture
    Balaji Karpurapu 193 on at
    RE: Query Builder Error while exporting and publishing the customization

    As part of system hygiene we deleted some entities and came to know that the query builder error is coming because of the entity deletion. I guess even we export the solution with required components still the issue will reproduce. Since, again system will put different ObjectTypeCode.

  • anilambadan Profile Picture
    anilambadan 1,160 on at
    RE: Query Builder Error while exporting and publishing the customization

    Have you deleted any entities? Can you try to create a new solution with all necessary components and try to export the solution again?

  • Balaji Karpurapu Profile Picture
    Balaji Karpurapu 193 on at
    RE: Query Builder Error while exporting and publishing the customization

    Yes Anil, I tried with provided link but no luck. Getting same error.

  • anilambadan Profile Picture
    anilambadan 1,160 on at
    RE: Query Builder Error while exporting and publishing the customization

    yes, you are right system is automatically generating the objecttypecode.  Can you try the following link to see whether the entity is there or not.

    https://<organization name>/main.aspx?etc=10007&pagetype=entityrecord

  • Balaji Karpurapu Profile Picture
    Balaji Karpurapu 193 on at
    RE: Query Builder Error while exporting and publishing the customization

    Thanks for your reply. How can we create the entity with Same ObjectTypeCode(10007). We are using CRM online version and as per my understanding when creating entity it will automatically generate ObjectTypeCode for that entity. Please correct me if wrong

  • Suggested answer
    anilambadan Profile Picture
    anilambadan 1,160 on at
    RE: Query Builder Error while exporting and publishing the customization

    Hi

    ObjecttypeCode may be different on different environments. have you created the  entity (with objecttypecode=10007) manually at destination? Please try to findout the entityname by using the following query

    Select * from entityView where ObjectTypeCode=10007

    try to run the query on both environments (source & destination) and see whether the entities are same.

    or try  the following url in your browser

    https://<organization name>/main.aspx?etc=10007&pagetype=entityrecord

    thanks

    Anil

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#3
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans