Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Merge Replication Problem

    Hi all,

    OS: Windows 2000 Server
    SQL: SQL Server Standard 2000

    I was searching the forums and the web but didn't find any information on solving this problem.

    On the publisher when I look at the Replication Monitor -> Merge Agents section I see the following error to only one of the 4 subscribers. I've tried to removing and recreating the subscriber, unfortunately that didn't work so i recreated the merge replication all together with a new name and removed the original, this also didn't solve the problem.

    I'm worried this is a problem on the subscriber, recently we renamed the windows computer name (which caused some data access and login errors), after doing a registry rebuild for SQL all of that seemed to be cleared up. NOt sure if this helps but I guess some background can't hurt.

    So here's the error info that comes up.

    Error Information

    Agent, Merge Replication Provider, -2147200994
    The process could not make a generation at the 'Subscriber'.

    Data Source, SUBSCRIBER_DB_NAME, 515
    Cannot insert the value NULL into column 'nicknames', table 'MyDB.dbo.MSmerge_genhistory'; column does not allow nulls. INSERT fails.

    Thanks for any help...

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You have to do a no-sync subscription.
    Check the following :
    select * from sysmerge_subscriptions
    go
    Run sp_helpserver on the subscribing server and the srvid should be 0 for the subscriber.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    Hi Satya,

    Thank you very much for the reply, at the very least it got me looking into nosync subscriptions...

    Unfortunately I wasn't able to figure out how to set one up as such, and if simply changing the srvid at the subscriber is all that needs to be done.

    I followed your instructions and ran the two queries you specificied at the SUBSCRIBER (not sure if both were supposed to be run at the subscriber...) and here are the results (in the attached zipped, csv file..) the srvid is not 0 for any of the rows.

    If you get a chance to look at it and see the problem, or what needs to be changed (or how I should setup the nosync subscription), please do let me know...

    once again thank you very much.
    Attached Files Attached Files

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to books online about dynamic snapshot and applying them manually.

    If any triggers are involved then execute sp_addsynctriggers, before that follow books online about this SP.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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