.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Melody Anderson
Post New Web Links

error in merge replication

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Hi ALL,      I have merge replication configured between republishers( sql 2008) and subscribers( sql 2000)...i am getting the following error while trying to sync   The merge process could not update the list of subscriptions. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201010) Get help: http://help/MSSQL_REPL-2147201010 Cannot insert duplicate key row in object 'dbo.sysmergesubscriptions' with unique index 'uc1sysmergesubscriptions'. (Source: MSSQLServer, Error number: 2601) Get help: http://help/2601 The subscription could not be created. (Source: MSSQLServer, Error number: 14057)   Any suggestions y i am getting this error TIA

View Complete Post

More Related Resource Links

Merge replication error

Hi ALL,  I have merge replication configured on sql server 2008. After two weeks snapshot agent ran again and when merge agent is running it throwing error you must rerun snapshot because current snapshot files are obsolete i dnt change anything on publication or snapshot folder location but still i am getting error   Any suggestion...TIA

How to view merge replication error (sql 2005)


We're using 2005 merge replication and we found that some records deletion cannot synchronize from publisher table to other subscriber table. (This table have very small size(<1000 records). We want to view those replication system tables or any logs for diagnostics this serious problem. Can you suggest any replication system table or logs that can indicate the reasons or hints of records deletion outsync?

Thanks and regards,

Merge Replication: Web Sync error 28011 with Basic Authentication on WinCE 6.0



I configured merge replication using SQL Server 2005 SP3 running on Windows Server 2008 R2 x64 with IIS 7.

My client is a .NET Compact 3.5 (RTM) application running on an embedded controller (Beckhoff CX1000) with Windows CE 6.0 installed. I am using SQL Compact 3.5 SP1 on the client. The preconfigured Win CE only had .NET Compact 2.0 installed, so I installed version 3.5 on the CompactFlash card attached to the controller.

Syncing over HTTP works perfecly using anonymous authentication.

I then executed the Web Sync Config Wizard and configured Basic Authentication without SSL. For authentication I use a local account even though my server is a member of our domain. The same account is used for access to the publication and distribution DBs (all located on the same server running IIS).

When I ran my client trying to sync, all I get is the 28011 error (Authentication failed).

The strange thing is that a test application on my desktop machine using .NET 3.5 (not Compact) can sync without problems. I even wrote a little test application for the embedded controller using the .NET HttpWebRequest object to connect to the server and I get the expected "Microsoft SQL Server Compact Server Agent" message.

I dug a little deeper into the issue and analyzed the HTTP packet getting sent to the server (using Wireshark). App

Merge Replication - Error - Query processor ran out of stack space


Hello everyone,

I have a merge publication configured that has been running fine with no issues for many weeks.  Here is my setup... Publisher - SQL 2008 SP1, Distributor - SQL 2008 R2, Subscriber - SQL 2008 SP1.

On Wednesday and Thursday of last week, I created a few hundred foreign keys referencing a table (user information for auditing).  Then, on Friday evening, I started to receive this message:



Msg 8621, Level 17, State 1, Procedure MSmerge_sel_sp_18DB84E1A521483601D2A6D477F6483D, Line 85
The query processor ran out of stack space during query optimization. Please simplify the query.



I have traced it down, this command gets executed:


exec MSmerge_sel_sp_18DB84E1A521483601D2A6D477F6483D @maxschemaguidforarticle = 'F990B1EE-D52F-4DCA-8EEF-C1783DA47A0F', @type = 6


Which executes this:



Merge Replication Error...



Please find the error while merge replication at Pull type from Subscriptions...

Using SQL server 2008 r2

Subscriptions type:Pull Merge type

Briefing: We have created new table at publisher and trying to sync at Subscribers using pull Mege subscriptions, it got sync perfectly for rest of the systems but in one system i was having issue,,,,


2010-10-28 21:50:26.329 [26%] [0 sec remaining] Preparing table 'FullSheet' for merge replication
2010-10-28 21:50:46.923 [66%] [10 sec remaining] Bulk copying data into table 'sysmergesubsetfilters'
2010-10-28 21:50:48.267 The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify a
utput file to which to write.
2010-10-28 21:50:48.595 Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file t
hich to write.
2010-10-28 21:50:

