Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Changing Business unit...
Customer experience | Sales, Customer Insights,...
Unanswered

Changing Business unit for particular user the generic Sql error

(0) ShareShare
ReportReport
Posted on by reemanaseej 2
when i changed the Buisniss unit for user in crm sql error:
Unhandled Exception: System.ServiceModel.FaultException`1
[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, 
Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: 
Generic SQL error.Detail: 
<OrganizationServiceFault xmlns:i=/http://www.w3.org/2001/XMLSchema-instance/
 xmlns=/http://schemas.microsoft.com/xrm/2011/Contracts/>
  <ActivityId>6b629535-08c6-410e-b4d1-ef8ffffea58e</ActivityId>
  <ErrorCode>-2147204784</ErrorCode>
  <ErrorDetails xmlns:d2p1=/http://schemas.datacontract.org/2004/07/System.
Collections.Generic/ />
  <Message>Generic SQL error.</Message>
  <Timestamp>2023-11-04T18:19:46.0772082Z</Timestamp>
  <ExceptionRetriable>false</ExceptionRetriable>
  <ExceptionSource i:nil=/true/ />
  <InnerFault i:nil=/true/ />
  <OriginalException i:nil=/true/ />
  <TraceText i:nil=/true/ />
</OrganizationServiceFault>
 
please any help?
  • reemanaseej Profile Picture
    reemanaseej 2 on at
    Changing Business unit for particular user the generic Sql error
    Thanx Rudy :
     
    i followed all the steps you mentioned, but unfortunately I still can't move the user to this specific BU. It's weird because I can move to any other BU.
  • RudyZhang Profile Picture
    RudyZhang Microsoft Employee on at
    Changing Business unit for particular user the generic Sql error
    Hi,
     
    We have analyzed the information you have provided and you have a general SQL error that can be caused by a variety of issues. Here are some common causes
     
    1. SQL Server timeout, SQL Server timeout may occur when changing the name field of a Microsoft Dynamics CRM user.
     
    Please refer to the documentation at the following link
    https://learn.microsoft.com/en-us/previous-versions/troubleshoot/dynamics/crm/timeout-administrator-changes-user-record
     
    2. User privilege issue, when you change the business unit of a user, all roles are removed. Ensure that you add roles to the user after changing the business unit.
     
    We will continue to track this issue and if there is any progress, I will reply below.
     
    Additionally, if this issue is having a serious impact on your business, we recommend that you use the link below to seek technical support from Microsoft.
     
     
     
    I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.
     
    Best Regards,
    Rudy Zhang

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans