locked
Unable to delete a Note (Account has System Administrator role): "the requested record was not found or you don't have sufficient permission to view it". RRS feed

  • Question

  • I have an issue with Microsoft Dynamics CRM 4.0 (4.0.7333.3822).

     

    I cannot delete any Note that has been created previously. I can create and edit notes. My account has System Administrator role. When I’m trying to delete a note the following error message appears in UI:

    ‘the requested record was not found or you don't have sufficient permission to view it’.

    In my current configuration I have row id ‘409f879d-379d-e311-9256-eeef5894872b’ in DB Table ‘[dbo].[AnnotationBase]’ which I need to remove.

     

    Call Stack is given below. Please help to resolve this issue.

     

    Log files error message

     

    [2014-02-24 11:48:45.9] Process: w3wp |Organization:4e83a251-25a1-4c52-ab18-278ebd44cbea |Thread:    3 |Category: Exception |User: 5c5bae28-7c6e-40e5-a023-c6282c15b673 |Level: Error | CrmException..ctor

    at CrmException..ctor(String message, Int32 errorCode)

    at CrmObjectNotFoundException..ctor(BusinessEntityMoniker moniker)

    at BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32[] deletionCodes, Int32 languageCode)

    at BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)

    at ImageRetrievalStep.RetrieveEntity(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)

    at ImageRetrievalStep.RetrieveEntityWithColumns(BusinessEntityMoniker businessEntityMoniker, List`1 columns, ContextEntityKey entityRequest, PipelineExecutionContext context)

    at ImageRetrievalStep.Execute(PipelineExecutionContext context)

    at Pipeline.Execute(PipelineExecutionContext context)

    at MessageProcessor.Execute(PipelineExecutionContext context)

    at InternalMessageDispatcher.Execute(PipelineExecutionContext context)

    at ExternalMessageDispatcher.Execute(String messageName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, PropertyBag fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)

    at RequestBase.Process(Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)

    at RequestBase.Process(CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)

    at CrmServiceInternal.Execute(RequestBase request, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)

    at InProcessCrmService.Execute(Object request)

    at PlatformCommand.ExecuteInternal()

    at EntityProxy.Delete()

    at DeleteDialogPage.ConfigureForm()

    at AppUIPage.OnPreRender(EventArgs e)

    at Control.PreRenderRecursiveInternal()

    at Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    at Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    at Page.ProcessRequest()

    at Page.ProcessRequest(HttpContext context)

    at xxxxxxxxx__grid_cmds_dlg_delete_aspx.ProcessRequest(HttpContext context)

    at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    at ApplicationStepManager.ResumeSteps(Exception error)

    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)

    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)

    at HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)

    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

    >Crm Exception: Message: annotation With Id = 409f879d-379d-e311-9256-eeef5894872b Does Not Exist, ErrorCode: -2147220969

    [2014-02-24 11:48:45.9] Process: w3wp |Organization:4e83a251-25a1-4c52-ab18-278ebd44cbea |Thread:    3 |Category: Platform |User: 5c5bae28-7c6e-40e5-a023-c6282c15b673 |Level: Error | MessageProcessor.Execute

    >MessageProcessor fail to process message 'Delete' for 'annotation'.

    [2014-02-24 11:48:46.0] Process: w3wp |Organization:4e83a251-25a1-4c52-ab18-278ebd44cbea |Thread:    3 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError

    >MSCRM Error Report:

    --------------------------------------------------------------------------------------------------------

    Error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

     

    Error Number: 0x80040217

     

    Error Message: annotation With Id = 409f879d-379d-e311-9256-eeef5894872b Does Not Exist

     

    Error Details: annotation With Id = 409f879d-379d-e311-9256-eeef5894872b Does Not Exist

     

    Source File: Not available

     

    Line Number: Not available

     

    Request URL: http://xxxxxxxxx:5555/xxxxxxxxxDev/_grid/cmds/dlg_delete.aspx?iObjType=5&iTotal=1&iIndex=0&sSubTypes=&sSrcQueueId=&sParentId=&sCalendarId=&iId={409F879D-379D-E311-9256-EEEF5894872B}

     

    Stack Trace Info: [CrmObjectNotFoundException: annotation With Id = 409f879d-379d-e311-9256-eeef5894872b Does Not Exist]

       at Microsoft.Crm.Application.Utility.Util.RaiseXMLError(Exception exception)

       at Microsoft.Crm.Dialogs.DeleteDialogPage.ConfigureForm()

       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.zmdev__grid_cmds_dlg_delete_aspx.ProcessRequest(HttpContext context)

       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

     

    Tuesday, February 25, 2014 9:24 AM

All replies

  • Is the async service running without any errors?

    Have there been any recent changes such as rollups installed?  Do you have the most recent rollup installed?

    Are you able to delete any older notes or attachments or is this only affecting recent ones?

    You may also want to look at the size of the AsyncOperationBase table and bulk deletion to see if it is too large.  KB 968520.


    Jason Peterson

    Tuesday, February 25, 2014 1:29 PM
  • In CrmAsyncService log files there are some errors.But they are not related with delete action, e.g. the last one was created at 3:08 PM in CrmAsyncService log file, but I’ve tried to delete a Note since 4 PM and got only the error in w3wp log files.

    As I said before our version of CRM is 4.0.7333.3822, imho, this is the last one.

    Old and new Notes cannot be deleted.

    KB 968520 is about performance issue, but in our case we don’t have any problem with resources or responding time. The result is 3774130 after running this script:

    „Select Count(AsyncOperationId)from AsyncOperationBase WITH (NOLOCK)

    where OperationType in (1, 9, 12, 25, 27, 10)

    AND StateCode = 3 AND StatusCode IN (30,32)”

    Any suggestions?

    Thursday, February 27, 2014 2:47 PM