Hi all,
I have just encountered this weird issue with our Merge Replication Setup.
We have a primary sql server 2012 replicating data out to another secondary sql server 2012 database (pushing data continuously).
Then we have subscribers (users) synchronize data to the secondary database server (pull subscription, bi-directional sync).
We use parameterized filter (suser_sname) and joined filters on a few tables.
We have the following set up as seen in the attachment
At the subscribers (user's machine), i created a new record of customer which also created customer_contact,contact,pwc_header,pwc_header_extra,pwc_line,site records (one row for each table).
Then i sync the Subscriber with the Publisher. All the inserts were inserted into the Publishers (secondary database server and primary database server) correctly.
However, the inserts were deleted from the subscribers straightaway in the same sync session and we had no idea why it would do that. 😉
Has anyone encountered the similar issue before? Please help...