Groups | Blog | Home
all groups > sql server replication > january 2005 >

sql server replication : Replication error: Invalid column name 'compensate_for_errors'.


kparzych NO[at]SPAM wikpol.com.pl
1/7/2005 2:49:57 AM
Hello.

We have one distributor and about 20 subscribers. Yesterday we have
added some columns to the schema. After synchronization almost all
subscribers did it without problems. But one could not make it with
error:

Invalid column name 'compensate_for_errors'.
(Source: PLANTBRK (Data source); Error number: 207)
---------------------------------------------------------------------------------------------------------------
The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number:
-2147201001)
---------------------------------------------------------------------------------------------------------------

We have snapshot downloaded via ftp and this error shows up just after
first "Applied script...".

Version of PLANTBRK server: 8.00.929 (SP3). Same version for
distributor server (which of course is located on another machine).

Could anyone here help me?

Paul Ibison
1/7/2005 4:08:41 AM
By the looks of it you have applied FIX8621. I don't know
if this includes the compensating change fix though
(http://support.microsoft.com/kb/828637). Please compare
the arguments for sp_addmergearticle on the subscriber
that fails and ones that succeed. I'm thinking that
they'll be different in the @compensate_for_errors
parameter existing or not. If this is the case, then
you'll need to make sure the patch level is unifirm
across subscribers.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
AddThis Social Bookmark Button