Errors and Events Reference (Replication)

This section of the documentation contains cause and resolution information for a number of errors related to replication.

Error Message
MSSQL_ENG002601 Cannot insert duplicate key row in object '%.ls' with unique index '%.\ls'.
MSSQL_ENG002627 Violation of %ls constraint '%.ls'. Cannot insert duplicate key in object '%.\ls'.
MSSQL_ENG003165 Database '%ls' was restored, however an error was encountered while replication was being restored/removed. The database has been left offline. See the topic MSSQL_ENG003165 in SQL Server Books Online.
MSSQL_ENG003724 Cannot %S_MSG the %S_MSG '%.*ls' because it is being used for replication.
MSSQL_ENG004929 Cannot alter the %S_MSG '%.*ls' because it is being published for replication.
MSSQL_ENG007395. See Troubleshooting Oracle Publishers. Unable to start a nested transaction for OLE DB provider "%ls" for linked server "%ls". A nested transaction was required because the XACT_ABORT option was set to OFF.
MSSQL_ENG014005 Could not drop publication. A subscription exists to it.
MSSQL_ENG014010 The server '%s' is not defined as a subscription server.
MSSQL_ENG014114 '%s' is not configured as a Distributor.
MSSQL_ENG014117 '%s' is not configured as a distribution database.
MSSQL_ENG014120 Could not drop the distribution database '%s'. This distributor database is associated with a Publisher.
MSSQL_ENG014121 Could not drop the Distributor '%s'. This Distributor has associated distribution databases.
MSSQL_ENG014144 Cannot drop Subscriber '%s'. There are subscriptions for it in the publication database '%s'.
MSSQL_ENG014150 Replication-%s: agent %s succeeded. %s
MSSQL_ENG014151 Replication-%s: agent %s failed. %s
MSSQL_ENG014152 Replication-%s: agent %s scheduled for retry. %s
MSSQL_ENG014157 The subscription created by Subscriber '%s' to publication '%s' has expired and has been dropped.
MSSQL_ENG014160 The threshold [%s:%s] for the publication [%s] has been set. One or more subscriptions to this publication have expired.
MSSQL_ENG014161 The threshold [%s:%s] for the publication [%s] has been set. Make sure that the logreader and distribution agents are running and can match the latency requirement.
MSSQL_ENG014162 The threshold [%s:%s] for the publication [%s] has been set. Please make sure that the merge agent is running and can match the expected requirement.
MSSQL_ENG014163 The threshold [%s:%s] for the publication [%s] has been set. Please make sure that the merge agent is running and can match the expected requirement.
MSSQL_ENG014164 The threshold [%s:%s] for the publication [%s] has been set. Please make sure that the merge agent is running and can match the expected requirement.
MSSQL_ENG014165 The threshold [%s:%s] for the publication [%s] has been set. Please make sure that the merge agent is running and can match the expected requirement.
MSSQL_ENG018456 Login failed for user '%.ls'.%.\ls
MSSQL_ENG018752 Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure.
MSSQL_ENG020554 The replication agent has not logged a progress message in %ld minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.
MSSQL_ENG020557 Agent shutdown. For more information, see the SQL Server Agent job history for job '%s'.
MSSQL_ENG020572 Subscriber '%s' subscription to article '%s' in publication '%s' has been reinitialized after a validation failure.
MSSQL_ENG020574 Subscriber '%s' subscription to article '%s' in publication '%s' failed data validation.
MSSQL_ENG020575 Subscriber '%s' subscription to article '%s' in publication '%s' passed data validation.
MSSQL_ENG020596 Only '%s' or members of db_owner can drop the anonymous agent.
MSSQL_ENG020598 The row was not found at the Subscriber when applying the replicated command.
MSSQL_ENG021075 The initial snapshot for publication '%s' is not yet available.
MSSQL_ENG021076 The initial snapshot for article '%s' is not yet available.
MSSQL_ENG021286 Conflict table '%s' does not exist.
MSSQL_ENG021330 Failed to create a sub-directory under the replication working directory.(%ls)
MSSQL_ENG021331 Failed to copy user script file to the Distributor.(%ls)
MSSQL_ENG021385 Snapshot failed to process publication '%s'. Possibly due to active schema change activity or new articles being added.
MSSQL_ENG021617. See Troubleshooting Oracle Publishers. Unable to run SQL*PLUS. Make certain that a current version of the Oracle client code is installed at the distributor.
MSSQL_ENG021620. See Troubleshooting Oracle Publishers. The version of SQL*PLUS that is accessible through the system Path variable is not current enough to support Oracle publishing. Make certain that a current version of the Oracle client code is installed at the distributor.
MSSQL_ENG021624. See Troubleshooting Oracle Publishers. Unable to locate the registered Oracle OLEDB provider, OraOLEDB.Oracle, at distributor '%s'. Make certain that a current version of the Oracle OLEDB provider is installed and registered at the distributor.
MSSQL_ENG021626. See Troubleshooting Oracle Publishers. Unable to connect to Oracle database server '%s' using the Oracle OLEDB provider OraOLEDB.Oracle.
MSSQL_ENG021627. See Troubleshooting Oracle Publishers. Unable to connect to Oracle database server '%s' using the Microsoft OLEDB provider MSDAORA.
MSSQL_ENG021628. See Troubleshooting Oracle Publishers. Unable to update the registry of distributor '%s' to allow Oracle OLEDB provider OraOLEDB.Oracle to run in process with SQL Server. Make certain that current login is authorized to modify SQL Server owned registry keys.
MSSQL_ENG021629. See Troubleshooting Oracle Publishers. The CLSID registry key indicating that the Oracle OLEDB Provider for Oracle, OraOLEDB.Oracle, has been registered is not present at the distributor. Make certain that the Oracle OLEDB provider is installed and registered at the distributor.
MSSQL_ENG021642. See Troubleshooting Oracle Publishers. Heterogeneous publishers require a linked server. A linked server named '%s' already exists. Please remove linked server or choose a different publisher name.
MSSQL_ENG021663. See Troubleshooting Oracle Publishers. No valid primary key found for source table [%s].[%s].
MSSQL_ENG021684. See Troubleshooting Oracle Publishers. The permissions associated with the administrator login for Oracle publisher '%s' are not sufficient.
MSSQL_ENG021797 '%s' must be a valid Windows Login in the form: 'MACHINE\Login' or 'DOMAIN\Login'. Please see the documentation for '%s'.
MSSQL_ENG021798 The '%s' agent job must be added via '%s' before continuing. Please see the documentation for '%s'.
MSSQL_REPL020011 The process could not execute '%1' on '%2'.
MSSQL_REPL027056 The merge process was unable to change generation history at the '%1'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
MSSQL_REPL027183 The merge process failed to enumerate changes in articles with parameterized row filters. If this failure continues, increase the query timeout for this process, reduce the retention period for the publication, and improve indexes on published tables.