SQL Server Errors or Failures from Error: 21307 to Error: 21326

SQLServerF1

 

Error: 21307, Severity: 16, The subscription could not be attached because the subscription to publication ‘%s’ has expired.
Error: 21308, Severity: 10, Rowcount validation profile.
Error: 21309, Severity: 10, Profile used by the Merge Agent to perform rowcount validation.
Error: 21310, Severity: 10, Rowcount and checksum validation profile.
Error: 21311, Severity: 10, Profile used by the Merge Agent to perform rowcount and checksum validation.
Error: 21312, Severity: 10, Cannot change this publication property because there are

active subscriptions to this publication.
Error: 21313, Severity: 10, Subscriber partition validation expression must be NULL for static publications.
Error: 21314, Severity: 10, There must be one and only one of ‘%s’ and ‘%s’ that is not NULL.
Error: 21315, Severity: 10, Failed to adjust Publisher identity range for table ‘%s’.
Error: 21316, Severity: 10, Failed to adjust Publisher identity range for publication ‘%s’.

Error: 21317, Severity: 10, A push subscription to the publication ‘%s’ already exists. Use sp_mergesubscription_cleanup to drop defunct push subscriptions.
Error: 21318, Severity: 10, Table ‘%s’ must have at least one column that is included in the vertical partition.
Error: 21319, Severity: 16, Could not find the Snapshot Agent command line for the specified publication. Check that a valid regular snapshot job exists on the distributor.
Error: 21320, Severity: 16, The version of the Distributor cannot be lower than the version of the Publisher.
Error: 21321, Severity: 16, The parameter @dynamic_snapshot_location cannot be an empty string.
Error: 21322, Severity: 16, This publication logs conflicts on both replicas. Pre-SQL Server 2005 subscribers will not honor this setting.
Error: 21323, Severity: 16, A dynamic snapshot job can be scheduled only for a publication with dynamic filtering enabled.
Error: 21324, Severity: 16, A Snapshot Agent must be added for the specified publication before a dynamic snapshot job can be scheduled.
Error: 21325, Severity: 16, Could not find the Snapshot Agent ID for the specified publication.
Error: 21326, Severity: 16, Could not find the dynamic snapshot job with a ‘%ls’ of ‘%ls’ for the specified publication.

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 *