web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Audit History shows ...
Customer experience | Sales, Customer Insights,...
Unanswered

Audit History shows 'SQL Server Error'

(0) ShareShare
ReportReport
Posted on by temp2escapeX

Hi all,

I received 'SQL Server Error' when trying to view Audit History from cases.

Screenshot-2020_2D00_02_2D00_12-at-1.52.48-PM.png

I check Event Viewer and it shows below query is taking 120 sec to complete. But if I copy and run from SQL server management studio, I get the result immediately.

Screenshot-2020_2D00_02_2D00_12-at-2.04.02-PM.png

Screenshot-2020_2D00_02_2D00_12-at-2.04.10-PM.png

Screenshot-2020_2D00_02_2D00_12-at-1.53.30-PM.png

Can anybody advise why the SQL SERVER ERROR occurred?

  • LeoAlt Profile Picture
    LeoAlt on at
    RE: Audit History shows 'SQL Server Error'

    Hi partner,

    The message you showed to us  is a warning, what's the error message above this time warning?

    pastedimage1581491039612v1.png

    Regards,

    Leo

  • temp2escapeX Profile Picture
    temp2escapeX on at
    RE: Audit History shows 'SQL Server Error'

    Hi Leo,

    As below.

    Screenshot-2020_2D00_02_2D00_12-at-3.07.25-PM.png

    RequestUrl: URL/.../areas.aspx, 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.RenderInnerHtml(HtmlTextWriter output)

       at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.Render(HtmlTextWriter output)

       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       at Microsoft.Crm.Application.Components.UI.CrmUIControlBase.RenderControl(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.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)

       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)

       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)

       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)

       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)

       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)

       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       at Microsoft.Crm.Application.Components.UI.CrmUIControlBase.RenderControl(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.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)

       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)

       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)

       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)

       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)

       at System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer)

       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       at Microsoft.Crm.Application.Components.UI.CrmUIControlBase.RenderControl(HtmlTextWriter writer)

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

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

       at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)

       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)

  • LeoAlt Profile Picture
    LeoAlt on at
    RE: Audit History shows 'SQL Server Error'

    Hi partner,

    You could try to increase the timeout of SQL in your server.

    Please refer to the following links.

    msdynamicscrmblog.wordpress.com/.../

    social.microsoft.com/.../sqltimeout-when-access-the-contacts-audit-history

    mscrmuk.blogspot.com/.../sql-timeouts-in-crm-generic-sql-error.html

    www.crmug.com/.../viewthread

    If this issue still existed, please raise a ticket to Microsoft Support Team for more professional help.

    Best Regards,

    Leo

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans