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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HuaMin ChenProblem resolverCommented:
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 ChenProblem resolverCommented:
Raju,
Is this resolved?
0
HuaMin ChenProblem resolverCommented:
Details were given to resolve this.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.