Errors and Events Reference
Collapse the table of content
Expand the table of content

Errors and Events Reference (Replication)

 

Applies To: SQL Server 2016

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

ErrorMessage
MSSQL_ENG002601Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'.
MSSQL_ENG002627Violation of %ls constraint '%.*ls'. Cannot insert duplicate key in object '%.*ls'.
MSSQL_ENG003165Database '%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_ENG003724Cannot %S_MSG the %S_MSG '%.*ls' because it is being used for replication.
MSSQL_ENG004929Cannot 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_ENG014005Could not drop publication. A subscription exists to it.
MSSQL_ENG014010The 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_ENG014120Could not drop the distribution database '%s'. This distributor database is associated with a Publisher.
MSSQL_ENG014121Could not drop the Distributor '%s'. This Distributor has associated distribution databases.
MSSQL_ENG014144Cannot drop Subscriber '%s'. There are subscriptions for it in the publication database '%s'.
MSSQL_ENG014150Replication-%s: agent %s succeeded. %s
MSSQL_ENG014151Replication-%s: agent %s failed. %s
MSSQL_ENG014152Replication-%s: agent %s scheduled for retry. %s
MSSQL_ENG014157The subscription created by Subscriber '%s' to publication '%s' has expired and has been dropped.
MSSQL_ENG014160The threshold [%s:%s] for the publication [%s] has been set. One or more subscriptions to this publication have expired.
MSSQL_ENG014161The 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_ENG014162The 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_ENG014163The 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_ENG014164The 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_ENG014165The 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_ENG018456Login failed for user '%.*ls'.%.*ls
MSSQL_ENG018752Only 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_ENG020554The 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_ENG020557Agent shutdown. For more information, see the SQL Server Agent job history for job '%s'.
MSSQL_ENG020572Subscriber '%s' subscription to article '%s' in publication '%s' has been reinitialized after a validation failure.
MSSQL_ENG020574Subscriber '%s' subscription to article '%s' in publication '%s' failed data validation.
MSSQL_ENG020575Subscriber '%s' subscription to article '%s' in publication '%s' passed data validation.
MSSQL_ENG020596Only '%s' or members of db_owner can drop the anonymous agent.
MSSQL_ENG020598The row was not found at the Subscriber when applying the replicated command.
MSSQL_ENG021075The initial snapshot for publication '%s' is not yet available.
MSSQL_ENG021076The initial snapshot for article '%s' is not yet available.
MSSQL_ENG021286Conflict table '%s' does not exist.
MSSQL_ENG021330Failed to create a sub-directory under the replication working directory.(%ls)
MSSQL_ENG021331Failed to copy user script file to the Distributor.(%ls)
MSSQL_ENG021385Snapshot 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_ENG021798The '%s' agent job must be added via '%s' before continuing. Please see the documentation for '%s'.
MSSQL_REPL020011The process could not execute '%1' on '%2'.
MSSQL_REPL027056The 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_REPL027183The 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.

Community Additions

ADD
Show:
© 2016 Microsoft