Export (0) Print
Expand All
3 out of 12 rated this helpful - Rate this topic

Cause and Resolution of Replication Errors

Updated: 12 December 2006

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. For addition information, see SQL Server Error 21624 in Troubleshooting Oracle Publishers in SQL Server Books Online.

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 replication administrative user for Oracle Publisher "%s" has insufficient permissions. Refer to the script /MSSQL/Install/oracleadmin.sql for the required permissions.

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_ENG024070

A required privilege is not held by the client.

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.

Release History

12 December 2006

New content:
  • Added error message MSSQL_ENG021684.

17 July 2006

New content:
  • Added the following error messages:
    • MSSQL_ENG014150
    • MSSQL_ENG014152
    • MSSQL_ENG014160
    • MSSQL_ENG014161
    • MSSQL_ENG014162
    • MSSQL_ENG014163
    • MSSQL_ENG014164
    • MSSQL_ENG014165
    • MSSQL_ENG020557
    • MSSQL_ENG020572
    • MSSQL_ENG020574
    • MSSQL_ENG020575

14 April 2006

New content:
  • Added error message MSSQL_ENG024070.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.