Error executing a batch of commands. Retrying individual commands

Error in Peer replication :42000 A conflict of type 'Update-Delete' was detected at peer 301 between peer 103 (incoming), transaction id 0x00000000003ec375  and peer (null) (on disk), transaction id (null) for Table '[dbo].[JWAddressInformation]' with Primary Key(s): [CustomerId] = 3A132CB3-2DBB-E711-80CD-000D3A1805D4,  Current Version '(null)', Pre-Version '0x67000000F3963A0000000000' and Post-Version '0x6700000075C33E0000000000' 22815
2017-11-02 09:17:09.715 Disconnecting from Subscriber 'test1'
2017-11-02 09:17:09.715 Connecting to Subscriber 'test2'
2017-11-02 09:17:09.715 Error executing a batch of commands. Retrying individual commands.
2017-11-02 09:17:09.856 Agent message code 22815. A conflict of type 'Update-Delete' was detected at peer 301 between peer 103 (incoming), transaction id 0x00000000003ec375  and peer (null) (on disk), transaction id (null) for Table '[dbo].[JWAddressInformation]' with Primary Key(s): [CustomerId] = 3A132CB3-2DBB-E711-80CD-000D3A1805D4,  Current Version '(null)', Pre-Version '0x67000000F3963A0000000000' and Post-Version '0x6700000075C33E0000000000'
Raju Mellalead consultant DBAAsked:
Who is Participating?
 
Pawan KumarDatabase ExpertCommented:
In peer replication we have 2 methods - Either manually fix this issue like the other author mentioned or you can set the node precedence about the conflict. At configuration we can set which node have precedence in case of conflicts.
0
 
Deepak ChauhanSQL Server DBACommented:
Please look into the table  Table '[dbo].[JWAddressInformation]' for Primary Key(s): [CustomerId] = 3A132CB3-2DBB-E711-80CD-000D3A1805D4 at subscriber.

Seems this records does not exists and has been deleted while replication agent trying to update that record. at subscriber.

Check on both subscriber Test 1 and test 2.
0
 
HuaMin ChenSystem AnalystCommented:
Hi,
There is Create View permission which can be granted or revoked, and please read:
https://www.sqlservercentral.com/Forums/Topic1347192-391-1.aspx
0
 
HuaMin ChenSystem AnalystCommented:
Raju,
Is this resolved?
0
 
HuaMin ChenSystem AnalystCommented:
Details were given to resolve this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.