SQL Server Errors or Failures from Error: 21766 to Error: 21785
Error: 21766, Severity: 16, Table %s contains an identity column that is marked as Not For Replication, but the @identitymanagementoption parameter of sp_addarticle is set to ‘none’. To support immediate updating subscriptions, specify a value of ‘manual’ or ‘auto’ for @identityman
Error: 21767, Severity: 10, Warning: The parameter ‘%s’ is obsolete and is available only for backwards compatibility. It will not be available in future releases. Instead of this parameter, use the parameter ‘%s’.
Error: 21768, Severity: 16, When executing sp_adddistributor for a remote Distributor, you must use a password. The password specified for the @password parameter must be the
same when the procedure is executed at the Publisher and at the Distributor.
Error: 21769, Severity: 10, Custom data type mappings are not supported. You must validate the correctness of the mapping. If mappings are not compatible, errors will likely occur when moving data from the Publisher to the Subscriber.
Error: 21770, Severity: 10, Data type mapping from ‘%s’ to ‘%s’ does not exist. Review source and destination data type, length, precision, scale, and nullability. Query the system table msdb.dbo.sysdatatypemappings for a list of supported mappings.
Error: 21771, Severity: 16, %s is not within the supported range of %d and %d.
Error: 21772, Severity: 16, Property “%s” requires the parameters @force_invalidate_snapshot and @force_reinit_subscription to be set to “true”.
Error: 21773, Severity: 10, The distribution database ‘%s’ cannot be opened due to inaccessible files. The database will be dropped, but distribution database cleanup tasks will not occur. Check the database and server error logs for more information about why the database files can
Error: 21774, Severity: 16, This procedure is supported only for non-SQL Server Publishers. The Publisher ‘%s’, on which you are executing the procedure, is a SQL Server Publisher.
Error: 21775, Severity: 16, Failed to generate column bitmap for article ‘%s’.
Error: 21776, Severity: 16, Failed to generate published column bitmap for article ‘%s’.
Error: 21777, Severity: 16, Failed to generate article view name for article ‘%s’.
Error: 21778, Severity: 16, Cannot add Publisher objects to the Oracle Publisher for article ‘%s’. Verify connection information and ensure that you can connect to the Publisher through a tool like SQL*PLUS. Ensure that the replication administrative user schema has the required per
Error: 21779, Severity: 10, Cannot use the specified data type mapping. The matching destination data type for source type %s cannot be found. Query the system table msdb.dbo.sysdatatypemappings for a list of supported mappings. Verify that the length, precision, scale, and nullabil
Error: 21780, Severity: 16, The non-SQL Server Publisher is missing one or more %s objects. Drop and re-create the Publisher and the replication administrative user schema.
Error: 21781, Severity: 16, Unable to retrieve heterogeneous metadata. Verify connection information
Error: 21782, Severity: 16, Cannot add primary key column ‘%s’ to article ‘%s’. If the Publisher is a non-SQL Server Publisher, the primary key could have violated SQL Server limits for number and length of columns. For more information, see errors returned by sp_addarticle.
Error: 21783, Severity: 16, Cannot add the Publisher triggers and the article log table to the Oracle Publisher for the article ‘%s’. Verify connection information and ensure that you can connect to the Publisher through a tool like SQL*PLUS. Ensure that the replication administrati
Error: 21784, Severity: 16, You must specify a non-NULL value for the @rowfilter parameter.
Error: 21785, Severity: 16, Failure to query Oracle XactSet Job attributes for publisher ‘%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.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.