Post reply

Replication Help!

  • July 27, 2017 at 11:35 am

    #338543

    I am experiencing a problem today where replication appears to be failing, but without any supporting errors.

    The count of undistributed commands is growing (over 2million) however when running a basic validation (query below):

    EXECUTE sp_publication_validation
    @publication = 'publication1'
    ,@rowcount_only = 1

    All the tables are reporting an expected rowcount.

    Also when looking in Replication monitor, the message being shown for the log reader agent is "Approximately 500000 log records have been scanned in pass # 1, 0 of which were marked for replication."

    Am I missing something obvious?

    Hope someone can help out a stressed individual!

  • July 27, 2017 at 12:23 pm

    #1953082

    Did you check the Undelivered and Delivered commands in the MSdistribution_status view in the distribution database?

    Sue

  • July 27, 2017 at 12:37 pm

    #1953087

    Thank you so much for replying!

    The answer is now, so I have used that now which shows loads and loads of delivered and undelivered commands, so clearly data is not getting through.  I still do not understand why I am not receiving any errors anywhere in the GUI. 

    You may notice that my replication skills are not too hot here!

    Pointers to the lease confusing article on troubleshooting further would be really appreciated!!!

  • July 27, 2017 at 1:23 pm

    #1953098

    The Stairway articles concerning replication on this site are a good start:

      http://www.sqlservercentral.com/stairway/72401/

    The last step is specifically on troubleshooting:

      http://www.sqlservercentral.com/articles/Stairway+Series/72452/

  • July 27, 2017 at 1:34 pm

    #1953099

    In terms of the distribution status view previously mentioned, you would also want to look at the agents for each of those. Basically, you want to check and see if you have something that looks like the following - read the parts about virtual subscriptions and look at your agent ids compared to what is shown:
    I Command You to Deliver Those Commands – Replication weirdness

    Then also check and make sure the Log reader agent and the distribution agent are both running. Sounds like the log reader is at least but check and make sure, check the history, etc.
    Check for errors in the MSrepl_errors table in the distribution database. And check to see if you can see issues in the MSdistribution_history table in the distribution database - latency and error columns, I also kind of look through the comments as well.

    Sue

Viewing 5 posts - 1 through 4 (of 4 total)

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