10
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?
THNX
Hi Irvn,
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.
Hi,
Try the same using CRM Configuration migration tool.
https://jukkaniiranen.com/2014/06/configuration-migration-tool-working-smarter-metadata-entities/
Thanks,
Pradeep
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (