Merge replication Error at the subscribers

Question

I was working on a merge replication on SQL SERVER 2012. I have one central server with the publication and distribution configured on the same machine.I have another three machines with SQL SERVER 2012 as subscribers. The replication is working fine, however I run in to the following error on all the subscribers

The schema script

if exists (select * from syscolumns where name = N'TransporterID' and id = object_id(N'[dbo].[Transporter]')) if object_id(N'[dbo].[Transporter]') is not null exec('ALTER TABLE [dbo].[Transporter] DROP COLUMN TransporterID')' could not be propagated to the subscriber.

Thanks

score 0 · Accepted Answer · answered Mar 12 '15 at 16:35

0

This appears to be a failed schema change. You can either reinitialize the subscriptions or skip the schema change. If reinitialization is not an option, then you can skip the schema change like so.

You can locate the schema change you would like to skip in the table sysmergeschemachange. Another way to locate the schema change is to execute sp_enumeratependingschemachanges:

EXEC sp_enumeratependingschemachanges 
    @publication = 'MyPublicationName'

Get the schemaversion from the result set and then skip the schema change by executing sp_markpendingschemachange. For example, if the schemaversion is 22:

EXEC sp_markpendingschemachange 
    @publication = 'MyPublicationName',
    @schemaversion = 22
    @status = 'skipped'

answered Mar 12 '15 at 16:35

Brandon Williams

3,695
16
19

Thank you Brandon. Just executed "EXEC sp_enumeratependingschemachanges @publication = 'MyPublicationName" and the tables returns nothing. The table is empty. I remotely log in to the subscriber and see the same error. – mox-du Mar 12 '15 at 17:25
Did you execute it on the publisher? – Brandon Williams Mar 12 '15 at 17:32
How about in sysmergeschemachange? Examine the schematext column and compare it with your error message. Do you see it? – Brandon Williams Mar 12 '15 at 17:49
What is the schemastatus? – Brandon Williams Mar 12 '15 at 18:15
Ok, now grab the schemaversion value and on the publisher, execute sp_markpendingschemachange, passing in the @@schemaversion and @@status of 'skipped' like the example I provided above. – Brandon Williams Mar 12 '15 at 18:27
1

Command(s) completed successfully. let me remotely log in to the subscribers and see the status. Tnx – mox-du Mar 12 '15 at 18:33

Merge replication Error at the subscribers

1 Answers1