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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SQL Timeout on configu...
Microsoft Dynamics CRM (Archived)

SQL Timeout on configuration change

(0) ShareShare
ReportReport
Posted on by stuart 2,080

Hi

I have just started noticing sql timeouts when trying to make configuration changes to our Contact entity eg adding a new field or adding values to an optionset. This has only started happening since late last week and otherwise CRM appears to be functioning as per usual.

I have tried increasing the sql timeout by adding a registry key - see, for instance, http://support.microsoft.com/en-us/kb/2637855 - but this has yet to resolve the issue.

Any one any idea what to do next?

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at

    if none of this works:

    blogs.msdn.com/.../microsoft-dynamics-crm-timeout-settings.aspx

    it could be you may need to troubleshoot SQL server (check the indexes, hardware resources)

    check if the crm maintenance is working fine

    blogs.msdn.com/.../crm-2013-maintenance-jobs.aspx

    It could be also a plugin running a expensive query when registered as asynch. there is a setting in the MSCRM Config that will not allow a query to run for too long if inside of a synchronous plugin

  • stuart Profile Picture
    stuart 2,080 on at

    Hi - thanks for suggestions - digging a bit further it seems that there was a lock on a specific table caused by the Scribe software we have installed. Not sure why it was causing the lock though - wasn't even doing any processing.

    Anyway thanks again.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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