Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 !

share|improve this question

1 Answer 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.

share|improve this answer
    
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 '13 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 '13 at 18:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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