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 !