Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I'm trying to bring a Team from one enviroment to another by using Data synchronisation studio (or/and XRM toolbox).
Previsously I had no issues or what so ever. And now I'm getting a Sql error:
Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 547
can you help me resolve this issue?
Try the same using CRM Configuration migration tool.
Have you tried to use XRM Toolbox and the ‘Data Transporter’ plugin to transfer a team from one environment to another.
Transferring teams across organizations in Dynamics 365 (mscrm-solutions.com)
For 'Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 547' error message:
You can refer following links, maybe you can get some inspiration:
Solved: Generic SQL error -2147204784 - Power Platform Community (microsoft.com)
Generic SQL Error - Microsoft Dynamics CRM Forum Community Forum
And this Database Engine Errors page talks about all the possible errors(Sql Number: 547).
You can try to check it through following ways:
Enable CRM tracing - This option may provide you more information on the source of the issue, but in most instances you will just see a repeat of the same vague error that appear during the import.Run SQL Profiler - This will be the most useful tool to determine the source of the issue given that the source of the problem is likely related to a SQL object with one of the CRM databases.
But i recommend contacting Microsoft Dynamics CRM Support - For many of our customers that do not have the technical resources in-house or use CRM Online this is the most viable option.
Business Applications communities