How to send data from one Salesforce to another one?

Mikolajczyk, Radoslaw 1 Reputation point
2020-06-23T07:25:12.477+00:00

I have followed documentation, but still get error:

Operation on target Copy data1 failed: Failure happened on 'Sink' side. ErrorCode=UserErrorSalesforceOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=[BatchFailure]JobId:7503B000005VFVFQA4, BatchId:7513B000006IKypQAG, Message:InvalidBatch : Field name not found : ConnectionReceivedId,Source=Microsoft.DataTransfer.Runtime.SalesforceConnector,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,123 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ChiragMishra-MSFT 956 Reputation points
    2020-06-23T11:58:01.44+00:00

    Hi @MikolajczykRadoslaw,

    As answered on your Stack Overflow thread

    ConnectionReceivedId gets added in the SF tables if "Salesforce to Salesforce" feature is enabled. developer.salesforce.com/docs/atlas.en-us.api.meta/api/…. See if you can edit the mapping to just not map to this field? Maybe somebody copy-pasted the ADF job definition from another SF org and for you best would be to start fresh.

    You can remove the fields that are not allowed to be added, in your mappings section of the copy activity.