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) / Errors is happening mu...
Microsoft Dynamics CRM (Archived)

Errors is happening multiple times in CRM 2011

(0) ShareShare
ReportReport
Posted on by Community Member

Current Environment of MS CRM 2011
-----------------------------------------------------------------
Product Version : 5.0.9900.1060
OS :: Windows Server 2008 R2 Enterprise 64-bit (6.1, Build 7601)
Processor:: Intel(R) Xeon(R) CPU E5606 @ 2.13GHz (6 processor)
Installed Memory (RAM) :: 46.0 GB
Database Size :: near to 90.0 GB
Current Users :: 250+
CRM Updated Rollup :: 13
-----------------------------------------------------------------

Problem:
We are getting several times an error [Unexpected Error] [SQL Server timeout expired].
We have tried basic things::
1. Recycle the AppPool in IIS
2. restart IIS
3. restart the async service
------------------------------------------------------------------
While checking on event log, we are getting an error:
1. MSCRMWebService
Event ID : 18176
2. MSCRMPlatform
Event ID : 24066
3. MSCRMSandboxClient
Event ID : 20230

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    necsa Profile Picture
    necsa 3,455 on at

    Hi Sushil,

    Please check following link, i hope it will help you.

    technet.microsoft.com/.../ms190181%28v=sql.105%29.aspx

    www.codeproject.com/.../Timeout-expired-SQL-Execution-error

    thanks

    Happy CRM

  • necsa Profile Picture
    necsa 3,455 on at

    An another solution links

    www.codeproject.com/.../Timeout-expired-The-timeout-period-elapsed-prior-t

    Happy CRM

  • Suggested answer
    KZee Profile Picture
    KZee on at

    Hi,

    IIS Reset / Server restart might not help for SQL timeout. SQL timeout means that it is taking longer than expected to run a query.

    Have you checked OleDbTimeout registry key?

    If you have not defined it then your system might be running with default 30 seconds timeout but you can increase it.

    Following link explains how to check / add this.

    support.microsoft.com/.../2637855

    CRM might also be logging another event id: 17972 showing how much time it has taken to execute the timed out SQL and it will also log the SQL statement.

    The SQL you find in the event logs will help you to fix the problem as you might simply be missing indexes.

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