Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I am using CRM 2016 on premise.
I have a user jdoe who is currently assigned to business unit Grandpa. Business unit Grandpa is the parent of business unit Dad, and business unit Dad is the parent of business unit Son.
Grandpa -> Dad -> Son
I want to reassign jdoe's business unit from Grandpa to Son, but when I do, I get the Generic SQL Error pasted below. What's weird is that I can assign jdoe to Dad, and from Dad, I can assign him back to Grandpa, but still cannot assign him to Son. I was also able to assign jdoe to another business unit Uncle (parent also Grandpa), but still could not assign him to Son. I can also assign another user, who is a system admin user with business unit above Grandpa to Son. It's just this one user to this one business unit.
Any suggestions? I've looked over the user account and the business units to try to find anything weird, and I can't find anything.
Here's the ErrorDetails log:
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=188.8.131.52, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail: <OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts"> <ErrorCode>-2147204784</ErrorCode> <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" /> <Message>Generic SQL error.</Message> <Timestamp>2018-05-10T17:13:19.6269365Z</Timestamp> <InnerFault i:nil="true" /> <TraceText i:nil="true" /></OrganizationServiceFault>
Not sure just try to assign user (which causes error) security role to system administrator and then try to move the user business unit.
In addition also restart CRM application server , CRM Async server and DB server sometimes it helps.
Ideally this is generic error which is absolutely CRM internal , I don't think there was no issue with your user . This kind of issue will be fix automatically (after some time or may be 1 -2 day later) , some internal operation is going on associated with this particular user record.
Do you have a different user to try? Maybe add a new user to the Grandpa BU, then move that user to the Son BU. Point is, make sure that new user does not own any records in the Granpa BU.. If that works, see if you can re-assign the records owned by your original user to somebody else, then try moving that user to the Son BU
How long does it take to get the generic SQL error ? If it's 30 seconds or more, then you either have a timeout, or a locking issue, whereas if it's shorter then there's probably another cause. Or, enable tracing (this article still applies beyond CRM 2013) to get a better error message.
If the error is a timeout, then you can increase the timeout - see https://blogs.msdn.microsoft.com/crminthefield/2011/06/13/microsoft-dynamics-crm-timeout-settings/ and the most relevant one here is the OLEDBTimeout. Note that you'll need to recycle the CRM application pool for this to take effect.
If the error is a locking one (most likely a deadlock), then either try making the change when the system is not heavily used, or reassign the user's records to another user before changing their BU, then reassign back (this is because changing a user's BU causes CRM to update every record they own).
Thank you, Goutam. I tried bouncing services to no avail.
Thank you, Alex. I did try several other users, and I can't reproduce the problem with them. I do wonder about assigned records, though other users I've moved had assigned records in another business unit, and they moved without issue. I'm going to see if I can unassign some of his records today and try it again.
David, I appreciate the info on tracing. I am going to try that this weekend, when user volume is low. The error pops up within 0-3 seconds, so I'm confident it is not a timeout problem. DB lock makes a lot of sense, but unfortunately that's not it. I'll try the trace on Saturday
I have the same issue. I can move the user to other business units, but not the one I need. I can move other users to the one I need. They are under the same parent. Did you find a resolution?
Business Applications communities