SQL Server Errors or Failures from Error: 21387 to Error: 21406

SQLServerF1

 

Error: 21387, Severity: 16, The expanded dynamic snapshot view definition of one of the articles exceeds the system limit of 3499 characters. Consider using the default mechanism instead of the dynamic snapshot for initializing the specified subscription.
Error: 21388, Severity: 10, The concurrent snapshot for publication ‘%s’ is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for the publication m

Error: 21389, Severity: 10, Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication ‘%s’ because column-level collation is scripted out with the article schema creation script.
Error: 21390, Severity: 10, Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication ‘%s’ because extended properties are scripted out with the article schema creation script.
Error: 21391, Severity: 10, Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication ‘%s’ because it contains schema-only articles.

Error: 21392, Severity: 16, Row filter(%s) is invalid for column partition(%s) for article ‘%s’ in publication ‘%s’.
Error: 21393, Severity: 16, Dropping row filter(%s) for article ‘%s’ in ‘%s’. Reissue sp_articlefilter and sp_articleview to create a row filter.
Error: 21394, Severity: 16, Invalid schema option specified for publication that allows updating subscribers. Need to set the schema option to include DRI constraints.
Error: 21395, Severity: 10, This column cannot be included in a transactional publication because the column ID is greater than 255.
Error: 21396, Severity: 16, The value specified for the @type parameter of sp_addsubscriber or the @subscriber_type parameter of sp_addsubscription is not valid. See SQL Server Books Online for a list of valid values.
Error: 21397, Severity: 16, The transactions required for synchronizing the nosync subscription created from the specified backup are unavailable at the Distributor. Retry the operation again with a more up-to-date log, differential, or full database backup.
Error: 21398, Severity: 16, Could not complete setting up the no-sync subscription at the Distributor while the distribution cleanup agent is running. The operation has a greater chance of success if the distribution cleanup agent is temporarily disabled.
Error: 21399, Severity: 16, The transactions required for synchronizing the subscription with the specified log sequence number (LSN) are unavailable at the Distributor. Specify a higher LSN.
Error: 21400, Severity: 16, Article property must be changed at the original Publisher of article ‘%s’.
Error: 21401, Severity: 16, Article name cannot be ‘all’.
Error: 21402, Severity: 16, Incorrect value for parameter ‘%s’.
Error: 21403, Severity: 10, The ‘max_concurrent_dynamic_snapshots’ publication property must be greater than or equal to zero.
Error: 21404, Severity: 10, ‘%s’ is not a valid value for the ‘%s’ parameter. The value must be a positive integer greater than 300 or 0.
Error: 21405, Severity: 10, ‘%s’ is not a valid value for the ‘%s’ parameter. The value must be an integer greater than or equal to %d.
Error: 21406, Severity: 10, ‘%s’ is not a valid value for the ‘%s’ parameter. The value must be 0 or 1.

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 *