Troubleshooting
Errors 20000 - 20999
| Error | Severity | Description (Message Text) |
|---|---|---|
| 20001 | 0 | There is no nickname for article '%s' in publication '%s'. |
| 20002 | 0 | The filter '%s' already exists for article '%s' in publication '%s'. |
| 20003 | 0 | Could not generate nickname for '%s'. |
| 20007 | 16 | The system tables for merge replication could not be dropped successfully. |
| 20008 | 16 | The system tables for merge replication could not be created successfully. |
| 20009 | 16 | The article '%s' could not be added to the publication '%s'. |
| 20010 | 16 | The Snapshot Agent corresponding to the publication '%s' could not be dropped. |
| 20011 | 16 | Cannot set incompatible publication properties. The 'allow_anonymous' property of a publication depends on the 'immediate_sync' property. |
| 20012 | 16 | The subscription type '%s' is not allowed on publication '%s'. |
| 20013 | 16 | The publication property '%s' cannot be changed when there are subscriptions on it. |
| 20014 | 16 | Invalid @schema_option value. |
| 20015 | 16 | Could not remove directory '%ls'. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. |
| 20016 | 16 | Invalid @subscription_type value. Valid values are 'pull' or 'anonymous'. |
| 20017 | 16 | The subscription on the Subscriber does not exist. |
| 20018 | 16 | The @optional_command_line is too long. Use an agent definition file. |
| 20019 | 16 | Replication database option '%s' cannot be set unless the database is a publishing database or a distribution database. |
| 20020 | 16 | The article resolver supplied is either invalid or nonexistent. |
| 20021 | 16 | The subscription could not be found. |
| 20023 | 16 | Invalid @subscriber_type value. Valid options are 'local', 'global', 'anonymous', or 'repub'. |
| 20025 | 16 | The publication name must be unique. The specified publication name '%s' has already been used. |
| 20026 | 16 | The publication '%s' does not exist. |
| 20027 | 16 | The article '%s' does not exist. |
| 20028 | 16 | The Distributor has not been installed correctly. Could not enable database for publishing. |
| 20029 | 16 | The Distributor has not been installed correctly. Could not disable database for publishing. |
| 20030 | 16 | The article '%s' already exists on another publication with a different column tracking option. |
| 20031 | 16 | Could not delete the row because it does not exist. |
| 20032 | 16 | '%s' is not defined as a Subscriber for '%s'. |
| 20033 | 16 | Invalid publication type. |
| 20034 | 16 | Publication '%s' does not support '%s' subscriptions. |
| 20036 | 16 | The Distributor has not been installed correctly. |
| 20037 | 16 | The article '%s' already exists in another publication with a different article resolver. |
| 20038 | 16 | The article filter could not be added to the article '%s' in the publication '%s'. |
| 20039 | 16 | The article filter could not be dropped from the article '%s' in the publication '%s'. |
| 20040 | 16 | Could not drop the article(s) from the publication '%s'. |
| 20041 | 16 | Transaction rolled back. Could not execute trigger. Retry your transaction. |
| 20043 | 16 | Could not change the article '%s' because the publication has already been activated. |
| 20044 | 16 | The priority property is invalid for local subscribers. |
| 20045 | 16 | You must supply an article name. |
| 20046 | 16 | The article does not exist. |
| 20047 | 16 | You are not authorized to perform this operation. |
| 20049 | 16 | The priority value should not be larger than 100.0. |
| 20050 | 16 | The retention period must be greater than or equal to %d. |
| 20051 | 16 | The Subscriber is not registered. |
| 20054 | 16 | Current database is not enabled for publishing. |
| 20055 | 16 | Table '%s' cannot be published for merge replication because it has a timestamp column. |
| 20056 | 16 | Table '%s' cannot be republished. |
| 20057 | 16 | The profile name '%s' already exists for the specified agent type. |
| 20058 | 16 | The @agent_type must be 1 (Snapshot), 2 (Logreader), 3 (Distribution), or 4 (Merge) |
| 20059 | 16 | The @profile_type must be 0 (System) or 1 (Custom) |
| 20060 | 16 | Compatibility level cannot be smaller than 60. |
| 20061 | 16 | The compatibility level of this database must be set to 70 or higher to be enabled for merge publishing. |
| 20062 | 16 | Updating columns with the rowguidcol property is not allowed. |
| 20064 | 16 | Cannot drop profile. Either it is not defined or it is defined as the default profile. |
| 20065 | 16 | Cannot drop profile because it is in use. |
| 20066 | 16 | Profile not defined. |
| 20067 | 16 | The parameter name '%s' already exists for the specified profile. |
| 20068 | 16 | The article cannot be created on table '%s' because it has more than %d columns. |
| 20069 | 16 | Cannot validate a merge article that uses looping join filters. |
| 20070 | 16 | Cannot update subscription row. |
| 20072 | 16 | Cannot update Subscriber information row. |
| 20073 | 16 | Articles can be added or changed only at the Publisher. |
| 20074 | 16 | Only a table object can be published as a "table" article for merge replication. |
| 20075 | 16 | The 'status' parameter value must be either 'active' or 'unsynced'. |
| 20076 | 16 | The @sync_mode parameter value must be 'native' or 'character'. |
| 20077 | 16 | Problem encountered generating replica nickname. |
| 20078 | 16 | The @property parameter value must be 'sync_type', 'priority', or 'description'. |
| 20079 | 16 | Invalid @subscription_type parameter value. Valid options are 'push', 'pull', or 'both'. |
| 20081 | 16 | Publication property '%s' cannot be NULL. |
| 20084 | 16 | Publication '%s' cannot be subscribed to by Subscriber database '%s'. |
| 20086 | 16 | Publication '%s' does not support the nosync type because it contains a table that does not have a rowguidcol column. |
| 20087 | 16 | You cannot push an anonymous subscription. |
| 20088 | 16 | Only assign priorities that are greater than or equal to 0 and less than 100. |
| 20089 | 16 | Could not get license information correctly. |
| 20090 | 16 | Could not get version information correctly. |
| 20091 | 16 | sp_mergesubscription_cleanup is used to clean up push subscriptions. Use sp_dropmergepullsubscription to clean up pull or anonymous subscriptions. |
| 20100 | 16 | Cannot drop Subscriber '%s'. There are existing subscriptions. |
| 20500 | 16 | The updatable Subscriber stored procedure '%s' does not exist in sysobjects. |
| 20501 | 16 | Could not insert into sysarticleupdates using sp_articlecolumn. |
| 20502 | 16 | Invalid '%s' value. Valid values are 'read only', 'sync tran', 'queued tran', or 'failover'. |
| 20503 | 16 | Invalid '%s' value in '%s'. The publication is not enabled for '%s' updatable subscriptions. |
| 20505 | 16 | Could not drop synchronous update stored procedure '%s' in '%s'. |
| 20506 | 16 | Source table '%s' not found in '%s'. |
| 20507 | 16 | Table '%s' not found in '%s'. |
| 20508 | 16 | Updatable Subscriptions: The text/ntext/image values inserted at Subscriber will be NULL. |
| 20509 | 16 | Updatable Subscriptions: The text/ntext/image values cannot be updated at Subscriber. |
| 20510 | 16 | Updatable Subscriptions: Cannot update identity columns. |
| 20511 | 16 | Updatable Subscriptions: Cannot update timestamp columns. |
| 20512 | 16 | Updatable Subscriptions: Rolling back transaction. |
| 20515 | 16 | Updatable Subscriptions: Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber. |
| 20516 | 16 | Updatable Subscriptions: Replicated data is not updatable. |
| 20517 | 16 | Updatable Subscriptions: Update of replica's primary key is not allowed unless published table has a timestamp column. |
| 20518 | 16 | Updatable Subscriptions: INSERT and DELETE operations are not supported unless published table has a timestamp column. |
| 20519 | 16 | Updatable Subscriptions: INSERT operations on tables with identity or timestamp columns are not allowed unless a primary key is defined at the Subscriber. |
| 20520 | 16 | Updatable Subscriptions: UPDATE operations on tables with identity or timestamp columns are not allowed unless a primary key is defined at the Subscriber. |
| 20521 | 16 | sp_MSmark_proc_norepl: must be a member of the db_owner or sysadmin roles. |
| 20522 | 16 | sp_MSmark_proc_norepl: invalid object name '%s'. |
| 20523 | 16 | Could not validate the article '%s'. It is not activated. |
| 20524 | 10 | Table '%s' may be out of synchronization. Rowcounts (actual: %s, expected: %s). Rowcount method %d used (0 = Full, 1 = Fast). |
| 20525 | 10 | Table '%s' might be out of synchronization. Rowcounts (actual: %s, expected %s). Checksum values (actual: %s, expected: %s). |
| 20526 | 10 | Table '%s' passed rowcount (%s) validation. Rowcount method %d used (0 = Full, 1 = Fast). |
| 20527 | 10 | Table '%s' passed rowcount (%s) and checksum validation. Checksum is not compared for any text or image columns. |
| 20528 | 10 | Log Reader Agent startup message. |
| 20529 | 10 | Starting agent. |
| 20530 | 10 | Run agent. |
| 20531 | 10 | Detect nonlogged agent shutdown. |
| 20532 | 10 | Replication agent schedule. |
| 20533 | 10 | Replication agents checkup |
| 20534 | 10 | Detects replication agents that are not logging history actively. |
| 20535 | 10 | Removes replication agent history from the distribution database. |
| 20536 | 10 | Replication: agent failure |
| 20537 | 10 | Replication: agent retry |
| 20538 | 10 | Replication: expired subscription dropped |
| 20540 | 10 | Replication: agent success |
| 20541 | 10 | Removes replicated transactions from the distribution database. |
| 20542 | 10 | Detects and removes expired subscriptions from published databases. |
| 20543 | 10 | @rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcounts. 2=new checksum functionality introduced in version 8.0. |
| 20545 | 10 | Default agent profile |
| 20546 | 10 | Verbose history agent profile. |
| 20547 | 10 | Agent profile for detailed history logging. |
| 20548 | 10 | Slow link agent profile. |
| 20549 | 10 | Agent profile for low bandwidth connections. |
| 20550 | 10 | Windows Synchronization Manager profile |
| 20551 | 10 | Profile used by the Windows Synchronization Manager. |
| 20552 | 10 | Could not clean up the distribution transaction tables. |
| 20553 | 10 | Could not clean up the distribution history tables. |
| 20554 | 10 | The agent is suspect. No response within last %ld minutes. |
| 20555 | 10 | 6.x publication. |
| 20556 | 10 | Heartbeats detected for all running replication agents. |
| 20557 | 10 | Agent shutdown. For more information, see the SQL Server Agent job history for job '%s'. |
| 20558 | 10 | Table '%s' passed full rowcount validation after failing the fast check. DBCC UPDATEUSAGE will be initiated automatically. |
| 20559 | 10 | Conditional Fast Rowcount method requested without specifying an expected count. Fast method will be used. |
| 20560 | 10 | An expected checksum value was passed, but checksums will not be compared because rowcount-only checking was requested. |
| 20561 | 10 | Generated expected rowcount value of %s for %s. |
| 20562 | 10 | User delete. |
| 20563 | 10 | No longer belongs in this partial. |
| 20564 | 10 | System delete. |
| 20565 | 10 | Replication: Subscriber has failed data validation |
| 20566 | 10 | Replication: Subscriber has passed data validation |
| 20567 | 10 | Agent history clean up: %s |
| 20568 | 10 | Distribution clean up: %s |
| 20569 | 10 | Expired subscription clean up |
| 20570 | 10 | Reinitialize subscriptions having data validation failures |
| 20571 | 10 | Reinitializes all subscriptions that have data validation failures. |
| 20572 | 10 | Subscriber '%s' subscription to article '%s' in publication '%s' has been reinitialized after a validation failure. |
| 20573 | 10 | Replication: Subscription reinitialized after validation failure |
| 20574 | 10 | Subscriber '%s' subscription to article '%s' in publication '%s' failed data validation. |
| 20575 | 10 | Subscriber '%s' subscription to article '%s' in publication '%s' passed data validation. |
| 20576 | 10 | Subscriber '%s' subscription to article '%s' in publication '%s' has been reinitialized after a synchronization failure. |
| 20577 | 10 | No entries were found in msdb..sysreplicationalerts. |
| 20578 | 10 | Replication: agent custom shutdown |
| 20579 | 10 | Generated expected rowcount value of %s and expected checksum value of %s for %s. |
| 20580 | 10 | Heartbeats not detected for some replication agents. The status of these agents have been changed to 'Failed'. |
| 20581 | 10 | Cannot drop server '%s' because it is used as a Distributor in replication. |
| 20582 | 10 | Cannot drop server '%s' because it is used as a Publisher in replication. |
| 20583 | 10 | Cannot drop server '%s' because it is used as a Subscriber in replication. |
| 20584 | 10 | Cannot drop server '%s' because it is used as a Subscriber to remote Publisher '%s' in replication. |
| 20585 | 16 | Validation Failure. Object '%s' does not exist. |
| 20586 | 16 | (default destination) |
| 20587 | 16 | Invalid '%s' value for stored procedure '%s'. |
| 20588 | 16 | The subscription is not initialized. Run the Distribution Agent first. |
| 20589 | 10 | Agent profile for replicated queued transaction reader. |
| 20590 | 16 | The article property 'status' cannot include bit 64, 'DTS horizontal partitions' because the publication does not allow data transformations. |
| 20591 | 16 | Only 'DTS horizontal partitions' and 'no DTS horizontal partitions' are valid 'status' values because the publication allows data transformations. |
| 20592 | 16 | 'dts horizontal partitions' and 'no dts horizontal partitions' are not valid 'status' values because the publication does not allow data transformations. |
| 20593 | 16 | Cannot modify publication '%s'. The sync_method cannot be changed to 'native', 'concurrent' or 'concurrent_c' because the publication has subscriptions from ODBC or OLE DB Subscribers. |
| 20594 | 16 | A push subscription to the publication exists. Use sp_subscription_cleanup to drop defunct push subscriptions. |
| 20595 | 16 | Skipping error signaled. |
| 20596 | 16 | Only '%s' or members of db_owner can drop the anonymous agent. |
| 20597 | 10 | Dropped %d anonymous subscription(s). |
| 20598 | 16 | The row was not found at the Subscriber when applying the replicated command. |
| 20599 | 16 | Continue on data consistency errors. |
| 20600 | 10 | Agent profile for skipping data consistency errors. It can be used only by SQL Server Subscribers. |
| 20601 | 10 | Invalid value specified for agent parameter 'SkipErrors'. |
| 20602 | 10 | The value specified for agent parameter 'SkipErrors' is too long. |
| 20603 | 10 | The agent profile cannot be used by heterogeneous Subscribers. |
| 20604 | 10 | You do not have permissions to run agents for push subscriptions. Make sure that you specify the agent parameter 'SubscriptionType'. |
| 20605 | 10 | Invalidated the existing snapshot of the publication. Run the Snapshot Agent again to generate a new snapshot. |
| 20606 | 10 | Reinitialized subscription(s). |
| 20607 | 10 | Cannot make the change because a snapshot is already generated. Set @force_invalidate_snapshot to 1 to force the change and invalidate the existing snapshot. |
| 20608 | 10 | Cannot make the change because there are active subscriptions. Set @force_reinit_subscription to 1 to force the change and reinitialize the active subscriptions. |
| 20609 | 16 | Cannot attach subscription file '%s'. Make sure that it is a valid subscription copy file. |
| 20610 | 16 | Cannot run '%s' when the Log Reader Agent is replicating the database. |
| 20611 | 16 | Only table or indexed view to table articles are allowed in publications that allow DTS. |
| 20612 | 16 | Checksum validation is not supported because the publication allows DTS. Use row count only validation. |
| 20613 | 16 | Validation is not supported for articles that are set up for DTS horizontal partitions. |
| 20614 | 16 | Validation is not supported for heterogeneous Subscribers. |
| 20616 | 10 | High Volume Server-to-Server Profile |
| 20617 | 10 | Merge agent profile optimized for the high volume server-to-server synchronization scenario. |
| 20618 | 16 | You must have CREATE DATABASE permission to attach a subscription database. |
| 20619 | 16 | Server user '%s' is not a valid user in database '%s'. Add the user account or 'guest' user account into the database first. |
| 20620 | 11 | The security mode specified requires the server '%s' in sysservers. Use sp_addlinkedserver to add the server. |
| 20621 | 11 | Cannot copy a subscription database to an existing database. |