Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    76

    Cool Unanswered: Subscription data are deleted...

    Subscription data are deleted...

    We've got a merge replication. I have one Publisher and one Subscriber. I've made a pull subscription to a Publisher.

    I've got into trouble few times occasionally 3-4 times a year. Today also I got problem with one table only one row among so many not carried out on at subscriber, even it is not find out at publisher.

    This row was entered at subscriber in the morning, printed by users but in evening report it is not coming down in reports, so I had checkup and find out it is not available at any server. How?

    I don’t understand, how inserted, printed data erase from subscriber but rarely. Is there any clue?

    Which parameter of the subscription is responsible for it ?

    Best regards.

  2. #2
    Join Date
    Sep 2004
    Posts
    76
    Today I Got following message during row delition of subscriber -

    The process could not make a generation at the 'Subscriber'.
    The process could not enumerate changes at the 'Publisher'.

    Error code -2147200994

    Can any body have experience on the same?

  3. #3
    Join Date
    Sep 2004
    Posts
    76

    Cool Subscription data are deleted-Redefinition

    Subscription data are deleted...

    We've got a merge replication. I have one Publisher and one Subscriber. I've made a pull subscription to a Publisher.

    Publisher and subscriber are working fine far more than one year, Recently I got issue at subscriber one table deleted for 3 rows, I take usually and think it was never happen in this system, that will not be in future, yesterday again one row deleted from another table at subscriber, so I think it is serious issue and look over the details, I found following-

    The process could not make a generation at the 'Subscriber'.
    The process could not enumerate changes at the 'Publisher'.

    Error code -2147200994

    Which parameter of the subscription is responsible for it?

    Each clue is too valuable for us. Can any body have experience on the same?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •