Results 1 to 6 of 6

Thread: Replication

  1. #1
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71

    Unanswered: Replication

    Can you please help. I am trying to do a merge replication and i get the following error:

    Procedure or function sp_MSaddinitialarticle has too many arguments specified.
    (Source: SUB_SERVER (Data source); Error number: 8144)
    ---------------------------------------------------------------------------------------------------------------
    The process could not deliver the snapshot to the Subscriber.
    (Source: Merge Replication Provider (Agent); Error number: -2147201001)
    ---------------------------------------------------------------------------------------------------------------

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This error is usually caused by a schema change that isn't propagated to one or more subscribers. Was the machine reporting this problem "out of circulation" during the last schema change?

    -PatP

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Any network issues between the servers?
    What is the default query timeout value set?

    And also try to reduce the MergeHistory table rows.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71
    Pat what do you mean by schema change because i ended up creating a new table only with 2 fields and still get the same problem, can you please elaborate on schema change

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I haven't actually done this myself, but I've run into a situation where it cropped up. We eventually "deep sixed" the offending server and rebuilt a fresh copy.

    Let's assume that you have 20 servers participating in merge replication to support a high transaction volume web-site. You periodically take some of them offline for maintenance. When five servers are down, you make a schema change. Four of them come back online later in the day, but one has more serious problems so it stays offline for another four days while you get parts.

    When that "prodigal child" comes back online, it still won't know about the schema change. In a high transaction volume situation, you almost certainly don't have five days worth of replication saved up. Bingo, Houston, we have a problem here!

    -PatP

  6. #6
    Join Date
    Nov 2003
    Location
    South Africa
    Posts
    71
    Thanks Pat, i managed to rebuild the server and is working.

    Now my other question which i already posted in the forums reads:
    Is there a way to replicate the table permissions from publisher to
    subscriber? I noticed that when replication takes place, the permissions
    that were set up on tables on the subscriber are wiped out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •