Error executing a batch of commands. Retrying individual commands

Raju Mella
Raju Mella used Ask the Experts™
on
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'
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
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.
Database Expert
Awarded 2016
Top Expert 2016
Commented:
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.
HuaMin ChenProblem resolver
Commented:
Hi,
There is Create View permission which can be granted or revoked, and please read:
https://www.sqlservercentral.com/Forums/Topic1347192-391-1.aspx
HuaMin ChenProblem resolver

Commented:
Raju,
Is this resolved?
HuaMin ChenProblem resolver

Commented:
Details were given to resolve this.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial