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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Getting CrmException: SQL timeout expired.

(0) ShareShare
ReportReport
Posted on by

We have CRM 2015 on-premise IFD set up.  Today morning we added a new user to CRM.  This user logs in and views the Account list.  Then the user clicks on one of the account to see the detail view of the account, gets SQL timeout expired error.  Only this user gets this error no matter which account is selected.  None of our 40 users are having this issue.  Have searched and searched but not getting anywhere.  There were couple of suggestions to increase the default timeout value via registry, but doesn't make sense since none of the other users are having this problem.

Here's what's in the event log...

RequestUrl: https://[our crm site]/main.aspx?etc=1&extraqs=%3f_gridType%3d1%26etc%3d1%26id%3d%257b277E0EA8-8B0C-DF11-9F54-00188B4DED7D%257d%26rskey%3d%257b00000000-0000-0000-00AA-000010001002%257d&pagemode=iframe&pagetype=entityrecord&rskey=%7b00000000-0000-0000-00AA-000010001002%7d, StackTrace: [CrmException: SQL timeout expired.]

at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()

at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveCommand.Execute()

at Microsoft.Crm.Application.Platform.DataSource.Retrieve(String entityName, Guid entityId, String[] columns, Boolean retrieveLatest, Boolean useSystemUserContext, Guid auditingTransactionId, IOrganizationContext context)

at Microsoft.Crm.Application.Platform.EntityProxy.Retrieve(String[] columns, Guid auditingTransactionId, Boolean addRequiredColumns)

at Microsoft.Crm.Application.Platform.EntityProxy.Retrieve(String[] columns, Boolean addRequiredColumns)

at Microsoft.Crm.Application.InlineEdit.ReadFormDataBuilder.LazyLoadEntity()

at System.Lazy`1.CreateValue()

at System.Lazy`1.LazyInitValue()

at Microsoft.Crm.Application.Pages.Common.ReadFormPage.ConfigureHeader()

at Microsoft.Crm.Application.Controls.PageManager.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 System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)

[HttpException: Error executing child request for /_forms/read/page.aspx.]

at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)

at System.Web.HttpServerUtility.Execute(String path, TextWriter writer, Boolean preserveForm)

at System.Web.HttpServerUtility.Transfer(String path)

at System.Web.UI.Control.PreRenderRecursiveInternal()

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)

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    MilindP Profile Picture
    1,019 on at

    Check the event log which will give you a query it is trying to run when user is selecting the record or while seeing details. Then Run the query in SQL Management Studio to analyze it.. see if there is need of additional index. 

  • Community Member Profile Picture
    on at

    Thanks MilindP.  I did find the query, not in event log, after turning trace on for CRM.  The almost 300 line query did take more than 2 minutes to run in management studio.  This query is a system (built in) query and not written by us.  What baffles me is none of the other users are getting that error when exactly executing same action.  

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans