Wednesday, March 28, 2012

Replication Error

Hi all,
Please help me with issue. I have the following error accured always when
i
run the merge agent. I have 3 database makes replication, 2 are running
and
is giving this error:
LAST COMMAND : {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
The process could not enumerate changes at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
--
The merge process timed out while executing a query. Reconfigure the
QueryTimeout parameter and retry the operation.
(Source: SERV-COMPAQ (Data source); Error number: 0)
--
The process was successfully stopped.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
--
any help is realy appreciated.
thanks all.
Samir R. Ibrahim
I have did that on both servers. with the same result.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:372e01c4a553$224b3800$a301280a@.phx.gbl...
> Samir,
> try setting the QueryTimeout to 0 in the merge agent's
> job.
> HTH,
> Paul IBison
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Samir,
you could try running the merge agent again, but before
that, enable logging http://support.microsoft.com/?
id=312292
Rgds,
Paul Ibison
|||Thank you Paul for your help. i will give that a try.
Samir R. Ibrahim
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:2b2101c4a55a$a221cba0$a501280a@.phx.gbl...
> Samir,
> you could try running the merge agent again, but before
> that, enable logging http://support.microsoft.com/?
> id=312292
> Rgds,
> Paul Ibison
>

No comments:

Post a Comment