SQL Server - 2000 sp4 merge agent failure: The process could not make a generat
Asked By John
16-May-07 06:06 PM
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,
John
Column
(1)
Table
(1)
Exec
(1)
Drop
(1)
j1ct replied...
John, I do not suppose you found a fix for this. I have got exactly the same
issue on my production server.
Any news would be helpful.
John replied...
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
j1ct replied...
John,
Yes, that's what I found Last night.
An easier way of adding the server is to use SP_Addserver 'Servername',
'LOCAL'
This ensure that the server is added as ServerID=0
I just thought I'd come back and update you if you hadn't found the answer.
Thanks Anyway.
profile db storage at table / column level SQL Server Are any scripts / tools available to profile db storage at the table / column level ? SQL Server Programming Discussions MsForEachTable (1) Grandy (1) EXEC (1) EXEC sp_msForEachTable 'EXEC sp_spaceused ''?'''; keywords: profile, db, storage, at, table / column, level description: Are any scripts / tools available to profile db storage at the table
000', 121), @PeriodEnd = convert(datetime, '2007-08-01 00:00:00:000', 121), @CalculateWithVirtualDepartments = 0 exec sp_executesql N' SELECT Kostenstelle.Abteilung_ID, SUM(Sitzung.Dauer) AS SummeSitzungenDauer FROM Sitzung INNER JOIN ((Mitarbeit 000', 121), @PeriodEnd = convert(datetime, '2007-08-01 00:00:00:000', 121), @CalculateWithVirtualDepartments = 0 exec sp_executesql N' SELECT Kostenstelle.Abteilung_ID, SUM(Sitzung.Dauer) AS SummeSitzungenDauer FROM Sitzung INNER JOIN ((Mitarbeit 000', 121), @PeriodEnd = convert(datetime, '2007-08-01 00:00:00:000', 121), @CalculateWithVirtualDepartments = 0 exec sp_executesql N' SET ANSI_WARNINGS OFF SELECT Kostenstelle.Abteilung_ID, SUM(Sitzung.Dauer) AS SummeSitzungenDauer FROM Sitzung 121), @PeriodEnd = convert(datetime, '2007-08-01 00:00:00:000', 121), @CalculateWithVirtualDepartments = 0 StatementText = " exec sp_executesql N' SELECT Kostenstelle.Abteilung_ID, SUM(Sitzung.Dauer) AS SummeSitzungenDauer FROM Sitzung INNER JOIN ((Mitarbeit 321" CompileCPU = "306" CompileMemory = "1384"> <MissingIndexes> <MissingIndexGroup Impact = "8.43038"> <MissingIndex Database = "[KVP_DB]" Schema = "[dbo]" Table = "[Sitzung]"> <ColumnGroup Usage = "INEQUALITY"> <Column Name = "[Dauer]" ColumnId = "7" / > < / ColumnGroup> <ColumnGroup Usage = "INCLUDE"> <Column Name = "[KVP_ID]" ColumnId = "2" / > <Column Name = "[Datum]" ColumnId = "4" / > < / ColumnGroup> < / MissingIndex> < / MissingIndexGroup> < / MissingIndexes> <RelOp NodeId = "0" PhysicalOp = "Hash Match" LogicalOp
Export to Access - Varchar(3) becomes Longtext SQL Server I am exporting a SQL 2000 table to an Access 2002 (initially empty) database, using SQL 2005's Management Studio. Some of type of export? Thanks. David Walker Here is the Create statement for my SQL 2000 table: USE [CDW] GO / * ** ** * Object: Table [dbo].[Direct Business Transactions] Script Date: 04 / 20 / 2007 15:31:08 * ** ** * / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Direct Business Transactions]( [Record_Type] [varchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SSN_EIN_Number] [varchar](9) COLLATE SQL_Latin1_General_CP1_CI_AS Transactions] PRIMARY KEY CLUSTERED ( [ID] ASC ) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC dbo.sp_addextendedproperty @name = N'MS_ColumnHidden', @value = False , @level0type = N'USER', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Direct Business Transactions', @level2type = N'COLUMN', @level2name = N'Record_Type' GO EXEC dbo.sp_addextendedproperty @name = N'MS_ColumnOrder', @value = 0 , @level0type = N'USER', @level0name = N'dbo', @level1type = N
adding column to table variable SQL Server Hello there I've tried this code: DECLARE @Result table (Field1 varchar(100)) ALTER TABLE @Result ADD COLUMN Field2 varchar(100) and it gives me error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '@Result'. Is there a way to add new column to table variable? SQL Server Programming Discussions NOT NULL (1) PRIMARY KEY (1) CREATE FUNCTION (1) CREATE TABLE (1) ALTER TABLE (1) Table (1) Column (1) Dynamic (1) If you really *need* to
Cursor Help SQL Server I have a one column table. The data in that column has 1142 characters. It is fixed delimited data. To make it more dynamic for parsing the data I have created a table that has the fieldname, fieldlength and field size. I want to create a cursor that will parse this data into the correct fields into a table. When I run this it puts the data into the first field. Lets say there are 50 records in the One column table. Well it puts the first 50 rows into the new table but it starts the second field at 51 and so on and so forth. Declare