Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Upsert Issue
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 13%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rohit Kulkarni
731
Reputation points
Hello Team,
I am facing some issues while doing an upsert. Please refer the screenshot below :
The PLNAL Column is present in the respective table.
The columns mapped in the watermark table
The copy activity pipeline :
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator2022-06-16T22:21:05.743+00:00 Hello @Rohit Kulkarni ,
Thanks for the question and using MS Q&A platform.
From the error message, it seems like the
PLNALColumn is missing in the sink which is why the error message sayskey column '[PLNAL]' does not exist in the table '[##interimTable_xxxxxxxx]'. By default, interim table will share the same schema as sink table while performing Upsert. Could you also please validate your source and sink schema structures? I also noticed that you have confirmed that sink table hasPLNALcolumn, if so, could you please share the schema structure of the sink dataset? If you have the same column and source and sink datastores but you are receiving this error, then this may need a deeper investigation which would require a support ticket.Please verify source and sink datastores and their columns and let us know.
Thanks
-
Rohit Kulkarni 731 Reputation points
2022-06-17T17:26:37.713+00:00 Hello Team,
I have verified the data stores .it are the same in source and sink. Please refer to the details below. I am not able to attach the schema structure.
Please let me know how I can raise a ticket for it.or the ticket will be raised by you.
Please advise me.
Regards
RK -
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator
2022-06-23T00:38:56.557+00:00 Hello @Rohit Kulkarni ,
Thanks for your response. If you have a support plan, please follow this doc to file a support ticket for deeper investigation - Create an Azure support request
In case if you don't have a support plan, please let me know here so that I can check on alternate options for filing a support ticket.Thank you
-
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator
2022-06-27T22:28:18.433+00:00 Hello @Rohit Kulkarni ,
Just checking in to see if you have got a chance to file a support ticket, if so could you please share the SR# with us for tracking it.
Thank you
Sign in to comment
Sign in to answer