Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2007
    Posts
    2

    Unanswered: help with error "The process could not enumerate changes at the 'Publisher"

    This may be a duplicate post as I think I placed the first in the wrong location.


    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 SPs

    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 recreation 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 Ive 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
    CategoryQLSERVER
    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'
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •