3

I set up merge replication with SQL Server 2008, I am having issues when creating new data on clients and trying to synchronize with the remote server.

Pulling data from the server works fine. But when adding new data from the clients and synchronizing, I get conflicts for the publication updates with error in conflict manager:

Upload inserts failed.

This failure can be caused by a constraint violation. Invalid object name 'dbo.MSmerge_repl_view_CCEBB5FB95354A40940D433C94AAAF3E_FF89BB83CC734065B74175EFC3B6E922'.

I found that dbo.MSmerge_repl_view_... is a system view but I am guessing it is from the client since I cannot find it on the server.

I don't get why this is happening. Is the data being uploaded to the view (which doesn't exist on the server) ? if someone can explain why this might happen it would be great !

Improve this question

1 Answer 1

Reset to default
1

That view is created by replication and used internally. If it is missing, either it got deleted accidentally, or sql servers replication metadata got corrupted.

Depending on how big you databases are and if you can afford some downtime, the easiest way to fix this is to drop and recreate the merge replication setup.

Improve this answer
2
  • hmmm that seems to be annoying !! if so how would one make it to avoid corruption ? the database is pretty big and I would prefer not taking it down but would like to get an idea about both corrective and preventive measures if you have had xperience with this.
    – Anthony
    Nov 20, 2013 at 18:24
  • btw I did recreate the setup but now I am getting a similar conflict: This failure can be caused by a constraint violation. Could not find stored procedure 'dbo.MSmerge_expand_sp_A74.....'.
    – Anthony
    Nov 20, 2013 at 18:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.