SQL Server Errors or Failures from Error: 21367 to Error: 21386

SQLServerF1

 

Error: 21367, Severity: 16, Could not add filter ‘%s’ because there are active subscriptions. Set @force_reinit_subscription to 1 to force this and reinitialize the active subscriptions.
Error: 21368, Severity: 16, The specified offload server name contains the invalid character ‘%s’.
Error: 21369, Severity: 16, Could not remove publication ‘%s’ from Active Directory.
Error: 21370, Severity: 16, The resync date specified ‘%s’ is not a valid date.
Error: 21371, Severity: 10, Could not propagate the change on publication ‘%s’ to Active Directory.

Error: 21372, Severity: 16, Cannot drop filter ‘%s’ from publication ‘%s’ because its snapshot has been run and this publication could have active subscriptions. Set @force_reinit_subscription to 1 to reinitialize all subscriptions and drop the filter.
Error: 21373, Severity: 11, Could not open database %s. Replication settings and system objects could not be upgraded. If the database is used for replication, run sp_vupgrade_replication in the [master] database when the database is available.
Error: 21374, Severity: 10, Upgrading distribution settings and system objects in database %s.

Error: 21375, Severity: 10, Upgrading publication settings and system objects in database %s.
Error: 21376, Severity: 11, Could not open database %s. Replication settings and system objects could not be upgraded. If the database is used for replication, run sp_vupgrade_replication in the [master] database when the database is available.
Error: 21377, Severity: 10, Upgrading subscription settings and system objects in database %s.
Error: 21378, Severity: 16, Could not open distribution database %s because it is offline or being recovered. Replication settings and system objects could not be upgraded. Be sure this database is available and run sp_vupgrade_replication again.
Error: 21379, Severity: 16, Cannot drop article ‘%s’ from publication ‘%s’ because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force this and invalidate the existing snapshot.
Error: 21380, Severity: 16, Cannot add timestamp column without forcing reinitialization. Set @force_reinit_subscription to 1 to force reinitialization.
Error: 21381, Severity: 16, Cannot add (drop) column to table ‘%s’ because the table belongs to publication(s) with an active updatable subscription. Set @force_reinit_subscription to 1 to force reinitialization.
Error: 21382, Severity: 16, Cannot drop filter ‘%s’ because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force this and invalidate the existing snapshot.
Error: 21383, Severity: 16, Cannot enable a merge publication on this server because the working directory of its Distributors is not using a UNC path.
Error: 21384, Severity: 16, The specified subscription does not exist or has not been synchronized yet.
Error: 21385, Severity: 16, Snapshot failed to process publication ‘%s’. Possibly due to active schema change activity or new articles being added.
Error: 21386, Severity: 16, Schema change failed on object ‘%s’. Possibly due to active snapshot or other schema change activity.

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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *