www.enkognedo.com

  • Increase font size
  • Default font size
  • Decrease font size
Home MS SQL Administration The process could not make a generation at the 'Subscriber'

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

Monday, 14 February 2011 09:26
E-mail Print PDF
View Comments
User Rating: / 2
PoorBest 
After pushing a very long, almost 10 hour, merge replication snapshot to the subscriber, I was presented with an error toward the very end that reads - "The process could not make a generation at the 'Subscriber'.  Cannot insert the value NULL into column 'nicknames', table 'yourspecifictable'; column does not allow nulls.  INSERT fails."

Talk about frustrating!  Spending almost 10 hours to see it fail?  Very frustrating.

Anyway, the article over here gave me enough information to apply a solution to my particular case.  To give everyone an idea of my setup...

I have the following:
  • a publisher at one location
  • a subscriber at another (connection is via Internet, which is why it is so slow)
  • the subscriber has an old MSDE installation for the (local) database, but was changed to SQL 2000 Personal way back to accommodate a larger database size, since MSDE has a 2GB limit.
Running the following query on the subscriber to which I wish to merge:
Show/Hidden sql code
Will show a list of the servernames, as if you were to do a Show/Hidden sql code
View source
SELECT @@SERVERNAME
on your particular instance to pull back THAT particular server's name (keeping in mind, the server name may not be set or may be incorrect if you have actually changed the computer name after installing SQL)

According to the article mentioned above, the "srvid" should be "0" for the subscriber.  To see if it is, run Show/Hidden sql code
View source
SELECT srvname FROM master..sysservers WHERE srvid = 0
.  If you get nothing or something else, then the instance you're working with is obviously NOT set to 0.  If that's the case, drop the server that does show up OR the one that you want to be there, e.g.  run Show/Hidden sql code
View source
SP_DROPSERVER 'servername to drop'
, then add the correct one, e.g. Show/Hidden sql code
View source
SP_ADDSERVER 'servername to add', 'local'
.

After the above steps, run Show/Hidden sql code to hopefully show that your newly added server name IS, in fact, the one that you wish to use with merge replication.

References:
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-replication/4577/call-sp-MSmakegeneration
http://www.eggheadcafe.com/software/aspnet/29953789/2000-sp4-merge-agent-failure-the-process-could-not-make-a-generat.aspx
SELECT srvname FROM master..sysservers



Next >
Last Updated on Monday, 14 February 2011 10:25  
blog comments powered by Disqus

Main Menu

Categories

Sections


Design Center Tips

Adobe Design Center RSS Feed
Learn how to use and integrate Adobe products with step-by-step tutorials on new features, key workflows, and advanced techniques.
  • Adobe - Lightroom 2.0 video tutorial : What's new in the Develop module?
    ...Adobe® Photoshop® Lightroom™ 2.0. Learn how to make nondestructive localized corrections using the new Adjustment Brush and Graduated Filter tools. Duration: 22 minutes 28 seconds Requirements To complete the tasks demonstrated in this tutorial, you need the following software:...
  • Adobe - Lightroom 2.0 video tutorial : The Template Browser
    ...In this short video tutorial, learn how to use the Template Browser in Adobe® Photoshop® Lightroom™. Chris Orwig discusses several of the templates included with Lightroom and shows you how to manipulate images within a template. Duration: 2 minutes 07 seconds Requirements To...
  • Adobe - Lightroom 2.0 video tutorial : What's new in the Library module?
    ...Adobe® Photoshop® Lightroom™ 2.0. Learn how to navigate the new Library layout, as well as how to import, organize, and find your images quickly. Duration: 26 minutes 23 seconds Requirements To complete the tasks demonstrated in this tutorial, you need the following software:...

