Forum Discussion

DavisWard's avatar
DavisWard
Qrew Trainee
3 years ago

Does a pipeline still update records when it errors out for unique fields.

Received this error which I expected when running this pipeline.

Remote service reported an error: 51 : Trying to add a non-unique value to a field marked unique : Your import data has duplicate values for the following unique fields Field name: Invoice Number Duplicate values: 60401 57304 58901 59070 55231 55391 57280 60925 61027 57510 58583 60812 59400 55234 60086 60168 54736 58932 58940 58427 60088 -- Processed: 0 - Added: 0 - Updated: 0 - Unchanged: 0

I am wanting anything with duplicate values to not create a new record. These items it flagged. But does this mean that the other records that were not duplicates still were updated properly? Or did the error cancel any other updates?

------------------------------
Davis Ward
------------------------------
  • The error cancelled the other updates too.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • RameshSingh's avatar
      RameshSingh
      Qrew Member

      Can it be resolved ?



      ------------------------------
      XYZ
      XYZ
      ------------------------------