Replication Problem?

  • patricio.molina

    SSC-Addicted

    Points: 473

    Hi.

    My transactional replication has a problem. I was adding some items and suddenly gave problem and closed the SSMS. When he returned, got the following message: "The subscription to this publication is not active yet. No user action is required."

    This is a problem? The number of Undistrubuted Commands keeps increasing, but does not replicate.

    Thanks!!!

  • Roy Ernest

    SSC-Dedicated

    Points: 38707

    Yes, it is a problem. Try restarting the log reader agent and the snapshot agent.

    -Roy

  • patricio.molina

    SSC-Addicted

    Points: 473

    I try this and not work. Other any suggestions?

    Thanks

  • Roy Ernest

    SSC-Dedicated

    Points: 38707

    Reinitialize the subscription.

    -Roy

  • patricio.molina

    SSC-Addicted

    Points: 473

    I try this and not work again.

    Thanks

  • WillC9999

    Mr or Mrs. 500

    Points: 500

    Replication can be fickle. Sometimes it seems reinitialising just doesn't work and we have to recreate the entire replication job again.

  • Roy Ernest

    SSC-Dedicated

    Points: 38707

    Drop the subscription and add it back again. When your SSMS crashed while setting up replication might have not completed the required entries.

    -Roy

  • patricio.molina

    SSC-Addicted

    Points: 473

    But i have transactions not been replicated. If drop and create, this transactions will be replicated?

    thanks.

  • Roy Ernest

    SSC-Dedicated

    Points: 38707

    When you are dropping the subscription and re adding them, you will be able to initialize using snapshots. Then what ever is missing now will also be there.

    -Roy

  • patricio.molina

    SSC-Addicted

    Points: 473

    Ok. I will recriate the subscription.

    Thanks again!

  • Roy Ernest

    SSC-Dedicated

    Points: 38707

    Please do let us know if it worked.

    -Roy

  • patricio.molina

    SSC-Addicted

    Points: 473

    Hi Roy.

    I recreated the replication and everything worked again.

    Thanks!

  • Roy Ernest

    SSC-Dedicated

    Points: 38707

    I am glad that we could help.

    -Roy

  • lutherro

    SSC Rookie

    Points: 45

    I had the same problem adding articles. I removed the articles from replication and re-added them. Replication fixed.

    --Bob Luther

  • Bhaskar.Shetty

    Hall of Fame

    Points: 3054

    Check for Status column in MSSubscriptions table, it should be always value 2, any other than value 2 update it and check, the halted replication commands should start replicating to subscriber.

    --- Checking Query --

    select status, * from distribution..MSsubscriptions where status <> 0

    --- Update Query

    update distribution..MSsubscriptions set status=2 where status <> 0

    ---

    Thanks & Regards,

    Bhaskar Shetty

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

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