Wednesday, March 7, 2012

Merge Replication Error

I have a table called Table1 at both pulisher and subcriber which is related
to
many other tables. If i modify a row at the subcriber then instead of
updating the row at pulisher..merge agent detects conflict and overwrites th
e
row at the subcriber with the row that publisher has and newly inserted row
at subscriber is added to conflict table with the errortype =9 and text
The row was updated at subcriberX but could not be updated at PublisherX.
Unable to synchronize the row because the row was updated by a different
process outside of replication.
I am using SQL Server 2000 with SP4
ThanksI believe this error is cause by a non-logged operation - like DTS. Did you
DTS some data into one of the tables you are merge replicating?
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
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:2C08C5E7-EC46-4110-8027-51AB8EF2C290@.microsoft.com...
>I have a table called Table1 at both pulisher and subcriber which is
>related
> to
> many other tables. If i modify a row at the subcriber then instead of
> updating the row at pulisher..merge agent detects conflict and overwrites
> the
> row at the subcriber with the row that publisher has and newly inserted
> row
> at subscriber is added to conflict table with the errortype =9 and text
> The row was updated at subcriberX but could not be updated at PublisherX.
> Unable to synchronize the row because the row was updated by a different
> process outside of replication.
> I am using SQL Server 2000 with SP4
> Thanks|||Hello Hilary,
I am not using DTS or other non logged operations..but still i get this erro
r
"Hilary Cotter" wrote:

> I believe this error is cause by a non-logged operation - like DTS. Did yo
u
> DTS some data into one of the tables you are merge replicating?
> --
> 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
> "kailux4" <kailux4@.discussions.microsoft.com> wrote in message
> news:2C08C5E7-EC46-4110-8027-51AB8EF2C290@.microsoft.com...
>
>

No comments:

Post a Comment