| Author |
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
| |
| Hilary Cotter 2005-05-30, 7:23 am |
| 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...
> 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.[color=darkred]
also[color=darkred]
information[color=da
rkred]
>
>
| |
| Hilary Cotter 2005-05-31, 3:23 am |
| 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
>
>
| |
| Hilary Cotter 2005-05-31, 3:23 am |
| 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
> 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[color=darkred]
found.[color=darkred]
the[color=darkred]
>
>
| |
|
| 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
> 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[color=darkred]
found.[color=darkred]
the[color=darkred]
>
>
|
|
|
|