Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Query Builder error
Microsoft Dynamics CRM (Archived)

Query Builder error

(0) ShareShare
ReportReport
Posted on by sclarebout 180

Guys,

I'm facing a weird issue right now. I don't know what has happened with the organization, but users, even admin can't access the dashboards anymore. While I tried to setup auditing, I couldn't either due to the same error: "Query Builder Error. The specified record type does not exist in Microsoft Dynamics CRM". This error shows when I navigate to Dashboards and I try to edit the auditing settings:

2016_2D00_11_2D00_09-09_5F00_43_5F00_15_2D00_Microsoft-Dynamics-CRM.jpg

When I try to access the dashboards from within our solution, this is what I get on every single dashboard in the system:
2016_2D00_11_2D00_09-09_5F00_45_5F00_55_2D00_Sales_5F00_-Projects-_2D00_-Microsoft-Dynamics-CRM.jpg

Anyone have a suggestion? 
Could there be a problem with translations possibly? 

+ 

I can't access the system settings either...same error.

*This post is locked for comments

  • Suggested answer
    tw0sh3ds Profile Picture
    tw0sh3ds 5,600 on at
    RE: Query Builder error

    Hi,

    I suggest reporting a ticket to Microsoft Support, as this is online deployment and you cannot see the full logs here.

  • Pablo Abraham Profile Picture
    Pablo Abraham on at
    RE: Query Builder error

    I am having the same issue. When I try to enable French language in a OnPrem CRM instance I am getting the same error.

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: The specified object was not found.Detail:
    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
    <ErrorCode>-2147220969</ErrorCode>
    <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic">
    <KeyValuePairOfstringanyType>
    <d2p1:key>0</d2p1:key>
    <d2p1:value xmlns:d4p1="http://www.w3.org/2001/XMLSchema" i:type="d4p1:string">Unknown object type code: 1150</d2p1:value>
    </KeyValuePairOfstringanyType>
    </ErrorDetails>
    <Message>The specified object was not found.</Message>
    <Timestamp>2016-12-23T14:06:50.1404497Z</Timestamp>
    <InnerFault i:nil="true" />
    <TraceText i:nil="true" />
    </OrganizationServiceFault>

  • sclarebout Profile Picture
    sclarebout 180 on at
    RE: Query Builder error

    And now I dug deeper into the problem. I can see failed system jobs since 31/10/2016: 'Reprovisioning Job For 1033' and 1043 and 1036. These codes refer to the languages enabled for the organization. And I think that's causing the issues now?

    Log file

    Message: 
    The specified object was not found.

    Details: 

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: The specified object was not found.Detail: 
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
  <ErrorCode>-2147220969</ErrorCode>
  <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic">
    <KeyValuePairOfstringanyType>
      <d2p1:key>0</d2p1:key>
      <d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema" i:type="d4p1:string">Unknown object type code: 1150</d2p1:value>
    </KeyValuePairOfstringanyType>
  </ErrorDetails>
  <Message>The specified object was not found.</Message>
  <Timestamp>2016-10-31T07:32:53.7644063Z</Timestamp>
  <InnerFault>
    <ErrorCode>-2147220969</ErrorCode>
    <ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic" />
    <Message>The specified object was not found.</Message>
    <Timestamp>2016-10-31T07:32:53.7644063Z</Timestamp>
    <InnerFault i:nil="true" />
    <TraceText i:nil="true" />
  </InnerFault>
  <TraceText i:nil="true" />
</OrganizationServiceFault>
   at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext)
   at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType)
   at Microsoft.Crm.Extensibility.InprocessServiceProxy.ExecuteCore(OrganizationRequest request)
   at Microsoft.Crm.Asynchronous.ProvisionLanguagePackOperation.InternalExecute(AsyncEvent asyncEvent)
   at Microsoft.Crm.Asynchronous.AsyncEventHandlerCommand`1.Execute(IAsyncEvent asyncEvent)
   at Microsoft.Crm.Asynchronous.AsyncEventExecutionManager`2.ExecuteCommand(IAsyncEventHandlerFactory handlerFactory)
   at Microsoft.Crm.Asynchronous.AsyncEventExecutionManager`2.ExecuteHandler(IAsyncEventHandlerFactory handlerFactory)
   at Microsoft.Crm.Asynchronous.PoolHandler.ProcessAsyncEvent(IAsyncEventExecutionManager asyncEventExecutionManager)
  • sclarebout Profile Picture
    sclarebout 180 on at
    RE: Query Builder error

    Thanks for the URLs so far, forgot to mention this is an online environment.

    Now, I don't get the error when accessing Audit History, in fact, auditing is disabled for the organization and never turned on. I can't access the feature 'Global Audit Settings' (and all Dashboards).

    All other Audit related topics are accessible...

  • Kishor Kumar Profile Picture
    Kishor Kumar 3,702 on at
    RE: Query Builder error

    Hi,

    Check whether you have removed any filed which was audit enabled, it may be root cause for this error!

  • Rutul Chauhan Profile Picture
    Rutul Chauhan 2 on at
    RE: Query Builder error

    Please refer: dotnetfollower.com/.../dynamics-crm-query-builder-error

    Sometimes it happens, when a record is in the process of some transaction for a specific record being executed.

    Regards,

    Rutul

  • Nithya Gopinath Profile Picture
    Nithya Gopinath 17,076 on at
    RE: Query Builder error

    Hi sclarebout,

    Refer the following link which helps to fix the Query Builder Error.

    http://www.powerobjects.com/2013/12/02/query-builder-error-in-audit-history/

    Hope this helps.

    Thanks

     

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans