Thursday, March 22, 2012

cannot deliver inserts

HI we are using merge replication and now i am getting the
error message as ' cannot deliver inserts to the publisher'
Kiran,
does restarting the agent fix the issue? If not, then are you replicating to
CE - known issue there
(http://support.microsoft.com/default...b;en-us;328314). If neither
of these apply, then please enable logging
(http://support.microsoft.com/?id=312292) and post up further details of the
schema and error message>
Thanks,
Paul Ibison
|||HI paul thanks,
but we are using sql2000 merge replication.
so this article deosn't apply to us.

>--Original Message--
>Kiran,
>does restarting the agent fix the issue? If not, then are
you replicating to
>CE - known issue there
>(http://support.microsoft.com/default.aspx?scid=kb;en-
us;328314). If neither
>of these apply, then please enable logging
>(http://support.microsoft.com/?id=312292) and post up
further details of the
>schema and error message>
>Thanks,
>Paul Ibison
>
>.
>
|||Kiran,
ok, then check that the subscriber can 'see' the publisher using QA. If not,
then it's a connectivity issue, if it can then enable logging and post up
the message.
Regards,
Paul Ibison
|||Hi paul,
it was happening becos of the conflicts we had for that
subscriber. It was taking so long to reconcoile the
conflicts. i ended up recreating subscription and now it
seems fine.
thanks
>--Original Message--
>Kiran,
>ok, then check that the subscriber can 'see' the
publisher using QA. If not,
>then it's a connectivity issue, if it can then enable
logging and post up
>the message.
>Regards,
>Paul Ibison
>
>.
>
|||Kiran,
thanks for the update. Recreating the subscription has removed the conflicts
so you don't experience the same problem straight away. To prevent this
error in future, you might want to create a custom profile for your merge
agent and increase the QueryTimeOut .
Regards,
Paul Ibison

No comments:

Post a Comment