locked
replication RRS feed

  • Question

  • Hi,

    I have a SQL 2008 instance that has database with a transactional publication with updatable subscription. 

    When I try to update a table at the subscribers DB a had this error :

    Msg 21064, Niveau 16, statement 1, Procédure sp_MSreplraiserror, Line 18
    The subscription is uninitialized or unavailable for immediate updating as it is marked for reinitialization. If using queued failover option, run Queue Reader Agent for subscription initialization. Try again after the (re)initialization completes.
    Msg 20512, Niveau 16, statement1, Procédure sp_MSreplraiserror, Line 8
    Updateable Subscriptions: Rolling back transaction.
    Msg 3609, Niveau 16, statement 1, Line 1
    The transaction ended in the trigger. The batch has been aborted.

    How can I get this to work? Any help would be much appreciated! thanks.

    Monday, May 25, 2015 10:08 AM

Answers

  • In one such case the expiration of password for the account was expired and therefore the replication was stalled so I am suspecting the same might be the case at your end too:

    Check this:

    http://www.sqlservercentral.com/Forums/Topic813399-146-1.aspx#bm813513

    https://msdn.microsoft.com/en-us/ms186985.aspx?f=255&MSPPError=-2147217396

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/922b1fb3-9a49-4ead-aa5b-bf8aaf29e7bb/21064-the-subscription-is-uninitialized-or-unavailable-for-immediate-updating?forum=sqlreplication


    Good Luck!
    Please Mark This As Answer if it solved your issue.
    Please Vote This As Helpful if it helps to solve your issue

    Monday, May 25, 2015 10:47 AM

All replies

  • https://support.microsoft.com/en-us/kb/955975?wa=wsignin1.0

    Monday, May 25, 2015 10:27 AM
  • In one such case the expiration of password for the account was expired and therefore the replication was stalled so I am suspecting the same might be the case at your end too:

    Check this:

    http://www.sqlservercentral.com/Forums/Topic813399-146-1.aspx#bm813513

    https://msdn.microsoft.com/en-us/ms186985.aspx?f=255&MSPPError=-2147217396

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/922b1fb3-9a49-4ead-aa5b-bf8aaf29e7bb/21064-the-subscription-is-uninitialized-or-unavailable-for-immediate-updating?forum=sqlreplication


    Good Luck!
    Please Mark This As Answer if it solved your issue.
    Please Vote This As Helpful if it helps to solve your issue

    Monday, May 25, 2015 10:47 AM