Post reply

Data Deleting at Subscriber after uploading to Publisher

  • June 22, 2016 at 10:52 am

    #400309

    Hi,

    I have a strange issue with Merge Replication.

    When I add a new row in my subscriber database, that new row gets replicated to publisher and immediately gets deleted from subscriber.

    I did cross check the new row still exists in publisher but only deleting in subscriber.

    I suspect something with triggers or FK, but not sure how to proceed further

    Thanks

    Vishu

  • August 9, 2016 at 12:28 pm

    #1894626

    I have found the issue long back but forgot to post here.

    The problematic subscriber is a named instance and the team who setup the replication used the script to add the subscriber to existing publication.

    The data flow from publisher to subscriber will happen with a check "HOSTNAME", For this subscriber, the hostname was set as SQL named instance which is not correct. Because of this, when a new record inserted in Subscriber is replicating to publisher and then publisher check back to see if subscriber has valid data, in this case the hostname is different and hence data on subscriber getting deleted.

    After changing the hostname from SQL named instance to Servername in merge agent job, everything worked.

    Thanks

    Vishu

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply