Cause and Resolution of Replication Errors
This section of the documentation contains cause and resolution information for a number of errors related to replication.
| Error | Message |
|---|---|
Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'. |
|
Violation of %ls constraint '%.*ls'. Cannot insert duplicate key in object '%.*ls'. |
|
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. |
|
Cannot %S_MSG the %S_MSG '%.*ls' because it is being used for replication. |
|
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. |
Could not drop publication. A subscription exists to it. |
|
The server '%s' is not defined as a subscription server. |
|
'%s' is not configured as a Distributor. |
|
'%s' is not configured as a distribution database. |
|
Could not drop the distribution database '%s'. This distributor database is associated with a Publisher. |
|
Could not drop the Distributor '%s'. This Distributor has associated distribution databases. |
|
Cannot drop Subscriber '%s'. There are subscriptions for it in the publication database '%s'. |
|
Replication-%s: agent %s succeeded. %s |
|
Replication-%s: agent %s failed. %s |
|
Replication-%s: agent %s scheduled for retry. %s |
|
The subscription created by Subscriber '%s' to publication '%s' has expired and has been dropped. |
|
The threshold [%s:%s] for the publication [%s] has been set. One or more subscriptions to this publication have expired. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
Login failed for user '%.*ls'.%.*ls |
|
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. |
|
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. |
|
Agent shutdown. For more information, see the SQL Server Agent job history for job '%s'. |
|
Subscriber '%s' subscription to article '%s' in publication '%s' has been reinitialized after a validation failure. |
|
Subscriber '%s' subscription to article '%s' in publication '%s' failed data validation. |
|
Subscriber '%s' subscription to article '%s' in publication '%s' passed data validation. |
|
Only '%s' or members of db_owner can drop the anonymous agent. |
|
The row was not found at the Subscriber when applying the replicated command. |
|
The initial snapshot for publication '%s' is not yet available. |
|
The initial snapshot for article '%s' is not yet available. |
|
Conflict table '%s' does not exist. |
|
Failed to create a sub-directory under the replication working directory.(%ls) |
|
Failed to copy user script file to the Distributor.(%ls) |
|
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. |
'%s' must be a valid Windows Login in the form: 'MACHINE\Login' or 'DOMAIN\Login'. Please see the documentation for '%s'. |
|
The '%s' agent job must be added via '%s' before continuing. Please see the documentation for '%s'. |
|
A required privilege is not held by the client. |
|
The process could not execute '%1' on '%2'. |
|
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. |
|
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. |
See Also
Other Resources
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
12 December 2006 |
|
17 July 2006 |
|
14 April 2006 |
|