Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Cannot Go Offline in Outlook Client

Posted on by 75

I have a customer who's having problems when trying to go offline in Outlook 2010 on a Windows Surface, running Windows 8.1, against CRM Online.

When the user selects "Go Offline" in Outlook, they get the error (after about a minute) "SQL Timeout Expired".

They're able to access the CRM Online instance without any problems in Internet Explorer and I'm also able to call the discovery service.

Internet traffic is managed for the user by a proxy server, but the relevant dynamics.com URLs are all included on the white list.

I've tried a few things already:

  • Removed the CRM Client, including the SQL Server 2012 components and any temporary files in C:\temp and C:\users\username\AppData\Local\Temp
  • Re-installed the CRM Client
  • Ran tracing using the CRM Diagnostic Tool
  • Modified c:\program files\microsoft dynamics CRM\client\res\web\bin \microsoft.crm.application.outlook.webformshost.exe.config to include a reference to the customer's proxy server.

Are there any registry settings I can add to increase the SQL Timeout, or am I probably getting that error because the Client can't actually connect to CRM Online? I know you can add the registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM\OLEDBTimeout
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM\ExtendingTimeout

... to an on-premise CRM SQL Server to increase the SQL timeout, but I don't know if this works with the Outlook Client too?

Thanks for your help.

*This post is locked for comments

  • Artibh Profile Picture
    Artibh 10 on at
    RE: Cannot Go Offline in Outlook Client

    How did you increase the timeout

  • Verified answer
    barmstrong Profile Picture
    barmstrong 75 on at
    RE: Cannot Go Offline in Outlook Client

    In the end, we logged a call with MS Support. The SQL Timeout error message was coming from SQL Server and not the Outlook Client. They increased the timeout and we can how go offline.

    The timeout was expiring because of the deleteBatchSize statement which is run each time Outlook goes offline. The customer's database is very large, so there were too many records to delete in the allowed time. They also seemed to have a lot of orphaned SubscriptionId records, which MS Support removed for them.

    This article is also useful: blogs.msdn.microsoft.com/.../crm-2011-outlook-synchronization-process

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans