web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Change a users busines...
Microsoft Dynamics CRM (Archived)

Change a users business unit for Online giving SQL timeout expired

(0) ShareShare
ReportReport
Posted on by Nishant Rana 11,325 Microsoft Employee

Hi Experts,

For one of the user we are getting SQL timeout expired error. One of the reasons i can think of is that user owns huge number of records.

Is there any way we can achieve this for online ?

Thanks,

Nishant Rana

*This post is locked for comments

I have the same question (0)
  • Verified answer
    David Jennaway Profile Picture
    David Jennaway 14,065 on at
    RE: Change a users business unit for Online giving SQL timeout expired

    You're right that the issue is probably because the user owns a lot of records. This is because CRM uses a derived column (owningbusinessunit) on user-owned entities, and this will have to be updated for all records in one transaction, and this can time out.

    Unfortunately, I don't think there's a simple way around this in CRM Online. One possible option is to reassign the records to a different owner, then change the user's business unit, then reassign the records back. However, you'd need to record which records were owned, so that you can reassign them back, and you'd need to build a process to do the reassigning per entity. 

    Alternatively, if the ownership of many of the owned records doesn't matter, you could try just reassigning those that don't matter, then seeing if this is sufficient to allow you the change the businessunit

  • Nishant Rana Profile Picture
    Nishant Rana 11,325 Microsoft Employee on at
    RE: Change a users business unit for Online giving SQL timeout expired

    Thanks David for replying. Yes will try through reassignment.  

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
Wayne Walton Profile Picture

Wayne Walton 2

#2
Good.Panos Profile Picture

Good.Panos 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans