We have a publisher and 2 subsribers. The
subscribers are spanning 2 transactions/sec. We have
implemented merge replication and it was scheduled
to occur every 5 min. When we ran it for the first time with a
transaction rate of 75k/hr it ran for 4 days.After sometime we got
problems so we reduced the transaction rate to 12k/hr then,
the replications is going on without any problem for
sometime(may be some hours), but after that it
failes with the message, "the process could not
deliver inserts at the publisher". When
I searched for this error in google, it asked me to
increase the queytimeout value in agent profile. So
I increased it from 300 to 600, but in vain. Now the merge agent is
failing as soon as it is started.We have a dedicated network for this
replication. If
anybody could help me in this, that would be great.
windows: windows 2003 server, sql server: sql server 2000 standard
edition.
Failing as soon as started, might be syntax error w/ QueryTimeout switch.
Confirm you added to end of Run Agent step:
-QueryTimeout 0
0 = unlimited
ChrisB
MCDBA OCP
www.MyDatabaseAdmin.com
"sqldbapree" wrote:
> We have a publisher and 2 subsribers. The
> subscribers are spanning 2 transactions/sec. We have
> implemented merge replication and it was scheduled
> to occur every 5 min. When we ran it for the first time with a
> transaction rate of 75k/hr it ran for 4 days.After sometime we got
> problems so we reduced the transaction rate to 12k/hr then,
> the replications is going on without any problem for
> sometime(may be some hours), but after that it
> failes with the message, "the process could not
> deliver inserts at the publisher". When
> I searched for this error in google, it asked me to
> increase the queytimeout value in agent profile. So
> I increased it from 300 to 600, but in vain. Now the merge agent is
> failing as soon as it is started.We have a dedicated network for this
> replication. If
> anybody could help me in this, that would be great.
> windows: windows 2003 server, sql server: sql server 2000 standard
> edition.
>
sql
Wednesday, March 21, 2012
merge replication problem;urgent
Labels:
database,
haveimplemented,
merge,
microsoft,
mysql,
oracle,
problemurgent,
publisher,
replication,
scheduledto,
sec,
server,
spanning,
sql,
subsribers,
thesubscribers,
transactions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment