SQL Server Errors or Failures from Error: 21847 to Error: 21867

 

Error: 21847, Severity: 16, Cannot find a merge agent job for the specified merge push subscription.
Error: 21848, Severity: 16, The specified pull subscription is not configured with a synchronization agent job.
Error: 21850, Severity: 16, The property “%s” cannot be changed to “%s” after the value has already been set to “%s”.
Error: 21851, Severity: 16, Peer-to-peer publications only support a “%s” value of %s. Article “%s” currently has a “%s” value of %s. This value must be changed to continue.

Error: 21852, Severity: 16, Peer-to-peer publications do not support %s. Article “%s” currently has %s. This must be changed to continue.
Error: 21853, Severity: 10, Warning: The “%s” property for %s “%s” has been changed to “%s” because it is required by %s.
Error: 21854, Severity: 10, Could not add new article to publication ‘%s’ because of active schema change activities or a snapshot is being generated.
Error: 21855, Severity: 16, The login %s provided in sp_link_publication is not mapped to any user in publishing database %s.

Error: 21856, Severity: 16, For a .NET Assembly Business Logic Handler, the .NET Assembly name should be the name of a valid assembly in ‘%s’ that contains the class that implements the Microsoft.SqlServer.Replication.BusinessLogicSupport.BusinessLogicModule interface. Check the reg
Error: 21857, Severity: 10, Forcing re-initialization for article ‘%s’ in publication ‘%s’, the clustered index on indexed view ‘%s’ may have been dropped by upgrade or restore process, please re-create the index and re-sync your data.
Error: 21858, Severity: 16, Snapshot can not process article ‘%s’ in publication ‘%s’, the clustered index on indexed view ‘%s’ may have been dropped by upgrade or restore process, please re-create the index and re-run snapshot.
Error: 21859, Severity: 16, Cannot change subscription property ‘%s’ because there is no entry for this subscription in the MSsubscription_properties table. Call sp_addmergepullsubscription_agent before changing this property.
Error: 21860, Severity: 10, Table ‘%s’ in database ‘%s’ is subscribing to transactional queued publication and published for merge for uploading changes, this may cause non-convergence between transactional publisher and subscriber.
Error: 21861, Severity: 16, The current operation was aborted because it would deactivate an article in a publication for which a snapshot was being generated.
Error: 21862, Severity: 16, FILESTREAM columns cannot be published in a publication by using a synchronization method of either ‘database snapshot’ or ‘database snapshot character’.
Error: 21863, Severity: 16, Cannot add the SPARSE property to a column for the article ‘%s’ because merge replication does not support sparse columns.
Error: 21864, Severity: 16, Cannot publish the article ‘%s’ or add the COLUMN_SET attribute set to its base table ‘%s’ because replication does not support column sets.
Error: 21865, Severity: 16, The ‘%s’ publication property must be either ‘true’ or ‘false’.
Error: 21866, Severity: 16, The publication property ‘%s’ can only be set to ‘%s’ when the publication property ‘%s’ is set to ‘%s’.
Error: 21867, Severity: 16, ALTER TABLEE SWITCH statement failed. The table ‘%s’ belongs to a publication which does not allow switching of partitions

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.