Data Factory Copy Data Activity Can't Find Record to Update

Question

I am getting the following error when running a pipeline in Azure Data Factory:

Operation on target PlotSales failed: ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147220891, error message: Cannot find record to be updated.,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,'

I am running a Copy Data Activity, which should be an upsert, so I'm confused as to why it's failing. I would have thought if it couldn't find the record, it would insert it instead.

Answer 1

Hi Bethany Griffin

Thanks for getting back with us with the solution, as QandA platform doesn't allow users to accept their own answer, ill post the same solution you gave here, and kindly accept it, as it helps people with the similar issue.

Solution : Turns out there was a process running that updated a plot when a plot sale is updated, even though the plot foreign key wasn't required. Turning off this process has fixed the issue.

Thanks much for your contributrion.

Answer 2

Turns out there was a process running that updated a plot when a plot sale is updated, even though the plot foreign key wasn't required. Turning off this process has fixed the issue