Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

SQL Timeout when changing Business unit

  • 1.  SQL Timeout when changing Business unit

    Posted Apr 11, 2019 05:46 AM
    ​​Hi!

    We are running Dynamics CRM 2016 on prem and when we are trying to change business units for some users, we get an SQL Time Out.
    For the bulk of the users the change went ok.

    Has anyone experienced this same problem?

    Best regards,

    Carl J

    ------------------------------
    Carl Johansson
    SEB
    Stockholm
    ------------------------------
    Conference-CRMUG_200x200


  • 2.  RE: SQL Timeout when changing Business unit

    MICROSOFT MVP
    Posted Apr 11, 2019 09:36 AM
    Hello,
    When you're on-prem you can change SQL Timeout - https://www.powerobjects.com/blog/2013/06/28/timeouts-in-microsoft-dynamics-crm-2011/
    That should resolve your issue. Good luck.

    ------------------------------
    Andrew Butenko
    ------------------------------

    Conference-CRMUG_200x200


  • 3.  RE: SQL Timeout when changing Business unit

    TOP CONTRIBUTOR
    Posted Apr 12, 2019 05:25 PM
    Word of caution: Make sure you take a backup of the complete registry before making any changes to it. It tends to have a very bad effect on the whole system if it does not go the right way.

    ------------------------------
    Sunil Raheja
    Aha Apps
    Glen Allen VA
    ------------------------------

    Conference-CRMUG_200x200


  • 4.  RE: SQL Timeout when changing Business unit

    MICROSOFT MVP
    Posted Apr 14, 2019 07:38 AM
    Hi Carl,

    SQL timeout issues are not uncommon, particularly with on-prem.  The trick is finding out the underlying cause of the timeout.  Check the event logs on the CRM and SQL servers, these should show further information about the reasons for the error.  @Feridun Kadir has a quick blog post on tips for SQL timeout issues: https://fkbase.info/node/350

    It could also be a platform issue.  Are you up-to-date with your patches for Dynamics 2016?  https://support.microsoft.com/en-gb/help/3142345/microsoft-dynamics-365-onpremise-cumulative-updates

    Feel free to post any error messages you find in the event logs and we'll try to help further.

    Best regards,
    Andrew.​

    ------------------------------
    Andrew Bibby
    Dynamics 365 Consultant & Project Advisor
    Evesham United Kingdom
    ------------------------------

    Conference-CRMUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role