Groups | Blog | Home
all groups > sql server replication > june 2006 >

sql server replication : Merge Replication Provider (Agent); Error number: -2147201001


GC
6/21/2006 12:37:03 PM
Hi,

Why the replication could not create this new column.
The replication have 5 new column to create on the subcriber
He create the first 3 columns and at the fourth one I receive this message

The schema script 'exec sp_repladdcolumn '[dbo].[temps]','HeuresRNC',' float
NOT NULL DEFAULT 0 WITH VALUES ', 'JMI_articles', 1' could not be
propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001
---------------------------------------------------------------------------------------------------------------
A column was added to or dropped from the replicated table.
(Source: JMI_ITS_TEMP (Agent); Error number: 27160
---------------------------------------------------------------------------------------------------------------
Délai d'attente expiré
(Source: ODBC SQL Server Driver (ODBC); Error number: 0
---------------------------------------------------------------------------------------------------------------

The replication try 10 times to insert this column after that the
replication stop

What can I do ?

I have no idea to resolv this problem

Karthik
6/27/2006 4:07:01 AM
Hi,

Can you try to run the snapshot agent once again and then try to synchronize?



[quoted text, click to view]
GC
6/27/2006 6:22:02 AM
I already did that it I still have the same problem

It is very frustrating working with replication when the error message dont
give us enough information about the problem.

What I dont understand is that the first 3 columns works and get stock a the
fourth one.

Thanks for give me feedback.


[quoted text, click to view]
AddThis Social Bookmark Button