"John T" wrote:

> When you run select @@servername on the subscriber side, what do you get? If
> you get a value other than the local server name expected, you have drop and
> readd your local server (sp_dropserver, sp_addserver). Also, the srvid for
> this local server MUST be 0. If it is not 0, you must sp_configure 'allow
> updates', 1, and updated the srvid to equal 0. This is what fixed this error
> for me, but as always, the caveat is that updating system tables is dangerous.
>
> John
>
> "j1cta" wrote:
>
> > John, I don't suppose you found a fix for this. I've got exactly the same
> > issue on my production server.
> >
> > Any news would be helpful.
> >
> > "John T" wrote:
> >
> > > Hello,
> > >
> > > SQL2K4, SP4, W2k3 SP1. When I start up my merge agent, I get the following
> > > error:
> > >
> > > The process could not make a generation at the 'Subscriber'.
> > > (Source: Merge Replication Provider (Agent); Error number: -2147200994)
> > > ---------------------------------------------------------------------------------------------------------------
> > > Cannot insert the value NULL into column 'nicknames', table
> > > 'MyDB.dbo.MSmerge_genhistory'; column does not allow nulls. INSERT fails.
> > > (Source: ENG-INSQL02 (Data source); Error number: 515)
> > >
> > > Setting OutputVerboseLevel 3 shows the following:
> > >
> > > Percent Complete: 82
> > > Applied script 'Action_Help_40.trg'
> > > [5/16/2007 2:59:34 PM]ENG-INSQL02.MyDB: exec dbo.sp_MSsetlastrecgen
> > > '5442D5EF-6CEC-4550-A836-20A1A07EC0ED','1','4AB7C31C-3C18-43B3-8FDA-72EDADDA4942'
> > > [5/16/2007 2:59:34 PM]ENG-INSQL02.MyDB: exec dbo.sp_MSsetlastsentgen
> > > '5442D5EF-6CEC-4550-A836-20A1A07EC0ED','1','4AB7C31C-3C18-43B3-8FDA-72EDADDA4942'
> > > The process could not make a generation at the 'Subscriber'.
> > > Percent Complete: 0
> > > The process could not make a generation at the 'Subscriber'.
> > > Percent Complete: 0
> > > Category:NULL
> > > Source: Merge Replication Provider
> > > Number: -2147200994
> > > Message: The process could not make a generation at the 'Subscriber'.
> > > Percent Complete: 0
> > > Category:SQLSERVER
> > > Source: ENG-INSQL02
> > > Number: 515
> > > Message: Cannot insert the value NULL into column 'nicknames', table
> > > 'MyDB.dbo.MSmerge_genhistory'; column does not allow nulls. INSERT fails.
> > >
> > > Any help on correcting this issue would be appreciated. I'm under a
> > > deadline, and will have to open a support case, otherwise.
> > >
> > > Thanks,
> > >