Forum Discussion
Upsert in Open Mirroring
I can't get upsert working in Open Mirroring. Every line I add with rowmarker 4 is still added and resulting in duplicate entries. Is it just because it's still in preview?
I have been working with support in the past weeks and today I got the update that there was a known issue and a fix has been applied by the backend team.
I have tested this and it is working now.
5 Replies
I have been working with support in the past weeks and today I got the update that there was a known issue and a fix has been applied by the backend team.
I have tested this and it is working now.Hi bijns
Is it only UPSERT not working properly? Do the other three commands INSERT, UPDATE, DELETE with rowmarkers 0,1,2 work?
Best Regards,
JingYes, everything else is working fine. It's just the behaviour of 4 as 0 that is wrong.
Even when I use the basic sample files at https://learn.microsoft.com/en-us/fabric/database/mirrored-database/open-mirroring-landing-zone-format
But with a fitting _metadata.json
{
"keyColumns" : ["EmployeeID"]
}
Very consistent behaviour: 0, 1, 2 works, but 4 is behaving as 0. What is wrong?Hi bijns
It might be an issue. I recommend that you create a support ticket to report this to Microsoft. Microsoft engineers can help check this at backend and verify whether this is an issue. They may have a solution or fix to this.
Best Regards,
Jing
