SQL Server Errors or Failures from Error: 21550 to Error: 21583

SQLServerF1

 

Error: 21550, Severity: 16, Before you drop the column from the publication, all computed columns that depend on column ‘%s’ must be dropped.
Error: 21551, Severity: 16, Only members of the sysadmin or db_owner or db_ddladmin roles can perform this operation.
Error: 21552, Severity: 16, Merge data definition language (DDL) error: Dropping a column used in a row filter or a join filter is not allowed. To drop a column used in a row filter, first change the row filter using sp_changemergearticle. To drop a column used in a join filter, fir
Error: 21561, Severity: 16, The value specified for parameter %s = %d is not valid.

Error: 21564, Severity: 16, The table %s contains the column msrepl_tran_version, which is used by replication. The column is set to NULL, but it must be set to NOT NULL. Replication failed to alter this column, so you must drop the column and then add the table as an article again
Error: 21567, Severity: 16, The call format VCALL cannot be used for the specified article. VCALL format can be used only for articles in publications that allow updating subscriptions. If you do not require updating subscriptions, specify a different call format. If you do require
Error: 21569, Severity: 16, The article %s in the publication %s does not have a valid conflict table entry in the system table sysarticleupdates. This entry is required for

publications that allow queued updating subscriptions. Check for errors in the last run of the Snapshot Agent
Error: 21570, Severity: 16, Cannot create the logical record relationship. Table ‘%s’ does not have a foreign key referencing table ‘%s’. A logical record relationship requires a foreign key relationship between the parent and child tables.
Error: 21571, Severity: 16, Cannot create the logical record relationship in publication ‘%s’. The use_partition_groups option for the publication must be set to “true” in order to use logical records. Use sp_changemergepublication to set the option to “true”.
Error: 21572, Severity: 16, Cannot add a logical record relationship because the foreign key constraint ‘%s’ on table ‘%s’ is disabled. To create the logical record relationship, first enable the foreign key constraint.
Error: 21573, Severity: 16, Cannot add a logical record relationship because the foreign key constraint ‘%s’ on table ‘%s’ is defined with the NOT FOR REPLICATION option. To add the logical record relationship, first drop the foreign key constraint, and then re-create it without the
Error: 21574, Severity: 16, Cannot add a logical record relationship because the article ‘%s’ is published in publication ‘%s’, which has a compatibility level lower than 90RTM. Use sp_changemergepublication to set the publication_compatibility_level to 90RTM.
Error: 21575, Severity: 16, The value specified for the property filter_type is not valid. Valid values are 1 (join filter only), 2 (logical record relation only), and 3 (join filter and logical record relation).
Error: 21576, Severity: 16, Cannot add a logical record relationship between tables ‘%s’ and ‘%s’ because the foreign key column ‘%s’ in table ‘%s’ allows NULL values. Alter the column to disallow NULL values.
Error: 21578, Severity: 16, In order to use partition_options of 2 (non overlapping partitions with multiple subscriptions per partition) or 3 (non overlapping partitions one subscription per partition) the publication ‘%s’ must be enabled to use partition groups functionality. Use
Error: 21579, Severity: 16, Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of 2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article is involved in multiple join filters.
Error: 21580, Severity: 16, Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of 2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article is involved in both a row filter and
Error: 21581, Severity: 16, Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of 2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article has a join filter with a join_unique_
Error: 21582, Severity: 16, Article “%s” in publication “%s” does not qualify for the partition option that you specified. You cannot specify a value of 2 or 3 (nonoverlapping partitions) for the @partition_options parameter because the article has a direct or indirect join filter
Error: 21583, Severity: 16, Cannot update the column in article ‘%s’. The article has a value of 2 or 3 (nonoverlapping partitions) for the partition_options property, and the column is involved in a row filter and/or a join filter. In this situation, the column cannot be updated at

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 *