SQL Server Errors or Failures from Error: 14122 to Error: 14152



Error: 14122, Severity: 16, The @article parameter value must be ‘all’ for immediate_sync publications.
Error: 14123, Severity: 16, The subscription @sync_type parameter value ‘manual’ is no longer supported.
Error: 14124, Severity: 16, A publication must have at least one article before a subscription to it can be created.
Error: 14126, Severity: 16, You do not have the required permissions to complete the operation.

Error: 14128, Severity: 16, Invalid @subscription_type parameter value. Valid options are ‘push’ or ‘pull’.
Error: 14129, Severity: 16, The @status parameter value must be NULL for ‘automatic’ sync_type when you add subscriptions to an immediate_sync publication.
Error: 14135, Severity: 16, There is no subscription on Publisher ‘%s’, publisher database ‘%s’, publication ‘%s’.
Error: 14136, Severity: 16, The keyword ‘all’ is reserved by replication stored procedures.
Error: 14137, Severity: 16, The @value parameter value must be either ‘true’ or ‘false’.

Error: 14138, Severity: 16, Invalid option name ‘%s’.
Error: 14139, Severity: 16, The replication system table ‘%s’ already exists.
Error: 14143, Severity: 16, Cannot drop Distributor Publisher ‘%s’. There are Subscribers associated with it in the distribution database ‘%s’.
Error: 14144, Severity: 16, Cannot drop Subscriber ‘%s’. There are subscriptions for it in the publication database ‘%s’.
Error: 14146, Severity: 16, The article parameter ‘@schema_option’ cannot be NULL.
Error: 14147, Severity: 16, Restricted publications are no longer supported.
Error: 14148, Severity: 16, Invalid ‘%s’ value. Valid values are ‘true’ or ‘false’.
Error: 14149, Severity: 10, Removed %ld replication history records in %s seconds (%ld row/secs).
Error: 14150, Severity: 10, Replication-%s: agent %s succeeded. %s
Error: 14151, Severity: 18, Replication-%s: agent %s failed. %s
Error: 14152, Severity: 10, Replication-%s: agent %s scheduled for retry. %s

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.

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 *