Results 1 to 6 of 6

Thread: Replication

  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: Replication

    I'm trying to update a row in a subscriber, and I get an error like this:
    "Another user has modified this table or view content; the row you are trying to modifiy does not longer exists in the database".
    Can anybody help me to solve this problem? Thanks...

  2. #2
    Join Date
    Nov 2003
    Posts
    3

    Re: Replication

    Originally posted by berto00
    I'm trying to update a row in a subscriber, and I get an error like this:
    "Another user has modified this table or view content; the row you are trying to modifiy does not longer exists in the database".
    Can anybody help me to solve this problem? Thanks...
    try restarting the snapshot agent again, you have a row that perhaps exists in the subscriber and not in the publisher

    regards,
    -blackpearl

  3. #3
    Join Date
    Nov 2003
    Posts
    7

    Re: Replication

    Originally posted by blackpearl
    try restarting the snapshot agent again, you have a row that perhaps exists in the subscriber and not in the publisher

    regards,
    -blackpearl
    I have checked all rows (they're only 10 rows...) and they're all the same. I try to update the value of a column of this row, but then that error occurs...

  4. #4
    Join Date
    Nov 2003
    Posts
    3

    Re: Replication

    Originally posted by berto00
    I have checked all rows (they're only 10 rows...) and they're all the same. I try to update the value of a column of this row, but then that error occurs...
    ok

    Go to the snapshot agents folder and restart your respective snapshot agent (wait till it ends creating the snapshot), then select the the subscriber in your publications folder and click on "Reinitialize".

    regards,
    -blackpearl

  5. #5
    Join Date
    Nov 2003
    Posts
    7

    Re: Replication

    Originally posted by blackpearl
    ok

    Go to the snapshot agents folder and restart your respective snapshot agent (wait till it ends creating the snapshot), then select the the subscriber in your publications folder and click on "Reinitialize".

    regards,
    -blackpearl
    ok, I'll try it out... thanks

  6. #6
    Join Date
    Nov 2003
    Posts
    7

    Re: Replication

    Originally posted by berto00
    ok, I'll try it out... thanks
    I've tried what you told me, but still the same... I don't know if it's important, but the error message also includes this:
    "[Microsoft][ODBC Sql Server driver][Sql Server][OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

    And the two servers (publisher and subscriber) are connected through adsl...

Posting Permissions

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