Inside Gaming

  • Mass Effect 2 - XBOX 360 Game

    I recently received the Mass Effect 2 game for Xbox 360 as a gift!  I've got to say, this is one hell of a sequel game to Mass Effect!  The storyline is as intense and involved as ever and the graphics and sound are unsurpassed!

    If I could complain at all, I'd complain about the time it takes to load a game.  Only take about a second to save one, but loading is more like 30 seconds - maybe more.  So, needless to say, moving around from the main screen to in-game can be quite time cumbersome and annoying.

    Read more...
  • Operation Flashpoint Dragon Rising

    Flashpoint just didn't get the high marks it deserved.  For those who like local, campaign play, this is the game for you.  It is intense, very difficult and will keep you on the edge of your seat figuring and carrying out that perfect strategy.

    There is a lot of evasive or eluding type play - meaning that you don't always have to engage the enemy just because you can see them.  If you want to survive in this game, you have to be tactically sound in your decisions, well disciplined, and patient.

    Read more...
  • Call of Duty - Modern Warfare 2

    The graphics were great, the individual scenes awesome, the length of play...   HIGHLY disappointing!  

    I played this game for just over 11 hours.  I don't consider myself a "gamer".  I've always thought of gamers as those who buy every new game as it becomes available to buy and play it straight through to the finish.  Some of these people even use the system to quickly play it, take it back or trade it in for another, or whatever.

    Read more...
  • Army of Two - PS3

    Never go into battle alone! EA's Montreal development studio is changing the face of how people will play games. Delivering a groundbreaking strategic 3rd person co-op shooter unparalleled in the action genre, EA Montreal's ARMY OF TWO focuses on gameplay centered around TWO man missions, TWO man strategies, TWO man tactics and a TWO man advantage

    Fight along side your team-mate to become the deadliest two-man military outfit a government can buy. The breakthrough gameplay in ARMY OF TWO, with a live or adaptive AI partner, enables you to take advantage of two-man strategies like customizable weapons, vehicles, and tactical shooting.

    From TWO man sniping to parachuting, players will experience action-packed scenarios where they will have to use their wit, strength and a deadly arsenal of shared customizable weapons to successfully defeat their enemies and complete the mission at hand.

    Gamers will fight their way through war, turmoil and a conspiracy so vast it threatens the entire world. When one man is not enough, it's going to take an army of two to save us.

    Key Features

  • "Two Man" Gameplay-Co-op is no longer a mode, it's the game. Team up with a live or AI partner on two-man missions using two-man tactics to ultimately create an advantage that no enemy can withstand.
  • Partner AI-ARMY OF TWO delivers intelligent partner AI (PAI) that interacts, adapts, collaborates and learns from their human partner. The PAI will also react and adjust to the gamer's ability and how they play the game by taking the lead or following, driving strategy or taking orders. It is the dream of the human machine.
  • Customizable Weapons-Customize and upgrade dozens of deadly weapons and share them with your partner off or online.
  • Dynamic
Read more...
  • Mass Effect Game

    You are Commander Shepard of the starship Normandy and you are the last hope for all life in the Galaxy. Saren, a rogue member of the elite and untouchable Spectre agents, has discovered the secret to unleashing an apocalyptic force on the galaxy, and only you stand in his way.

    To save the lives of billions, you must do whatever it takes to stop Saren and prevent the return of an ancient force bent on the destruction of all organic life.

    • Experience a rich and engrossing story where your choices decide the fate of galaxy
    • Engage in emotionally charged interactions with the most realistic Digital actors ever seen in a Video game, using an innovative new dialog system
    • Immerse yourself in an incredible new adventure from world-famous masters of the RPG: BioWare
    • Dominate the battlefield with new individual squad member command system-Optimized controls designed specifically for the PC
    • High Resolution visuals - highly detailed textures, characters and environments
    • Fully customizable controls - you can re-map the control scheme any way you like
    • Run & Gun Control - You can assign biotic powers or skills to 'hot keys' allowing you to play Mass Effect with a heavier Focus on action
    • Decryption mini-game
    • New inventory screen GUI and functionality - The enhanced inventory system makes it easier for you to equip and modify your weapons and armor
    Read more...