locked
Saved query on equipment problem in serviceappointment RRS feed

  • Question

  •  

    Hi All,

     

    I made a query to retrieve all equipment from 1 site and saved it. When I am maintaining my equipments I can use this savequery without any problem. How ever when I want to use this saved query in the serviceappointment screen (After first selecting type). Selecting the saved query leads to the error below...Any one any ideas?

     

    regards

     

    Hans vd Linden

     

    Error Description:

    savedquery With Id = 703fe558-1ef0-dc11-acab-56414d8990f4 Does Not Exist


    Error Details:

    savedquery With Id = 703fe558-1ef0-dc11-acab-56414d8990f4 Does Not Exist


    Full Stack:

    [CrmObjectNotFoundException: savedquery With Id = 703fe558-1ef0-dc11-acab-56414d8990f4 Does Not Exist]
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrievePublishableSingle(BusinessEntityMoniker moniker, EntityExpression entityExpression, Boolean includeUnpublished, ExecutionContext context)
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32[] deletionCodes, Int32 languageCode)
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.SavedQueryService.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)
    
    [TargetInvocationException: Exception has been thrown by the target of an invocation.]
       at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
       at Microsoft.Crm.Extensibility.InternalOperationPlugin.Execute(IPluginExecutionContext context)
       at Microsoft.Crm.Extensibility.PluginStep.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.Pipeline.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.MessageProcessor.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.InternalMessageDispatcher.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.ExternalMessageDispatcher.Execute(String messageName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, PropertyBag fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.RequestBase.Process(Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.RequestBase.Process(CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.CrmServiceInternal.Execute(RequestBase request, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.InProcessCrmService.Execute(Object request)
       at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.ExecuteInternal()
       at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveCommand.Execute()
       at Microsoft.Crm.Application.Platform.DataSource.Retrieve(String entityName, Guid entityId, ColumnSetBase columnSet)
       at Microsoft.Crm.Caching.QueryLoader.LoadCacheData(QueryCacheKey key, IOrganizationContext context)
       at Microsoft.Crm.Caching.CrmMultiOrgCache`2.CreateEntry(TKey key, IOrganizationContext context)
       at Microsoft.Crm.Caching.CrmSharedMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)
       at Microsoft.Crm.Caching.ViewLoader.GetView(Guid viewId, ViewType viewType)
       at Microsoft.Crm.Application.Controls.AppointmentBookGridDataProvider.get_DataSource()
       at Microsoft.Crm.Application.Pages.SM.GanttControlFrame.DataIsReady(Object sender, GridUIProviderEventArgs e)
       at Microsoft.Crm.Application.Components.UI.DataGrid.RaiseOnDataBoundEvent(GridUIProviderEventArgs e)
       at Microsoft.Crm.Application.Components.UI.DataGrid.Reraise(Object sender, GridUIProviderEventArgs e)
       at Microsoft.Crm.Application.Controls.AppGridUIProvider.RaiseOnDataReadyEvent(GridUIProviderEventArgs e)
       at Microsoft.Crm.Application.Controls.AppGridUIProvider.Render(HtmlTextWriter output)
       at Microsoft.Crm.Application.Components.UI.DataGrid.RenderData(HtmlTextWriter output)
       at Microsoft.Crm.Application.Components.UI.DataGrid.RenderInnerHtml(HtmlTextWriter output)
       at Microsoft.Crm.Application.Components.UI.DataGrid.Render(HtmlTextWriter output)
       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
       at Microsoft.Crm.Application.Components.UI.CrmUIControlBase.RenderControl(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.Page.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
       at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    
    [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.abelo_sm_ganttcontrolframe_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    
    

     

    Thursday, March 13, 2008 8:56 AM

Answers

  •  

    Hi.

     

    This looks like a bug. 

     

    MS is looking for the Saved Query in the wrong place (SavedQueryBase) where they should be looking at the

    UserQueryBase view / table.

     

    I tried to share the record with other users to change the query status somehow but it didn't work.

    If this is a critical issue I suggest opening a service request with Microsoft.

     

    You may set this query as a public view to workaround this issue for the time being.

     

    Cheers,

    Adi

     

    Thursday, March 13, 2008 3:06 PM