Merge Replication deleting data

Hi,
We have a huge problem at the moment with merge replication deleting
data in our tables. Im running MS SQL 2000 SP4 and have several
subscribers syncing their data back to the publisher on a daily basis.
For some reason records are getting deleted out of 2 tables which have
a parent child relationship. The parent table is a header information
table about our orders and the child table is the detail of the order.
I have been reading about this problem in several groups and have
already unchecked the "Enforce relationships for replication" check box
for all replicated tables. This has stopped our constraint errors from
appearing in the conflict tables but the data is still getting deleted.
I can not narrow it down on why this data is getting deleted, I do know
that users cant delete these records and the deletions are
inconsistent.
Can someone please help me with this problem as millions of dollars
worth of orders are at stake!
Ben
Benzine - can you check to see if this is a compensating changes situation:
http://support.microsoft.com/default.aspx?scid=kb;en-us;828637&Product=sql2k
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Are the missing rows logged in the conflict tables? View them using the
conflict viewer.
Are you also using join filters?
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
"Benzine" <bfausti@.gmail.com> wrote in message
news:1168319333.389814.90990@.i15g2000cwa.googlegro ups.com...
> Hi,
> We have a huge problem at the moment with merge replication deleting
> data in our tables. Im running MS SQL 2000 SP4 and have several
> subscribers syncing their data back to the publisher on a daily basis.
> For some reason records are getting deleted out of 2 tables which have
> a parent child relationship. The parent table is a header information
> table about our orders and the child table is the detail of the order.
> I have been reading about this problem in several groups and have
> already unchecked the "Enforce relationships for replication" check box
> for all replicated tables. This has stopped our constraint errors from
> appearing in the conflict tables but the data is still getting deleted.
>
> I can not narrow it down on why this data is getting deleted, I do know
> that users cant delete these records and the deletions are
> inconsistent.
> Can someone please help me with this problem as millions of dollars
> worth of orders are at stake!
> Ben
>
|||HI Hilary,
Thanks for your reply,
No the missing rows are not logged anywhere, and there are no join
filters being used.
The version which are running at the publisher and the subscribers are
different, would this be the cause of this problem?
The publisher is running MS SQL 2000 SP4, and the subscribers are all
running MS SQL Desktop Engine SP3.
Regards,
Ben
On Jan 9, 10:19 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> Are the missing rows logged in the conflict tables? View them using the
> conflict viewer.
> Are you also using join filters?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "Benzine" <bfau...@.gmail.com> wrote in messagenews:1168319333.389814.90990@.i15g2000cwa.go oglegroups.com...
>
>
>
>
|||I dont think this is the case as the server seems to be running SP4.
The subscribers however are running MS SQL 2000 Desktop Engine SP3,
will this cause the issue?
On Jan 9, 8:14 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Benzine - can you check to see if this is a compensating changes situation:http://support.microsoft.com/default.aspx?scid=kb;en-us;828637&Produc...
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
|||But the default for the compensate_for_errors parameter is true. Pls try
setting it to false and see if this eliminates the problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hi Paul,
On further review I think you are correct, but when I try to set the
parameter I get the following message:
"Every SQL Server Subscriber of publication '[Publication Name]' must
be version 8.00.0858 or higher in order for compensation for errors to
be turned off for its subscription."
I am unsure if this is still setting the parameter at the publisher as
it doesn't indicate, when I run "sp_help [table name]" the property
"compensate_for_errors" does not appear anywhere, how can I check?
Regards,
Ben
On Jan 11, 1:30 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> But the default for the compensate_for_errors parameter is true. Pls try
> setting it to false and see if this eliminates the problem.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.