locked
Error message when you try to open a custom view from link in Microsoft Dynamics CRM 4.0: "savedquery With Id = C0AFA04A-CDD0-DF11-80D9-0003FF187B3B Does Not Exist" RRS feed

  • Question

  • Hi

    Today I tried to open a custom view from a link but i got this error:

    savedquery With Id = C0AFA04A-CDD0-DF11-80D9-0003FF187B3B Does Not Exist

    The link is generated by this action: From a custom view, at the top bar click "More Actions", then click "Send shortcut" and then click on "Of Current View". It will open a compose email window with te mentioned link at the body, something like this: <http://syndeo-interno/MicrosoftCRM/_root/homepage.aspx?etc=10000&viewid={C0AFA04A-CDD0-DF11-80D9-0003FF187B3B}>

    If I repeat those steps with a system view I have no problem and I'm able to open the link.

    So I tried to fix it by installing Rollup 13 after I found the kb article 955981 (http://support.microsoft.com/kb/955981) which looks very similar but didn't work.

    Does anybody knows if this error is a know error or if this is an error that is happening only in my server?

    Can you try at your CRM and tell me what are your results?

    Thanks in advanced.

    Tuesday, October 5, 2010 10:40 PM

Answers

  • I'm unfamiliar if it's a known problem or a reported issue.  Obviously, it is a bug.  When a "Saved View" is selected from the main CRM window, it should establish a view link following a format which is correct for Saved Views, and not Custom Views.  I was able to reproduce this bug in my environment.  I'll drop a notice to Microsoft about the issue.

    Excellent find!


    Dave Berry - MVP Dynamics CRM - http:\\crmentropy.blogspot.com
    Wednesday, October 6, 2010 9:57 PM
    Moderator

All replies

  • some details about my error.

    Microsoft CRM Error Report:
    Error Description:
    savedquery With Id = C0AFA04A-CDD0-DF11-80D9-0003FF187B3B Does Not Exist

    Error Details:
    savedquery With Id = C0AFA04A-CDD0-DF11-80D9-0003FF187B3B Does Not Exist

    Full Stack:
    [CrmObjectNotFoundException: savedquery With Id = C0AFA04A-CDD0-DF11-80D9-0003FF187B3B 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.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.AppGrid.get_View()
       at Microsoft.Crm.Application.Controls.AppGrid.set_ViewId(String value)
       at Microsoft.Crm.Web.EntityHomePage.ConfigurePage()
       at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       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.ProcessRequest(HttpContext context)
       at ASP.philan__root_homepage_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

     

    Other Message:

    Error Number:
    0x80040217

    Source File:
    Not available

    Line Number:
    Not available
     
     
    Date: 10-05-2010

    Time: 16:01:47

    Server: syndeo-interno
     
     
    Request URL:
    http://syndeo-interno/MicrosoftCRM/_root/homepage.aspx?etc=10000&viewid={C0AFA04A-CDD0-DF11-80D9-0003FF187B3B}

    Tuesday, October 5, 2010 11:35 PM
  • I suggest go to database and run query again and see if this view actually exists in the system?

    select * from savedquery where savedqueryId = 'C0AFA04A-CDD0-DF11-80D9-0003FF187B3B'

     

    it seems that this particular view is delete or marked for deletion in the database..

     


    MayankP
    My Blog
    Follow Me on Twitter
    Wednesday, October 6, 2010 3:54 PM
  • Hi MayankP,

    It's seems to be more than a specific record. I'm very sure about this because:

    1. I tried with more than one custom view, even worst I tried with all the contact's custom views and I'm getting the same error message.
    2. It's happening at my company's installation and my client's installation.

    BTW I ran the query you told me and there are no results (0 rows).  I did it for the GUID I posted and one more.

    I'm very sure no one is marked for deletion,  at least we didn't marked for deletion or deleted, the saved views are accessible from the Advanced Find window. In fact if you go to Saved Views and you right click one of the records that shows, click Copy shortcut and then you go to the URL you will see the view results. This is an example of the new link (the one that works):
    http://syndeo-interno/MicrosoftCRM/advancedfind/advfind.aspx?etn=new_tareadeproyecto&QueryId=%7bC0AFA04A-CDD0-DF11-80D9-0003FF187B3B%7d&ViewType=4230&AutoRun=True
    Exactly the same GUID that I'm getting the error.

    Just one question, did you try at your CRM installation? remember it only occurs with custom views.

    Thanks in advanced.

    Wednesday, October 6, 2010 9:07 PM
  • Advanced Find views and Custom Views are different.  The former is located in the "UserQuery" table, and the later is in the "SavedQuery" table.  You must use the link format you posted using "copy shortcut" from the Saved Views window to pass Advanced Find views around.  Your original post contains the URL format which works only for Custom Views.

    (Custom Views are defined in the Customization area of CRM, through an entity's "Views and Forms" area)


    Dave Berry - MVP Dynamics CRM - http:\\crmentropy.blogspot.com
    • Edited by DavidBerryMVP, Moderator Wednesday, October 6, 2010 9:19 PM added clarification about where to find Custom Views
    Wednesday, October 6, 2010 9:15 PM
    Moderator
  • Hi David

    I'm totally agree with you, I've been talking about saved views all the time
    Based in what you say, seems like the error is that CRM returns a link formed to work with Custom Views instead Saved Views when you go through the steps I mentioned (copy shortcut). Any idea how to fix it? It is a known problem or a reported issue?

    Thanks.

    Wednesday, October 6, 2010 9:46 PM
  • I'm unfamiliar if it's a known problem or a reported issue.  Obviously, it is a bug.  When a "Saved View" is selected from the main CRM window, it should establish a view link following a format which is correct for Saved Views, and not Custom Views.  I was able to reproduce this bug in my environment.  I'll drop a notice to Microsoft about the issue.

    Excellent find!


    Dave Berry - MVP Dynamics CRM - http:\\crmentropy.blogspot.com
    Wednesday, October 6, 2010 9:57 PM
    Moderator
  • Posted bug report to Connect.
    Dave Berry - MVP Dynamics CRM - http:\\crmentropy.blogspot.com
    Wednesday, October 6, 2010 10:06 PM
    Moderator
  • Hi, does anyone know if this was ever fixed?  Same issue - 100% reproducible.

    Thanks!

    Tuesday, July 9, 2013 10:31 PM
  • It's certainly fixed in CRM 2011; but I can't remember if they back-ported the fix to CRM 4 via an Update Rollup.

    Dave Berry - MVP Dynamics CRM - http:\\crmentropy.blogspot.com Please follow the forum guidelines when inquiring of the dedicated CRM community for assistance.

    Friday, July 12, 2013 7:09 PM
    Moderator
  • Hi

    Please check if any view(of the Entity on whose lookup the error occurs) with the given Id exists in the organisation or not?

    Thanks

    Shubham

    Tuesday, September 20, 2016 6:33 AM
  • Hi

    This error occurs when any view with the given ID in error message is not present in the organisation. You can query on SQL or go to the organisation if you know the entity to which it refers to.

    Thanks

    Shubham Saxena

    Tuesday, September 20, 2016 6:36 AM