SQL SErver 2008 Merge Replication: Alter Trigger cause syntax error on subscriber site


I have 2 clustered instances running on SQL Server 2008 SE-64 patch level 10.0.2531.0. These is one DB on these 2 instances (compatibility_level=80)under merge replication. now I need to change one trigger to add "NOT FOR REPLICATION". One publisher site all is ok but on subscriber site it causes Error 102 Severity 15 State 1 Incorrect Syntax near 'dbo'.

After tracing the error in profiler, I captured the incorrect syntax as below:

exec('ALTER TRIGGER [dbo].[trgBusinessEntityAllocationUpdate] on [dbo].[BusinessEntityAllocation] 

obviously, there is an duplicated part of object name. but the script was generated by replication engine. How could it happened? can anyone help?



George the DBA

SQL 2005 merge replication error


We have one customer that has two subscribers with the one distributor. there are three publications being merged. two of them are fine, but one publication is receiving an error:

The merge process was unable to access row metadata at the 'Subscriber'.

it seems to be from one table because the next error is for that table and to check the permissions. i know they are correct because i can access the table fine from SSMS.

Does anyone have any suggestions to start debugging this?



Merge Replication Error: "No key matching the described characteristics could be found within the cu

hi, I'm facing this error : "No key matching the described characteristics could be found within the current range" In replicaiton process between SQL Server 2008 SP1 and Client with SQL server compact 3.5 SP1. I found some information in other post : http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/67cbfa60-1cee-4a60-aacc-8c1c60c27467 http://social.msdn.microsoft.com/forums/en-us/sqlreplication/thread/66895DB2-A273-4193-8F68-D43736BF9227 and a hot fix : http://support.microsoft.com/kb/974068 But no one solved the issue. In SQL server i have a publication with 162 articles. Replication Monitor tell me that all is ok. But client log file indicate me the error. Last time we encountered the issue, we deleted the subscription and recreate it. But for me it is not a solution because we lost all history of the subscription. Thanks for any answer that you can give to me. Regards Julien

Merge Replication Error: "No key matching the described characteristics could be found within the cu

I am synchronising a SQL Compact Edition 3.5 Database against a SQL Server 2005 Server wirh Merge-Replication.
That worked fine for some time. Now I'm getting the following error message on the client machine after replicating some tables successfully:

No key matching the described characteristics could be found within the current range.|
   at System.Data.SqlServerCe.SqlCeReplication.EndSynchronize(IAsyncResult ar)
   at ITM.Base3.DB.SqlCe.SqlCeReplicationManager.SyncCompletedCallBack(IAsyncResult ar) in S:\...\DB\SqlCe\SqlCeReplicationManager.cs:line 272

On the webserver in "SQLCESALOG.TXT" I get:

2009/04/02 17:53:32 Thread=1578 RSCB=22 Command=FTCH Hr=00000000 ERR:Existing RSCB with same ExchangeID but different dwCommand 1
2009/04/02 17:53:32 Hr=80004005 ERR:REQUEST NOT QUEUED for ulRSCBId =  0
2009/04/02 17:53:33 Hr=80004005 ERR:No preceding Open command for command =  3
2009/04/02 17:53:33 Hr=80004005 ERR:REQUEST NOT QUEUED for ulRSCBId =  0
2009/04/02 17:53:34 Hr=80004005 ACK:Error for DistributorSessionID =  361
2009/04/02 17:53:34 Hr=80004005  0

The SQL Server tells me, that the synchronisation was OK.
I tried to reinitialize the subscriptions with no luck.
Sadly, this error messages are telling me nothing at all.

Any advises?
Thank you!

SQL Server 2008 R2 Merge error in Replication agents checkup job


We have a customer with three publications, one distributor/publisher and on subscriber using merge replication.

looking at the history of the job replication agents checkup, every entry shows a message of:

Executed as user: NT AUTHORITY\SYSTEM. The replication agent has not logged a progress message in 10 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. [SQLSTATE 01000] (Message 20554).  The step succeeded.


Throughout the day this error still appears as this job runs every 10 minutes but replication works fine. The issue is at some point throughout the night the replication stops with that same message. Sometimes it stops at 6:00:00am, sometimes at 6:40:00am, others at 6:50:00am. All we have to do to fix it is go into the replication monitor and stop synchronizing and then start synchronizing and replication will run all day until it stops next morning - again.

What is causing that error message? I have checked the other logs and there is nothing running at those times. in addition, no one has logged into the server that early (they don't start arriving until 7:15 or later).

What can i do to correct the issue so the message stops happening.


Merge Replication Error (8114)


HI all,

I have configure the merge replication in sql server 2008, after few days the below error i have find in the replication monitor, how to solve this issues i took same database bakcup and restore and start replication.

Error messages:
Error converting data type nvarchar to numeric. (Source: MSSQLServer, Error number: 8114)
Get help: http://help/8114

Please give me the solution, where is the error and how to fix it?

Thanks, Prasad.

Merge Replication - Subscription Error


Hi All,


I get this error when I try to run the sync on a subscription. I found that this actually has something to do with permissions.

“ String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed

If the account I am using is a server sysadmin does it still have to be part of the db_owner in publication and distribution dbs as shown below? It has write access to the file share as well so I am not sure I understand what the problem is? It is also a sysadmin on the client where the subscription is going?




sql 2005 merge replication replicate 65 GB binary and cause "MSSQL_REPL20216 due to OS error 2"



We're using sql 2005 ent merge replication (SP2) and replicate 65GB binary data. However, after merge job running around 60 hours and nearly finished, it has the error messages like this :

From distribution.msrepl_errors and distribution.msmerge_history:

"The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an outfile to write" (Error Number: MSSQL_REPL-2147201001)

"The process could not read file "E:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\ReplData\unc\IMDNACMPS33_MPSERVER_MPSERVER\20110411220596\NoticeInfo_2.cft" due to OS Error 2(Error Number: MSSQL_REPL20216)


Please note that the above messages kept continuously appear in both event viewer and system tables between 1 minutes. Any suggestions or help to fix this?? Do I need to click 'stop synchronizing' and click 'start synchronizing' to restart the merge job again or click 'reinit subscription'? An urgent response is indeed necessary for this case. Thanks a lot.

Thanks and regards,

P.S: for your reference please find the attached error photo

Merge replication metadata deletion error MSSQL_REPL-2147199402


I setup merge replication about 3 weeks ago between a few databases all running SQL 2008 SP1:

  • DB1 - This database is the publisher and distributor.
  • DB2 - This database is a write-only subscriber (-EXCHANGETYPE 1) to DB1.
  • DB3 - This database is a write-only subscriber (-EXCHANGETYPE 1) to DB1.
  • DB4 - This database is a write-only subscriber (-EXCHANGETYPE 1) to DB1.
  • DB5 - This database is a read-only subscriber (-EXCHANGETYPE 2) to DB1.
  • DB6 - This database is a read-only subscriber (-EXCHANGETYPE 2) to DB1.

Everything was running fine, then suddenly one at a time the replication jobs for DB2, DB3, and DB4 all started reporting the error:

The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)

I was able to manually upload data from DB2, DB3, and DB4 to DB1 then reinitialize the subscriptions.  However, I don't understand why only those three subscriptions failed.  I have other merge replication jobs between the same SQL instances that are still running fine.  The only unique thing I can determine about the f

Intermittent SqlCeException error 25123 when starting merge replication


Hello folks!


This is a long and detailed post, I realize it is quite a mouthful but I decided that it was best to provide as much detail as possible to increase the chances of someone being able to shine some light on the subject for us.


To begin with, some background info:

·         We are building a Windows Mobile application called GuardTools Mobile to be used in the field by security guards.

merge replication system tables fragmentation issue

I have Merge replication going on in my environment. The problem is that system tables like MSmerge_content, MS merge _tombstone and MSmerge_genhistory are getting fragmented. We are rebuilding indexes time to time daily. But we want some good fix. Just send some good idea guys?

Steps by Step document for configuration Merge Replication in 2005

Hi , Can anyone provide link to configure Merge Replication in 2005 with print screen.Also let me know the difference between Transcation level and Merge Replication. regards Vijay  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend