merge agent replication.

• preethi mohan-250802

  SSC Rookie

  Points: 26

  More actions

  October 18, 2005 at 5:03 pm

  #115316

  We have a merge replication taking place for every 5 min inwhich the subscriber is populating the tables with 10 transactions/sec. We have 2 subscribers. It was failing with the error message, "the process could not deliver inserts at the publisher" may be after 12 hrs. We modified the query time out parameter in the merge agent profile from 300 to 600. Also we defragmented the published tables ans subscriber tables. we again started the replication process at night 7.30. When we came the next day morning we again got the same error message. but it ran successfully for I think 10 hrs. I'm just wondering can anyone help me in solving this problem as the database is very critical.

• October 21, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Asad Ijaz

  Newbie

  Points: 7

  More actions

  October 24, 2005 at 10:42 am

  #599591

  There must be an originating error message in the error thread. Can u check the error details? Maybe solution to your problem lies there.