Sign in

Microsoft.com

Microsoft

Remove From My Forums

SQL Time Out Expired error.

Question
0

Sign in to vote
Hi,

When i tried to open an Audit History record, the SQL time out error is being thrown, this is happening only with one record where as i can open all other Audit history records. I am using CRM 2013

Any help on this is appreciated.

Kruthi Hegde
- Edited by Kruthi Hegde Friday, March 13, 2015 6:11 AM error
Friday, March 13, 2015 6:10 AM

All replies

0

Sign in to vote

Hello,

You can increase SQL Timeout - http://blogs.msdn.com/b/crminthefield/archive/2011/06/13/microsoft-dynamics-crm-timeout-settings.aspx
Dynamics CRM MVP
My blog

Friday, March 13, 2015 6:37 AM

Moderator
0

Sign in to vote
Hello Kruthi,

Is your CRM on-premises or online?

If it is on-premises, you can turn on tracing, check which query is causing you problems and afterwards you can create an index to speed it up.

Also, refer to this post for some more info: SQL Timeout solutions in Dynamics CRM 2011

Regards
- Proposed as answer by Pedro Beltrao Thursday, March 26, 2015 10:02 AM
Monday, March 16, 2015 2:17 PM