Upsert in Open Mirroring

[bijns]

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?

[bijns · Accepted solution]

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.

[bijns]

Even when I use the basic sample files at https://learn.microsoft.com/en-us/fabric/database/mirrored-database/open-mirroring-landing-zone-form...

But with a fitting _metadata.json 
{
"keyColumns" : ["EmployeeID"]
}

Very consistent behaviour: 0, 1, 2 works, but 4 is behaving as 0. What is wrong?

[v-jingzhan-msft]

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

[v-jingzhan-msft]

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,
Jing

[bijns]

Yes, everything else is working fine. It's just the behaviour of 4 as 0 that is wrong.