Minimum Conflict Resolver

Hi,
I tried to use 'Minimum Conflict Resolver' for Orders table of Northwind.
I entered EmployeeID as 'the information needed by the resolver' and also
modified this column for a same row in two different subscribers.
I updated one of them to 1 and the other to 5. I expected 1 become the
winner but the merge agent fails with an error regarding EmployeeID.
Should I expect anything different or the resolver needs other information
than EmployeeID?
Any help would be greatly appreciated.
Leila
are you using column level tracking?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <leilas@.hotpop.com> wrote in message
news:ez2ezm7YFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I tried to use 'Minimum Conflict Resolver' for Orders table of Northwind.
> I entered EmployeeID as 'the information needed by the resolver' and also
> modified this column for a same row in two different subscribers.
> I updated one of them to 1 and the other to 5. I expected 1 become the
> winner but the merge agent fails with an error regarding EmployeeID.
> Should I expect anything different or the resolver needs other information
> than EmployeeID?
> Any help would be greatly appreciated.
> Leila
>
|||If you mean the item "treat changes to the same row as a conflict", I have
tried both items. This is the error:
The specified conflict resolution column 'employeeid' could not be found.
(Source: Merge Process (Agent); Error number: -2147467259)
Leila
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OZ3m0cQZFHA.1404@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> are you using column level tracking?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Leila" <leilas@.hotpop.com> wrote in message
> news:ez2ezm7YFHA.3320@.TK2MSFTNGP12.phx.gbl...
Northwind.[vbcol=seagreen]
also[vbcol=seagreen]
information
>
|||I'm getting the same error. I will be reporting this to MS - it looks like a
bug.
I'll try to follow up with you using your hotpop email address if this is
legit.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <leilas@.hotpop.com> wrote in message
news:eHXSnzUZFHA.3184@.TK2MSFTNGP15.phx.gbl...
> If you mean the item "treat changes to the same row as a conflict", I have
> tried both items. This is the error:
> The specified conflict resolution column 'employeeid' could not be found.
> (Source: Merge Process (Agent); Error number: -2147467259)
> Leila
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OZ3m0cQZFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Northwind.
> also
> information
>
|||trying a simpler table
However, a more simple table, i.e.
create table mergetest
(pk int not null identity constraint primarykey primary key,
charcol1 char(20),
intcol int)
will work i.e.
update mergetest set charcol1='publisher', intcol=2 where pk=1
update northwindsub.dbo.mergetest set charcol1='subscriber', intcol=1 where
pk=1
works where the northwindsub conflict wins (if the intcol column is used as
the basis of the column for the minimum conflict resolver).
Not sure what the problem is.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uLaM4NYZFHA.4088@.TK2MSFTNGP15.phx.gbl...
> I'm getting the same error. I will be reporting this to MS - it looks like
a[vbcol=seagreen]
> bug.
> I'll try to follow up with you using your hotpop email address if this is
> legit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Leila" <leilas@.hotpop.com> wrote in message
> news:eHXSnzUZFHA.3184@.TK2MSFTNGP15.phx.gbl...
have[vbcol=seagreen]
found.[vbcol=seagreen]
the
>
|||Thanks indeed!
Please keep me informed: leilas@.hotpop.com
Leila
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uLaM4NYZFHA.4088@.TK2MSFTNGP15.phx.gbl...
> I'm getting the same error. I will be reporting this to MS - it looks like
a[vbcol=seagreen]
> bug.
> I'll try to follow up with you using your hotpop email address if this is
> legit.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Leila" <leilas@.hotpop.com> wrote in message
> news:eHXSnzUZFHA.3184@.TK2MSFTNGP15.phx.gbl...
have[vbcol=seagreen]
found.[vbcol=seagreen]
the
>