Replication Error when I try to use Pull Replication.

Discussion in 'microsoft.public.sqlserver.replication' started by solar115, Aug 7, 2003.

  1. solar115

    solar115 Guest

    The specified subscription type is invalid.


    The specified subscription type is invalid.
    (Source: Merge Process (Agent); Error number: -2147201020)
     
    solar115, Aug 7, 2003
    #1
    1. Advertisements

  2. From your post heading, looks like you want a pull subscription.

    Could you confirm that the merge agent parameter -SubscriptionType is
    correct..

    Pull susbscriber: -SubscriptionType 1
    Anonymous subscriber: -SubscriptionType 2

    Hope that helps.
    --Mahesh

    This posting is provided "as is" with no warranties and confers no rights.
     
    Mahesh [MSFT], Aug 7, 2003
    #2
    1. Advertisements

  3. solar115

    solar115 Guest

    I'm new for replication. How can I check it?
     
    solar115, Aug 8, 2003
    #3
  4. If you are using a command line merge agent, you can pretty much specify
    what you want on the command line.

    If not, if you are using jobs to run the merge agent, then look at the job
    steps and see what is specified in the job description.
    In Enterprise manager, select Management-->Jobs-->
    Right click on the job displayed on the right hand side, select properties,
    select "Steps" tab, double click on the "Run Agent"
    and see the description in "Command"

    Verify that you specified a pull subscription and it is SubscriptioType 1 in
    the Command (as mentioned above)

    Another way you could check is:
    verify that column subscriber_type in the system table sysmergesubscriptions
    at both the publisher and subscriber database is the same. In this case,
    since it is pull, it should show value as 1.

    Hope that helps.
    --Mahesh

    This posting is provided "as is" with no warranties and confers no rights.
     
    Mahesh [MSFT], Aug 8, 2003
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.