Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 60

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 16,329 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

  • temp2escapeX Profile Picture
    temp2escapeX 60 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 16,329 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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans