SQL Server Errors or Failures from Error: 21868 to Error: 21887

SQLServerF1

 

Error: 21868, Severity: 16, ALTERR TABLE SWITCH statement failed. The statement is not allowed because one or more of the tables in this statement is an article with a different destination table or owner.
Error: 21869, Severity: 16, Cannot add filter between proposed parent article ‘%s’ and proposed child article ‘%s’ since this would introduce a cycle in the filter relationships. The proposed parent is already being filtered by the child.
Error: 21870, Severity: 16, Distribution agent encountered a deadlock while applying commands in SubscriptionStreams mode. Spid %u waiting on lock (type ‘%s’, mode ‘%s’) for index ‘%s’ of table ‘%s’.

Error: 21871, Severity: 16, Publisher %s of database %s has not been redirected.
Error: 21872, Severity: 16, The availability group associated with Virtual Network Name ‘%s’ has no replicas.
Error: 21873, Severity: 16, You are not authorized to run the stored procedure %s.
Error: 21874, Severity: 16, The stored procedure %s must be run from a distirbution database. The current database %s is not a distribution database.
Error: 21875, Severity: 16, The parameters @original_publisher and @publisher_db to stored procedure ‘%s’ may not be NULL.

Error: 21876, Severity: 16, The distributor ‘%s’ is not the distributor for original publisher ‘%s’ and publisher database ‘%s’.
Error: 21877, Severity: 16, The original publisher ‘%s’ for database ‘%s’ is not a remote server for the distributor.
Error: 21878, Severity: 16, Unable to create a linked server to use in contacting the remote publisher for original publisher ‘%s’, publisher database ‘%s’, and redirected publisher ‘%s’. The command ‘%s’ failed with Error ‘%d’, Error Message ‘%s’.
Error: 21879, Severity: 16, Unable to query the redirected server ‘%s’ for original publisher ‘%s’ and publisher database ‘%s’ to determine the name of the remote server; Error %d, Error message ‘%s’.
Error: 21880, Severity: 16, The virtual network name ‘%s’ has been used to identify the redirected publisher for original publisher ‘%s’ and database ‘%s’. The availability group associated with this virtual network name, however, does not include the publisher database.
Error: 21881, Severity: 16, The database ‘%s’ at the redirected publisher ‘%s’ for original publisher ‘%s’ and database ‘%s’ is either not synchronized or is not active.
Error: 21882, Severity: 16, The database ‘%s’ at the redirected publisher ‘%s’ for original publisher ‘%s’ and database ‘%s’ belongs to a HADRon availability group and must be redirected to its associated HADRon Virtual Network Name.
Error: 21883, Severity: 16, The query at the redirected publisher ‘%s’ to determine whether the publisher database ‘%s’ belonged to an availability group failed with error ‘%d’, error message ‘%s’.
Error: 21884, Severity: 16, The query at the redirected publisher ‘%s’ to determine the health of the availability group associated with publisher database ‘%s’ failed with error ‘%d’, error message ‘%s’.
Error: 21885, Severity: 16, The return code of the failed call was ‘%d’.
Error: 21886, Severity: 16, The remote server name returned was null.
Error: 21887, Severity: 16, The query at the redirected publisher ‘%s’ to determine whether the publisher database ‘%s’ belonged to an availability group failed with error ‘%d’, error message ‘%s’.

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 *