Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Peer 2 Peer: Tips for identify Update-Update conflict

44 views
Skip to first unread message

Ron

unread,
Nov 16, 2009, 12:02:03 PM11/16/09
to
Hi there

I've got a conflict that I'd like to investigate, to see what the offending
transaction was.

For example

A conflict of type 'Update-Update' was detected at peer 1 between peer 4
(incoming), transaction id 0x000000000008c723 and peer 1 (on disk),
transaction id 0x000000000008c465

Can anyone point me towards the best way of working out what it is that
cause the problem? Ie what statement, record etc? I assume that the
transaction ID means something and can help me find out some useful
information

Any help appreciated.

Ron

unread,
Nov 18, 2009, 12:47:01 PM11/18/09
to
I have managed to sort this problem for myself by using the conflict viewer.
It has given me a second issue but I will raise this under a second post.
Thanks

dbaeiss

unread,
Nov 27, 2009, 5:59:01 AM11/27/09
to
You can use sp_browsereplcmds to see what exactly was being replicated.

Your error.
There is a bug pre CU4, where dummy updates lead to this issue with
update-update conflicts. It has to do with a hidden column, used by P2P
replication.

Also, my other experince with this conflict, was triggers not being set to
"NOT FOR REPLICATION".

HTH
Stephen

0 new messages