Forum Discussion
ADF validation failing for Azure SQL Sink upsert when fault tolerance (skip rows) enabled
Hi all, I have been getting this error since yesterday, "Fault tolerance is not supported when using azure sql database upsert method." There have been published versions of the data factory wher...
tejarebb I am also having this same issue. I am also unfortunately in a position where I can not remove fault tolerance.
Unfortunately, MS told that the feature never worked in the first place for upsert operations. I don't think there's any alternative other than disabling it
- That's very bizarre. It's been working for us perfectly fine until I believe around the 7th. We aren't making a new pipeline on our end, we're just trying to update an existing pipeline that we've had for, to my knowledge, at least 3 months. We're trying to update the mapping to add a new column.