locked
"'ABC-Sub' is not defined as a Subscriber for 'XYZ-Pub'" Error when dropping a MERGE replication subscriber RRS feed

  • Question

  • Hello,

    I am getting the following error:

    Msg 20032, Level 16, State 1, Procedure sp_MSdrop_merge_subscription, Line 72 [Batch Start Line 2]

    'ABC-Sub' is not defined as a Subscriber for 'XYZ-Pub'.

    Msg 14056, Level 16, State 1, Procedure sp_dropmergesubscription, Line 482 [Batch Start Line 2]

    The subscription could not be dropped at this time.

     

    when trying to run:

    EXEC sp_dropmergesubscription

      @publication = 'Mrg_Repl',

      @subscriber = 'ABC-Sub',

      @subscriber_db = 'Sub-DB';

    although when I run:

    USE XYZ-Pub

    Go
    sp_helpmergesubscription


    I get:

    Help please :(

    Sunday, March 3, 2019 9:06 AM

Answers

  • This solved it  :D

      update sysmergesubscriptions set status = 2 where subscriber_server= 'ABC-Sub' and db_name= 'Sub-DB'


    • Marked as answer by Butmah Monday, March 4, 2019 5:14 AM
    • Edited by Butmah Monday, March 4, 2019 5:15 AM
    Monday, March 4, 2019 5:14 AM

All replies

  • This solved it  :D

      update sysmergesubscriptions set status = 2 where subscriber_server= 'ABC-Sub' and db_name= 'Sub-DB'


    • Marked as answer by Butmah Monday, March 4, 2019 5:14 AM
    • Edited by Butmah Monday, March 4, 2019 5:15 AM
    Monday, March 4, 2019 5:14 AM
  • Yes. This is  a table  which Contains one row for each known Subscriber and is a local table at the Publisher. This table is stored in the publication and subscription databases and can be updated
    Monday, March 4, 2019 5:18 AM
  • the correct way of doing this is 

    EXEC sp_dropmergesubscription

      @publication = 'Mrg_Repl',

      @subscriber = 'ABC-Sub',

      @subscriber_db = 'Sub-DB',

      @ignore_distributor =1

    Monday, March 4, 2019 3:04 PM
    Answerer