Upsert fail on second attempt

Kyle Bender 21 Reputation points
2022-09-15T18:52:51.533+00:00

I'm trying to upsert all data from a temp table to a prod table using Azure Postgres. On the first attempt, the upsert from temp to prod worked but there was no data in the prod table, just a schema. On second attempt, when there is data in both temp and prod tables, i receive this error - Operation on target Data flow1 failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: at Sink.

Can anyone help troubleshoot this error?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,595 questions
Azure Database for PostgreSQL
Accepted answer
  1. AnnuKumari-MSFT 31,061 Reputation points Microsoft Employee
    2022-09-19T04:46:07.863+00:00

    Hi @Kyle Bender ,
    Welcome to Microsoft Q&A platform and thanks for posting your question here.
    I understand you are facing issue while performing Upsert using Azure data factory, I do not have a laboratory for Azure PostGreSQL to reproduce your issue, could you please help me with more details :

    1. Complete error message, the above provided error is too vague to reach to any conclusion.
    2. Screenshot of the copy activity configuration, what are the keycolumns you are using for upsert.

    Looking forward towards your response. Thanks

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest