Merge Replication issue

  • I am receiving the below every minute after I setup a merge replication between SQL Server 2005 and SQL Server 2005 CE. The subscription is on the CE install. I am at a lose to how to resolve this issue. Everything seems to be working (i.e. snapshots, reinitialization of subscriptions.). Any guidance would be appreciated!

    Event Type:Error

    Event Source:MSSQLSERVER

    Event Category:(2)

    Event ID:14151

    Date:5/27/2011

    Time:6:08:06 PM

    User:N/A

    Computer:CHEMSQL1

    Description:

    Replication-Replication Merge Subsystem: agent 0038007B-0038-0034-4300-330042003500 failed. The Subscriber's schema version information is inconsistent with the Publisher's schema version information. It is likely that the Publisher has been restored from a backup whose schema change version is different from the Subscriber. Rerun the Snapshot a

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 47 37 00 00 12 00 00 00 G7......

    0008: 09 00 00 00 43 00 48 00 ....C.H.

    0010: 45 00 4d 00 53 00 51 00 E.M.S.Q.

    0018: 4c 00 31 00 00 00 0d 00 L.1.....

    0020: 00 00 64 00 69 00 73 00 ..d.i.s.

    0028: 74 00 72 00 69 00 62 00 t.r.i.b.

    0030: 75 00 74 00 69 00 6f 00 u.t.i.o.

    0038: 6e 00 00 00 n...

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

  • Some more information that could be helpful. The Distributor and Publish live on the SQL Server 2005 instance and the CE on another. They are both on the same server.

    A clever person solves a problem. A wise person avoids it. ~ Einstein
    select cast (0x5365616E204465596F756E67 as varchar(128))

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply