SkipErrors not working in peer-to-peer replication

Question

I have a three node peer to peer replication and have configured the distribution agent with the profile continue on consistency errors -SkipErrors 2601:2627.

I get

Command attempted:

if @@trancount > 0 rollback tran

(Transaction sequence number: 0x00981FDA0000AB60000600000000, Command ID: 1)

Error messages:

Error 2627, Level 14, State 1, Procedure sp_MSins_dbodri_GroupMember_tab1603258586, Line 20, Message: Violation of UNIQUE KEY constraint 'DRI_GROUPMEMBER_CK1'. Cannot insert duplicate key in object 'dbo.dri_GroupMember_tab'. The duplicate key value is (9361012, 240-3-3730006, 1). (Source: MSSQLServer, Error number: 50000)

Get help: http://help/50000

Error 2627, Level 14, State 1, Procedure sp_MSins_dbodri_GroupMember_tab1603258586, Line 20, Message: Violation of UNIQUE KEY constraint 'DRI_GROUPMEMBER_CK1'. Cannot insert duplicate key in object 'dbo.dri_GroupMember_tab'. The duplicate key value is (9361012, 240-3-3730006, 1). (Source: MSSQLServer, Error number: 50000)

Get help: http://help/50000

Normally this should be skipped but now it does not work.
Any suggestions?

Answer 1

First you may should re-initiate the replication to get a common base on all subscriber

https://learn.microsoft.com/en-us/sql/relational-databases/replication/reinitialize-a-subscription?view=sql-server-ver17