CRM2011::System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support#

All replies

• 

  

  0

  Sign in to vote

  Is this Online?  I have noticed intermittent issues in Online recently that manefest themselves this way.

  ---

  Jamie Miley
  http://mileyja.blogspot.com
  Linked-In Profile
  Follow Me on Twitter!

  Tuesday, May 3, 2011 3:00 PM

  Moderator
• 

  

  0

  Sign in to vote

  Hi Jamie ,it is On premise version

  Regards

   

  ---

  VenkataP

  Tuesday, May 3, 2011 3:09 PM
• 

  

  0

  Sign in to vote

  Have you checked the usual culprits of the Async service being down and such?

  If this is truely intermittent I am wondering if it is resulting from heavy development, publishs, etc...

  Does your server hardware meet minimum requirements from the implementation guide?

  There could also be an issue dealing with your SQL Server being unavailable due to a network issue within your topology.  Can you confirm the CRM database is on a different machine than the CRM application server?

  ---

  Jamie Miley
  http://mileyja.blogspot.com
  Linked-In Profile
  Follow Me on Twitter!

  Tuesday, May 3, 2011 3:25 PM

  Moderator
• 

  

  0

  Sign in to vote

  Hi Jamie,

  Thanks for quick response. It is basically batch job which updates the crm by reading txt files or excel files.

  SQLServer and CRM server shares the one phsyical server. Yes Hardware meet the CRM 2011 hardware requirements. The job is running individually and it is not attached to CRM async service. Both CRM async process are running under networkservice. some it is working fine. Today i observe using trace .it shows time out expection. How to increase timeout for Orgservice in CRM2011?

  regards

  ---

  VenkataP

  Tuesday, May 3, 2011 4:23 PM
• 

  

  0

  Sign in to vote

  It would probably be the timeouts in the IIS website settings. 

  ---

  Jamie Miley
  http://mileyja.blogspot.com
  Linked-In Profile
  Follow Me on Twitter!

  • Marked as answer by Jamie MileyModerator Friday, August 31, 2012 5:38 PM

  Tuesday, May 3, 2011 4:30 PM

  Moderator
• 

  

  1

  Sign in to vote

  Hi Venkat,

  Im Pradeep... regarding your problem it seems you have to increase the timeout session under your CRM Server:

  here are the steps to increase the timeout session: http://support.microsoft.com/kb/918609

  hope it will solve the timeout session problem, read carefully before touching the HKEY's, let me know if you face any other issues.

  go through these kb articles: http://support.microsoft.com/kb/907490

  https://community.dynamics.com/product/crm/crmtechnical/b/crmdavidjennaway/archive/2008/09/04/sql-timeouts-in-crm-generic-sql-error.aspx

   

  ---

  Thanks, - Israel Pradeep, - Software Engineer & PMP & B.I - Entrepreneur, - "If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful""

  • Proposed as answer by Israel Gujjarlapudi Wednesday, May 4, 2011 12:39 AM
  • Marked as answer by Jamie MileyModerator Friday, August 31, 2012 5:38 PM

  Wednesday, May 4, 2011 12:39 AM
• 

  

  0

  Sign in to vote

  Was your issue solved?

  ---

  Jamie Miley
  Check out my about.me profile!
  http://mileyja.blogspot.com
  Linked-In Profile
  Follow Me on Twitter!

  Tuesday, February 14, 2012 6:05 PM

  Moderator