none
Update DataCopy Issue

    Question

  • Hello,

    I am trying to copy data from CRM Dynamics to Azure SQL DB. Once I copy all the data, I update a record in CRM Dynamics. When I debug the Data copy activity in ADF, it gives me Primary Key Violation for which I did set the "skip incompatible rows" in settings. 

    My aim is to update any record in CRM, debug the ADF pipeline datacopy activity which should be able to update only that particular record in Azure SQL DB. 

    Any help will be appreciated. 

    Thank you.

    Friday, September 7, 2018 2:11 PM

All replies

  • Hi,

    Could you provide the activity run ID of your mentioned failed one? We can take a look why it doesn't work as expected.

    Monday, September 10, 2018 7:23 AM
  • Hi,

    Pipeline Run ID : 231f2645-6246-415c-9924-2fd67bc772bf

    Thank you.

    Monday, September 10, 2018 10:20 AM
  • Hi,

    I didn't find the skip incompatible rows setting from this run. Please double check whether the setting is enabled. Here is the link about this feature: https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-fault-tolerance.

    Tuesday, September 11, 2018 1:40 AM