Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM ROLL-Up 14 - An unexpected error occurred on Audit History of Incidents RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Recently we moved to Roll-up 14 from Roll-up 10. Everything was fine for first 10-15 days and then we are encountering error of "SQL Timeout expired". Below is the stacktrace. Please help us to solve the issue.

    StackTrace: [CrmException: SQL timeout expired.]

       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.GetData(QueryBuilder queryBuilder)

       at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData()

       at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData()

       at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareGridData()

       at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareData()

       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.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.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.HtmlContainerControl.Render(HtmlTextWriter writer)

       at Microsoft.Crm.Application.Components.PageHandlers.AreaPageHandler.RenderAreaPageContent(HtmlTextWriter writer)

       at Microsoft.Crm.Application.Components.PageHandlers.AreaPageHandler.HandlerRender(HtmlTextWriter output)

       at Microsoft.Crm.Application.Pages.UserDefined.AreaPage.Render(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 

    Wednesday, May 7, 2014 10:22 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Does this error always occur when modifying incidents, or is it an occasional error ? And does it occur when updating any other audited entity ?

    If it's a one-off, or infrequent, error, one cause could be if SQL Server needs to expand either the data or the log file, which may take longer than the SQL timeout.

    The application event log on the CRM server should also contain more information about the SQL statement that failed

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, May 7, 2014 11:52 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi David,

    Thanks for the reply. This is an infrequent error, only observed in incident audit history. How may i check if it is occurring due to SQL server log file expand that is taking a long time?

    Please advice. Thank you!

    Thursday, May 8, 2014 10:17 AM