"Maj_Hazard" <Maj_Hazard@discussions.microsoft.com> wrote in message
news:EF8D6563-C5F8-4F26-BD9C-C1A167451733@microsoft.com...
> Top of the day all..
>
> I'm new to replication as well as SQL in general so please excuse my
> ignorance..
>
> I've run into a replication problem which is driving me nuts and any help
> would be appreciated..
>
> The basics
>
>
> Two MS SQL 2000 Servers with SP4 installed.
>
> - Bi Directional Merge replication enabled between 2 databases.
> - Servers connected via WAN with 1 server on the east coast and 1 on west.
> - Windows 2003 Enterprise Servers with current SP's
>
> After Replication is up and running successfully for a few hours I will
> get
> the following error.
>
> The process could not enumerate changes at the 'Publisher
> Ambiguous column name 'rowguid'
>
> Once the error pops up I'm dead in the water as everything I've tried will
> not resolve the error.
> I've resync'd
> I've reinilitized
> I've deleted the advertisement and recreated with the same negative
> results.
> The only difference I've seen is once the error pops up the first time any
> changes or re-creation of the advertisement results in the error right
> away.
> The replication never works even for a few hours like after the first
> time.
> To resolve I need to delete the advertisement and publication and start
> from
> scratch. After which the error will resurface after a few hours. At best I've
> had the process working for a day and a bit.
>
> I turned on error tracking in the merge agent to try and get more details
> but I cannot find a clue. I've copied the results below.
>
> Just a note
>
> To get the Replication up and running the first time I needed to perform
> the
> following steps prior to creating the publication and advertisement.
>
> Turn off Full Text Indexing for the Database on the publisher
> Delete all the index catalogs on Publisher
> Advertisement set to create new database on target server.
> Once rollout is complete full text indexing is turned back on both
> publisher
> and subscriber
>
>
> Any thoughts or hints would be greatly appreciated....
>
> Humbly
>
> New to SQL but trying
>
> Mike
>
>
>
>
>
>
> [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call sp_MSenumcolumns
> (?,?)}
> [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call sp_MSenumcolumns
> (?,?)}
> [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call sp_MSenumcolumns
> (?,?)}
> The process could not enumerate changes at the 'Publisher'.
> [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> The process could not enumerate changes at the 'Publisher'.
> The process could not enumerate changes at the 'Publisher'.
> The process could not deliver delete(s) at the 'Subscriber'.
> Percent Complete: 4
> Downloaded 97 data changes (0 inserts, 0 updates, 97 deletes, 0
> conflicts).
> Repl Agent Status: 3
> Percent Complete: 4
> Downloaded 98 data changes (0 inserts, 0 updates, 98 deletes, 0
> conflicts).
> Repl Agent Status: 3
> Percent Complete: 0
> The process could not enumerate changes at the 'Publisher'.
> Repl Agent Status: 6
> Percent Complete: 0
> Category:NULL
> Source: Merge Replication Provider
> Number: -2147200999
> Message: The process could not enumerate changes at the 'Publisher'.
> Repl Agent Status: 3
> Percent Complete: 0
> Category:COMMAND
> Source: Failed Command
> Number: 0
> Message: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> Repl Agent Status: 3
> Percent Complete: 0
> Category:SQLSERVER
> Source: MSRSSUMMATION1
> Number: 209
> Message: Ambiguous column name 'rowguid'.
> Repl Agent Status: 3
> Percent Complete: 0
> Category:NULL
> Source: Merge Replication Provider
> Number: -2147200988
> Message: The process was successfully stopped.
> Repl Agent Status: 3
> Disconnecting from Publisher 'MSRSSUMMATION1'
> Disconnecting from Subscriber 'MSRSBCSUMMATION'
> Disconnecting from Publisher 'MSRSSUMMATION1'
> Disconnecting from Publisher 'MSRSSUMMATION1'
> Disconnecting from Publisher 'MSRSSUMMATION1'
> Disconnecting from Publisher 'MSRSSUMMATION1'
> Disconnecting from Subscriber 'MSRSBCSUMMATION'
> Disconnecting from Subscriber 'MSRSBCSUMMATION'
> Disconnecting from Subscriber 'MSRSBCSUMMATION'
> Disconnecting from Subscriber 'MSRSBCSUMMATION'
> Disconnecting from Publisher 'MSRSSUMMATION1'
> Disconnecting from Distributor 'MSRSSUMMATION1'
>
>
> PS... Did I mention I'm desperate..????
>

"Hilary Cotter" wrote:

> does this apply?
>
> http://www.dbforums.com/archive/index.php/t-1107912.html
>
> --
> Hilary Cotter
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "Maj_Hazard" <Maj_Hazard@discussions.microsoft.com> wrote in message
> news:EF8D6563-C5F8-4F26-BD9C-C1A167451733@microsoft.com...
> > Top of the day all..
> >
> > I'm new to replication as well as SQL in general so please excuse my
> > ignorance..
> >
> > I've run into a replication problem which is driving me nuts and any help
> > would be appreciated..
> >
> > The basics
> >
> >
> > Two MS SQL 2000 Servers with SP4 installed.
> >
> > - Bi Directional Merge replication enabled between 2 databases.
> > - Servers connected via WAN with 1 server on the east coast and 1 on west.
> > - Windows 2003 Enterprise Servers with current SP's
> >
> > After Replication is up and running successfully for a few hours I will
> > get
> > the following error.
> >
> > The process could not enumerate changes at the 'Publisher
> > Ambiguous column name 'rowguid'
> >
> > Once the error pops up I'm dead in the water as everything I've tried will
> > not resolve the error.
> > I've resync'd
> > I've reinilitized
> > I've deleted the advertisement and recreated with the same negative
> > results.
> > The only difference I've seen is once the error pops up the first time any
> > changes or re-creation of the advertisement results in the error right
> > away.
> > The replication never works even for a few hours like after the first
> > time.
> > To resolve I need to delete the advertisement and publication and start
> > from
> > scratch. After which the error will resurface after a few hours. At best I've
> > had the process working for a day and a bit.
> >
> > I turned on error tracking in the merge agent to try and get more details
> > but I cannot find a clue. I've copied the results below.
> >
> > Just a note
> >
> > To get the Replication up and running the first time I needed to perform
> > the
> > following steps prior to creating the publication and advertisement.
> >
> > Turn off Full Text Indexing for the Database on the publisher
> > Delete all the index catalogs on Publisher
> > Advertisement set to create new database on target server.
> > Once rollout is complete full text indexing is turned back on both
> > publisher
> > and subscriber
> >
> >
> > Any thoughts or hints would be greatly appreciated....
> >
> > Humbly
> >
> > New to SQL but trying
> >
> > Mike
> >
> >
> >
> >
> >
> >
> > [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> > sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> > [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call sp_MSenumcolumns
> > (?,?)}
> > [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> > sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> > [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call sp_MSenumcolumns
> > (?,?)}
> > [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> > sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> > [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> > sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> > [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call sp_MSenumcolumns
> > (?,?)}
> > The process could not enumerate changes at the 'Publisher'.
> > [1/22/2007 3:27:09 PM]MSRSSUMMATION1.ct_repository: {call
> > sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> > The process could not enumerate changes at the 'Publisher'.
> > The process could not enumerate changes at the 'Publisher'.
> > The process could not deliver delete(s) at the 'Subscriber'.
> > Percent Complete: 4
> > Downloaded 97 data changes (0 inserts, 0 updates, 97 deletes, 0
> > conflicts).
> > Repl Agent Status: 3
> > Percent Complete: 4
> > Downloaded 98 data changes (0 inserts, 0 updates, 98 deletes, 0
> > conflicts).
> > Repl Agent Status: 3
> > Percent Complete: 0
> > The process could not enumerate changes at the 'Publisher'.
> > Repl Agent Status: 6
> > Percent Complete: 0
> > Category:NULL
> > Source: Merge Replication Provider
> > Number: -2147200999
> > Message: The process could not enumerate changes at the 'Publisher'.
> > Repl Agent Status: 3
> > Percent Complete: 0
> > Category:COMMAND
> > Source: Failed Command
> > Number: 0
> > Message: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> > Repl Agent Status: 3
> > Percent Complete: 0
> > Category:SQLSERVER
> > Source: MSRSSUMMATION1
> > Number: 209
> > Message: Ambiguous column name 'rowguid'.
> > Repl Agent Status: 3
> > Percent Complete: 0
> > Category:NULL
> > Source: Merge Replication Provider
> > Number: -2147200988
> > Message: The process was successfully stopped.
> > Repl Agent Status: 3
> > Disconnecting from Publisher 'MSRSSUMMATION1'
> > Disconnecting from Subscriber 'MSRSBCSUMMATION'
> > Disconnecting from Publisher 'MSRSSUMMATION1'
> > Disconnecting from Publisher 'MSRSSUMMATION1'
> > Disconnecting from Publisher 'MSRSSUMMATION1'
> > Disconnecting from Publisher 'MSRSSUMMATION1'
> > Disconnecting from Subscriber 'MSRSBCSUMMATION'
> > Disconnecting from Subscriber 'MSRSBCSUMMATION'
> > Disconnecting from Subscriber 'MSRSBCSUMMATION'
> > Disconnecting from Subscriber 'MSRSBCSUMMATION'
> > Disconnecting from Publisher 'MSRSSUMMATION1'
> > Disconnecting from Distributor 'MSRSSUMMATION1'
> >
> >
> > PS... Did I mention I'm desperate..????
> >
>
>