locked
CRM 2011 RU2 (OnPremise) - Audit History and 'An unexpected error occurred.' RRS feed

  • Question

  • Hello,

    We have enabled auditing on a custom entity and on some update records (not all update records, nor nor any create records) we get 'An unexpected error occurred' when reviewing the Audit History item in the Settings screen, and when we open the Audit History link of the record.

    Below is the TraceDebug where the exception occurs (I think) :-

    >Web Service Plug-in failed in SdkMessageProcessingStepId: {98151A8E-8ED7-4B27-926D-16073AF4C3D3}; EntityName: audit; Stage: 30; MessageName: RetrieveRecordChangeHistory; AssemblyName: Microsoft.Crm.Extensibility.InternalOperationPlugin, Microsoft.Crm.ObjectModel, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35; ClassName: Microsoft.Crm.Extensibility.InternalOperationPlugin; Exception: Unhandled Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType 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(IServiceProvider serviceProvider)
       at Microsoft.Crm.Extensibility.V5PluginProxyStep.ExecuteInternal(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)
    Inner Exception: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
    Parameter name: index
       at System.Collections.Generic.List`1.get_Item(Int32 index)
       at Microsoft.Crm.ObjectModel.AuditService.GetRelationshipDetail(List`1 changeDataList, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.AuditService.CreateAuditDetailsForSpecialRecords(String changeData, Int32 action, BusinessEntity auditEntity, BusinessEntityCollection beCollection, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.AuditService.RetrieveAuditDetailsInternal(BusinessEntity auditEntity, BusinessEntity baseRecord, BusinessEntityCollection beCollection, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.AuditService.CreateAuditDetailCollection(BusinessEntityCollection beCollection, Int32 recordsToIgnore, BusinessEntity baseRecord, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.AuditService.RetrieveRecordChangeHistory(BusinessEntityMoniker moniker, PagingInfo pageInfo, ExecutionContext context)
    .

     

    Below is a client side Debug Dump (sanitized) of the exception.  Anyone got any ideas:-

     

    Microsoft® CRM - Debug Information
    Server Information:
    DescriptionValue:
    Server OS Version:6.1.7601.65536
    Server URT Version:4.0.30319.235
    Server Name:PRODAPP01
    Application Install Path:C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
    Configuration Database Information
    Data Source:MSCRM
    Initial Catalog:MSCRM_CONFIG
    Connection Timeout:60
    Integrated Security:SSPI
    Database Information
    Provider:SQLOLEDB
    Data Source:MSCRM
    Initial Catalog:PROD_MSCRM
    Integrated Security:SSPI
    Web.Config Settings
    Show Developer Level Errors:On
    App Mode Enabled:False
    Help Catalog Name:Microsoft CRM Help
    Component Version Numbers
    Application Components:5.0.9688.1157
    User Interface Components:5.0.9688.1157
    Platform Components:5.0.9688.1157
    Resource (Strings) Components:5.0.9688.1157


    Client Information:
    DescriptionValue:
    Browser Version:IE 9.0
    User Agent Info:Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0)
    CPU Class:x64
    Cookies Enabled:true
    Platform Info:Win64
    Screen Resolution:1024x768
    Screen Bit Depth:32-bit


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

    Microsoft CRM Error Report:
    Error Description:
    An unexpected error occurred.

    Error Details:
    An unexpected error occurred.

    Full Stack:
    [CrmException: An unexpected error occurred.]
       at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()
       at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveRecordChangeHistoryCommand.Execute()
       at Microsoft.Crm.ApplicationQuery.RetrieveAuditByObjectCommand.RetrieveData()
       at Microsoft.Crm.ApplicationQuery.ExecuteQuery()
       at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData()
       at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData()
       at Microsoft.Crm.Application.Controls.GridUIProvider.PrepareGridData()
       at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)
       at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output)
       at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output)
       at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)
       at Microsoft.Crm.Application.Components.PageHandlers.AreaPageHandler.HandlerRender(HtmlTextWriter output)
       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 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


    Other Message:

    Error Number:
    0x80040216

    Source File:
    Not available

    Line Number:
    Not available

    Error Trace:


    Date: 08-01-2011

    Time: 13:08:58

    Server: mscrm


    Request URL:
    http://mscrm:5555/PROD/userdefined/areas.aspx?formid=ec89c3f5-43fc-44d6-9637-1d02fb614295&navItemName=Audit%20History&oId=%7bDD77AE68-D7BB-E011-9F16-00505681000B%7d&oType=10037&pagemode=iframe&security=852023&tabSet=areaAudit

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

    Microsoft


    An unexpected error occurred.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: Microsoft.Crm.CrmException: An unexpected error occurred.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:


    [CrmException: An unexpected error occurred.]
       Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal() +1629
       Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveRecordChangeHistoryCommand.Execute() +94
       Microsoft.Crm.RetrieveAuditByObjectCommand.RetrieveData() +470
       Microsoft.Crm.ApplicationQuery.ExecuteQuery() +25
       Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData() +749
       Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData() +16
       Microsoft.Crm.Application.Controls.GridUIProvider.PrepareGridData() +940
       Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output) +1033
       Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output) +587
       Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output) +195
       Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output) +398
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +246
       System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +48
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +246
       System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer) +61
       System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +48
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +246
       System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer) +61
       System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +48
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +246
       System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +48
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +246
       System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +48
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +246
       System.Web.UI.HtmlControls.HtmlTableRow.RenderChildren(HtmlTextWriter writer) +61
       System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +48
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +246
       System.Web.UI.HtmlControls.HtmlTable.RenderChildren(HtmlTextWriter writer) +61
       System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +48
       System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +246
       System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +48
       Microsoft.Crm.Application.Components.PageHandlers.AreaPageHandler.HandlerRender(HtmlTextWriter output) +265
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5290

     

     

     


    • Edited by glenn_goodwin8 Monday, August 1, 2011 4:09 AM Added DebugTrace
    Monday, August 1, 2011 3:16 AM

