Replidation error

Question

Hi Sql Server Experts,

I created a Merge replication, when I ran the replication agant at the 
subscriber side, I got the following error (in the job history log)

ate		5/12/2008 7:41:00 PM
Log		Job History (GLSQL2-SUPL-pub_supl_to_glsql3-GLSQL3-SUPL- 0)

Step ID		1
Server		GLSQL3
Job Name		GLSQL2-SUPL-pub_supl_to_glsql3-GLSQL3-SUPL- 0
Step Name		Run agent.
Duration		00:00:23
Sql Severity		0
Sql Message ID		0
Operator Emailed		
Operator Net sent		
Operator Paged		
Retries Attempted		0

Message
2008-05-12 19:41:11.212 [56%] [1 sec remaining] Bulk copying data into table 
'MSmerge_genhistory'
2008-05-12 19:41:11.306 [56%] [1 sec remaining] Bulk copied data into table 
'MSmerge_contents' (0 rows)
2008-05-12 19:41:11.400 [56%] [1 sec remaining] Bulk copying data into table 
'sysmergesubsetfilters'
2008-05-12 19:41:11.509 [56%] [1 sec remaining] Bulk copied data into table 
'sysmergesubsetfilters' (0 rows)
2008-05-12 19:41:11.618 [56%] [1 sec remaining] Bulk copied data into table 
'MSmerge_genhistory' (1 rows)
2008-05-12 19:41:23.025 The schema script 'DISCOVERED_CELL_ID_2.prc' could 
not be propagated to the subscriber.
2008-05-12 19:41:23.228 Category:NULL
Source:  Merge Replication Provider
Number:  -2147201001
Message: The schema script 'DISCOVERED_CELL_ID_2.prc' could not be 
propagated to the subscriber.
2008-05-12 19:41:23.321 Category:NULL
Source:  Microsoft SQL Native Client
Number:  207
Message: Invalid column name 'rowguid'.
----------------------------------------------------

I did not have the column rowguid in the publisher table before setting up 
the replication. This column was created by  replication (creating publiser).
How do I deal with this?

Thanks.
Pingx

 

Answer 1

Can you post the schema for the table

DISCOVERED_CELL_ID here? Also what version of SQL Server are you running?

Answer 2

Here is the table definition. The other UID column was from another replication.
The source table of this replication is the destination table of the other replication. There is a computed column RNCID that I excluded from the replication. I have removed the problem replication now. So growid column is not showing here.

USE [SUPL]
GO
/****** Object:  Table [dbo].[DISCOVERED_CELL_ID]    Script Date: 05/13/2008 09:47:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DISCOVERED_CELL_ID](
    [cell_id] [int] NOT NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_cell_id]  DEFAULT ((0)),
    [cell_lac] [int] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_cell_lac]  DEFAULT ((0)),
    [cell_mnc] [int] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_cell_mnc]  DEFAULT ((0)),
    [cell_mcc] [int] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_cell_mcc]  DEFAULT ((310)),
    [lat] [float] NOT NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_lat]  DEFAULT ((0)),
    [lon] [float] NOT NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_lon]  DEFAULT ((0)),
    [alt] [float] NULL,
    [bts_ref_frame] [smallint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_bts_ref_frame]  DEFAULT ((0)),
    [gps_tow] [int] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_gps_tow]  DEFAULT ((0)),
    [fix_type] [tinyint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_fix_type]  DEFAULT ((0)),
    [shape] [tinyint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_shape]  DEFAULT ((0)),
    [uncertainty_semi_major] [smallint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_uncertainty_semi_major]  DEFAULT ((0)),
    [uncertainty_semi_minor] [smallint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_uncertainty_semi_minor]  DEFAULT ((0)),
    [angle_major] [smallint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_angle_major]  DEFAULT ((0)),
    [uncertainty_alt] [smallint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_uncertainty_alt]  DEFAULT ((0)),
    [confidence] [smallint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_confidence]  DEFAULT ((0)),
    [uncertainty_circle] [smallint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_uncertainty_circle]  DEFAULT ((0)),
    [uncertainty_EA] [smallint] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_uncertainty_EA]  DEFAULT ((0)),
    [msidn_id] [char](16) NULL,
    [updated_date] [datetime] NOT NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_updated_date]  DEFAULT (getdate()),
    [uid] [uniqueidentifier] NULL CONSTRAINT [DF_DISCOVERED_CELL_ID_uid]  DEFAULT (newsequentialid()),
    [RNCID] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

"Hilary Cotter" wrote:

> Merger replication will put this column in place.  Can you script out your
> problem table - DISCOVERED_CELL_ID and post it here?
>
>
> "Pingx" <[e-mail]> wrote in message
> news:[e-mail]...
> > Hi Sql Server Experts,
> >
> > I created a Merge replication, when I ran the replication agant at the
> > subscriber side, I got the following error (in the job history log)
> >
> > ate 5/12/2008 7:41:00 PM
> > Log Job History (GLSQL2-SUPL-pub_supl_to_glsql3-GLSQL3-SUPL- 0)
> >
> > Step ID 1
> > Server GLSQL3
> > Job Name GLSQL2-SUPL-pub_supl_to_glsql3-GLSQL3-SUPL- 0
> > Step Name Run agent.
> > Duration 00:00:23
> > Sql Severity 0
> > Sql Message ID 0
> > Operator Emailed
> > Operator Net sent
> > Operator Paged
> > Retries Attempted 0
> >
> > Message
> > 2008-05-12 19:41:11.212 [56%] [1 sec remaining] Bulk copying data into
> > table
> > 'MSmerge_genhistory'
> > 2008-05-12 19:41:11.306 [56%] [1 sec remaining] Bulk copied data into
> > table
> > 'MSmerge_contents' (0 rows)
> > 2008-05-12 19:41:11.400 [56%] [1 sec remaining] Bulk copying data into
> > table
> > 'sysmergesubsetfilters'
> > 2008-05-12 19:41:11.509 [56%] [1 sec remaining] Bulk copied data into
> > table
> > 'sysmergesubsetfilters' (0 rows)
> > 2008-05-12 19:41:11.618 [56%] [1 sec remaining] Bulk copied data into
> > table
> > 'MSmerge_genhistory' (1 rows)
> > 2008-05-12 19:41:23.025 The schema script 'DISCOVERED_CELL_ID_2.prc' could
> > not be propagated to the subscriber.
> > 2008-05-12 19:41:23.228 Category:NULL
> > Source:  Merge Replication Provider
> > Number:  -2147201001
> > Message: The schema script 'DISCOVERED_CELL_ID_2.prc' could not be
> > propagated to the subscriber.
> > 2008-05-12 19:41:23.321 Category:NULL
> > Source:  Microsoft SQL Native Client
> > Number:  207
> > Message: Invalid column name 'rowguid'.
> > ----------------------------------------------------
> >
> > I did not have the column rowguid in the publisher table before setting up
> > the replication. This column was created by  replication (creating
> > publiser).
> > How do I deal with this?
> >
> > Thanks.
> > Pingx
>
>

Answer 3

Hi there ,

When i start a subscriber replication olways i get this message (Bulk copied data into table 'sysmergesubsetfilters' (0 rows))

How to fix it ???