UPSERT MERGE ISSUE

Rohit Kulkarni 711

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.

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

1 answer

AnnuKumari-MSFT 33,986 Reputation points Microsoft Employee

2022-05-10T09:05:54.147+00:00
Hi @Rohit Kulkarni ,

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

that's happening for the same table all the time ?

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

What is selected in the keycolumns for upsert functionality?

Looking forward for your response. Thanks !
Please sign in to rate this answer.
Rohit Kulkarni 711 Reputation points

2022-05-10T09:36:09.627+00:00

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

that's happening for the same table all the time ? : Yes

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

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

Regards
Rk

AnnuKumari-MSFT 33,986 Reputation points Microsoft Employee

2022-05-12T18:12:26.12+00:00

Hi @Rohit Kulkarni ,
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!

AnnuKumari-MSFT 33,986 Reputation points Microsoft Employee

2022-05-21T11:58:42.89+00:00

Hi @Rohit Kulkarni ,
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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

UPSERT MERGE ISSUE

1 answer

Your answer