Reputation: 63
Can anyone please help me out to solve this error in SQL Server merge replication?
The merge process could not replicate one or more INSERT statements to the 'Subscriber'. A stored procedure failed to execute. Troubleshoot by using SQL Profiler. (Source: MSSQLServer, Error number: -2147200990)
A query executing on Subscriber 'DB-TEST' failed because the connection was chosen as the victim in a deadlock. Please rerun the merge process if you still see this error after internal retries by the merge process. (Source: MSSQLServer, Error number: 20245)
Cannot issue SAVE TRANSACTION when there is no active transaction. (Source: MSSQLServer, Error number: 628)
Upvotes: 1
Views: 1572
Reputation: 63
Thanks for considering my question, Your response showing that you haven't faced this error in your environment. i just resolved mentioned issue by creating missing indexes on replication system tables like "Msmerge_content, Msmerge_tombstone, Msmerge_genhistory.....Msmerge....etc." after making missing indexes on replication system tables it run faster like a charm. so at conclusion if any one faces above mentioned error should take a look on missing indexes on replication system tables. Thank you. –
Upvotes: 1