Post reply

Replication suddenly stopped between 2k5 and 2k

  • May 11, 2007 at 9:23 am

    #176350

    Please help...

    We have replication setup from a 2k5 enterprise server here in the UK to a 2k standard server in Sweden. It has been running for about 2 months without any problems but last night it just stopped.

    The replication monitor shows this message:

    Executed as user: . The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed.

    The previous job step in the history shows this:

    Date11/05/2007 16:10:00

    LogJob History (SQL10COL1UK-people_unicode-GPD_MERGE_DATA-SQL04STH1SE-7)

    Step ID2

    ServerSQL10COL1UK

    Job NameSQL10COL1UK-people_unicode-GPD_MERGE_DATA-SQL04STH1SE-7

    Step NameRun agent.

    Duration00:00:09

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    -XCMDLINE 0

    -XCancelEventHandle 000000000000041C

    -XParentProcessHandle 00000000000007C4

    2007-05-11 15:10:00.651 Connecting to Distributor 'SQL10COL1UK'

    2007-05-11 15:10:00.729 Initializing

    2007-05-11 15:10:00.729 Connecting to Publisher 'SQL10COL1UK'

    2007-05-11 15:10:01.526 Connecting to Subscriber 'SQL04STH1SE'

    2007-05-11 15:10:01.526 Retrieving publication information

    2007-05-11 15:10:01.526 Retrieving subscription information.

    2007-05-11 15:10:03.744 Uploading data changes to the Publisher

    2007-05-11 15:10:05.244 Enumerating deletes in all articles (generation batch 1)

    2007-05-11 15:10:05.307 Enumerating inserts and updates in article 'adapter_status' (generation batch 1)

    2007-05-11 15:10:05.432 Enumerating inserts and updates in article 'TelephoneNumber' (generation batch 1)

    2007-05-11 15:10:05.479 Enumerating inserts and updates in article 'Person' (generation batch 1)

    2007-05-11 15:10:05.635 Enumerating inserts and updates in article 'Photograph' (generation batch 1)

    And then it just stops... There are plenty more articles than that!

    I thought this might be a rights issue, but I can create a terminal services session onto the UK server using the service account that the merge agent uses, and log on to the Swedish server and query the database. Also the user is in the local admin group of both the UK and the Swedish server.

    Please help!

    --------
    [font="Tahoma"]I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams[/font]

  • June 12, 2007 at 12:55 pm

    #712376

    have you tried to run it manually?

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

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