SQL Server Errors or Failures from Error: 21246 to Error: 21265

SQLServerF1

 

Error: 21246, Severity: 16, This step failed because table ‘%s’ is not part of any publication.
Error: 21247, Severity: 16, Cannot create file at ‘%s’. Ensure the file path is valid.
Error: 21248, Severity: 16, Cannot attach subscription file ‘%s’. Ensure the file path is valid and the file is updatable.
Error: 21249, Severity: 16, OLE DB or ODBC Subscribers cannot subscribe to article ‘%s’ in publication ‘%s’ because the article has a timestamp column and the publication is ‘allow_queued_tran’ (allows queued updating subscriptions).

Error: 21250, Severity: 16, Primary key column ‘%s’ cannot be excluded from a vertical partition.
Error: 21251, Severity: 16, Publisher ‘%s’, publisher database ‘%s’, publication ‘%s’ could not be removed from the list of synchronization partners.
Error: 21252, Severity: 16, It is invalid to remove the default Publisher ‘%s’, publication database ‘%s’, and publication ‘%s’ from the list of synchronization partners
Error: 21253, Severity: 16, Parameter ‘@add_to_active_directory’ cannot be set to TRUE

because Active Directory client package is not installed properly on the machine where SQL Server is running.
Error: 21254, Severity: 16, The Active Directory operation on publication ‘%s’ could not be completed because Active Directory client package is not installed properly on the machine where SQL Server is running.
Error: 21255, Severity: 16, Column ‘%s’ already exists in table ‘%s’.
Error: 21256, Severity: 16, A column used in filter clause ‘%s’ either does not exist in the table ‘%s’ or cannot be excluded from the current partition.
Error: 21257, Severity: 16, Invalid property ‘%s’ for article ‘%s’.
Error: 21258, Severity: 16, You must first drop all existing merge publications to add an anonymous or local subscription to database ‘%s’.
Error: 21259, Severity: 16, Invalid property value ‘%s’. See SQL Server Books Online for a list of valid parameters for sp_changemergearticle.
Error: 21260, Severity: 16, Schema replication failed because database ‘%s’ on server ‘%s’ is not the original Publisher of table ‘%s’.
Error: 21261, Severity: 16, The offload server must be specified if the agent for this subscription is to be offloaded for remote execution.
Error: 21262, Severity: 16, Failed to drop column ‘%s’ from the partition because a computed column is accessing it.
Error: 21263, Severity: 16, Parameter ‘%s’ cannot be NULL or an empty string.
Error: 21264, Severity: 16, Column ‘%s’ cannot be dropped from table ‘%s’ because it is a primary key column.
Error: 21265, Severity: 16, Column ‘%s’ cannot be dropped from table ‘%s’ because there is a unique index accessing this column.

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 *