SQL Server Errors or Failures from Error: 22551 to Error: 22570

SQLServerF1

 

Error: 22551, Severity: 16, The type “%s” is invalid. Valid types are “merge”, “tran”, and “both”.
Error: 22552, Severity: 16, A valid value for parameter “@resync_date_str” needs to be provided when “@resync_type” is set to 2.
Error: 22553, Severity: 16, The parameter “@resync_type” is set to “%d” but this subscription has never been successfully validated.
Error: 22554, Severity: 16, Cannot change publication “%s” to use the sync_mode of “character” because it uses a retention period unit other than “day”. Use sp_changemergepublication to set the retention period unit to “day”.

Error: 22555, Severity: 16, Cannot set the retention period unit to a value other than “day” for publication “%s” because it uses the sync_mode of “character” and may have SQL Server Compact Edition subscribers.
Error: 22556, Severity: 16, Invalid value for the property “%s”. Valid values are 1 and 0.
Error: 22557, Severity: 16, The status of the schema change could not be updated because the publication compatibility level is less than 90. Use sp_changemergepublication to set the publication_compatibility_level of publication “%s” to 90RTM.
Error: 22558, Severity: 16, The status of the schema change could not be updated.

Error: 22559, Severity: 16, The status of the schema change must be “active” or “skipped”.
Error: 22560, Severity: 16, Merge replication does not allow filters that reference dynamic functions that take one or more parameters. Check the function “%s”.
Error: 22561, Severity: 16, The requested operation failed because the publication compatibility level is less than 90. Use sp_changemergepublication to set the publication_compatibility_level of publication “%s” to 90RTM.
Error: 22562, Severity: 16, Cannot change the compatibility level of a publication to a value lower than the existing value.
Error: 22563, Severity: 16, contains one or more articles that do not upload changes
Error: 22564, Severity: 16, uses ddl replication
Error: 22565, Severity: 16, uses other than day as unit of retention period
Error: 22566, Severity: 16, uses logical records
Error: 22567, Severity: 16, contains one or more articles that use subscription-based or partition-based filtering
Error: 22568, Severity: 16, contains one or more articles which will not compensate for errors
Error: 22569, Severity: 16, contains one or more schema only articles
Error: 22570, Severity: 16, contains one or more articles that use automatic identity range management

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 *