question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked AnnuKumari-MSFT commented

UPSERT MERGE ISSUE

Hello Team,

I am trying to upsert the data from S4 Tables to SQL server tables dynamically i am selecting the tables .

Example: Out of 4 tables there is an issue with 1 table and for the rest of the tables the data is getting upserted.




199793-image.png
199720-image.png

For 1 table i am getting below mentioned.I am mentioning the steps i carried out


199875-image.png



azure-data-factory
image.png (14.1 KiB)
image.png (39.1 KiB)
image.png (52.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnnuKumari-MSFT avatar image
0 Votes"
AnnuKumari-MSFT answered AnnuKumari-MSFT commented

Hi @RohitKulkarni-6062 ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query.

As I understand your question here, you are trying to perform merge on data in SQL server tables using Upsert option in copy data activity. However, it is failing with error for one of the tables. Please let me know if my understanding is incorrect.

The error says 'Server is not responding'. This looks like an intermittent issue from source side. Could you please confirm if
1. that's happening for the same table all the time ?
2. If only that particular table is considered to be copied , others being inactive for one run, is that still failing?
3. What is selected in the keycolumns for upsert functionality?

Looking forward for your response. Thanks !

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Please refer my response in the below mnetioned points :


The error says 'Server is not responding'. This looks like an intermittent issue from source side. Could you please confirm if
1. that's happening for the same table all the time ? : Yes


  1. If only that particular table is considered to be copied , others being inactive for one run, is that still failing? : Yes


  2. What is selected in the keycolumns for upsert functionality? : Primary Key




Regards
Rk

1 Vote 1 ·

Hi @RohitKulkarni-6062 ,
It looks like an issue at source end. Could you please check if the table exists in the source datastore and the Primary key which is being used as the keyColumn is having compatible data and there is no change in the source and sink schema for that particular table. Doesn't look like an ADF issue. Please let us know the updates. Thanks!

0 Votes 0 ·

Hi @RohitKulkarni-6062 ,
Following up to see if the above suggestion was helpful, kindly do click Accept Answer and Up-Vote for the same. In case you have any further query please do let us know.

0 Votes 0 ·