Generation at the 'Subscriber'

• kurtschl

  SSC Enthusiast

  Points: 188

  More actions

  December 5, 2001 at 10:07 pm

  #77886

  I'm trying to create a push merge subscription at my webserver. The SQL instance is called SERVER01 but i have to connect via IP or domainname. I get following 3 errors:

  -The process could not make a generation at the 'Subscriber'

  -Cannot insert the value NULL into column 'nicknames', table 'test.dbo.MSmerge_genhistory'; column does not allow nulls. INSERT fails.

  -Cannot roll back makegeneration. No transaction or savepoint of that name was found.

  -Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.

  Can this be solved by creating a matching linked server?

• billhol

  Newbie

  Points: 1

  More actions

  December 18, 2001 at 10:04 am

  #421236

  At the subscriber, run:

  --

  select * from sysmerge_subscriptions

  exec sp_helpserver

  --

  If its id<>0 then run:

  --

  exec sp_dropserver '<subscriber name>'

  exec sp_addserver '<subscriber name>', local

  --