SQL Server to Dynamics migration

(0) Share

Report

Posted on by Community member

Hi,

I'm using copy activity to migrate records from SQL server to Dynamics CRM but after inserting few thousands records it gives me below error, although we MS has removed API limits for our environment for purpose of data migration. Specifying different batch size and degree of parallelism also doesn't seem to help.

ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147220891, error message: Object reference not set to an instance of an object..,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,''Type=System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]],Message=The creator of this fault did not specify a Reason.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'

Categories:

Dynamics products

Migration topics

All responses (1)

Answers (0)

Community member 2 on at

Like (0)

Report

SQL Server to Dynamics migration

Hi,

we were struggling with similar problems.

Here is a list of error codes:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/reference/web-service-error-codes

This exact error code means :

0x80040265
-2147220891 Name: IsvAborted
Message: ISV code aborted the operation.

So I would say there is a custom plugin that throws an error because an EntityReference object is NULL or something similar, plugin debug/tracing may help in this case.

Best regards,

Barna