Answers

All replies

  • it sounds like it is an intermittent issue and those are inheritantly challenging to troubleshoot.  Nothing jumps out at me from the above error, but I am not an expert log parser ;)  You could try installing the latest update rollup and also try the action on more than one machine to rule out the possibility of an environmental issue.

    Regards, Donna

    Thursday, August 4, 2011 1:06 AM
  • Hi Glenn,

    any news on that issue on your side? Experiencing a similar issue here on my system, also on RU2

     

     

    Monday, August 15, 2011 3:59 PM
  • Another voice in the chorus - we, too, are experiencing this issue.  It is consistently a problem with some records - but not all.  I've only just begun the process of researching this and this thread is the first that I've found.  Please check in if you have a solution and I will do likewise.
    Monday, August 15, 2011 6:22 PM
  • It appears that this is a known issue that is being addressed in a future Update Rollup...

    http://social.microsoft.com/Forums/en/crm/thread/2db3a9ee-ad23-4886-afcd-fa1b18802205

    Monday, August 15, 2011 6:50 PM
  • We have the same problem and the following is more details of the issue:

     

    Steps to replicate the issue:

    1. Date Format: Austratlia - dd/mm/yyyy

    2. Make enable for auditing for DateTime field.

    3. Change the field value and save.

    4. Check the audit history

    5. You may see the System Error.

     

    Please let me know if anyone find any solution.


    • Edited by Jaewon Kim Wednesday, September 21, 2011 1:25 AM
    Wednesday, September 21, 2011 1:11 AM
  • CRM 2011 Rollup 4 appears to have the fix (although haven't tested it yet) http://support.microsoft.com/kb/2556167

     

    When you click Audit History in the Microsoft Dynamics CRM 2011 Web client, you receive the following error message:

    An unexpected error occurred.

    This problem occurs when the system date is formatted in non-United States English.

     

    Thanks
    Glenn

    Saturday, September 24, 2011 1:01 AM
  • We have update Rollup 6 installed, still facing the issue. 

    Fom forums, I found that this is related to Date time issue.

    The date time format for the records are as follows:

    Not Working record - 2012-07-16 13:55:54.000
    Working record - 2012-07-13 04:37:47.000

    We are sharing the record with previous owner while it is being assigned to new owner via plugin.

    If someone found a fix for this, please let us know.

    Tuesday, July 17, 2012 1:33 PM
  • We are also experiencing the issue. However the issue is persisting after moving to ROLL-UP 14 from ROLL-UP 10. Recently we moved to Roll-Up 14. Everything was fine for first 10-15 days and then above issue is encountering. 

    Looking at earlier answers it seems the issue was persisted in Pre-Roll-Up 14 releases and it got fixed in Roll-Up-4, but i don't understand how it is appearing in Roll-Up 14. We did check DateTime settings, but no luck as it is already US timezone.

    Any help will truly appreciated. 

    Wednesday, May 7, 2014 10:09 AM