replication error - agent is suspect

Hi,
I have set up a replication and it was doing the bulk copy from SrvA to
SrvB when it says "The agent is suspect as there's no response for the last
10 mins" or something like that ?
what could be the problem here ?
however, after i refresh it , it keeps running though but i am unsure if the
data has been successfully replicated over as the processing's running
appreciate any advise
tks & rdgs
Hi,
See the previous posts:-
http://groups.google.co.in/group/mic...36c788aeacadb7
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:13D1D8DF-E095-4F6C-9CAB-06D63015A95D@.microsoft.com...
> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the
> last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if
> the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs
|||Hi ,
I have managed to resolve this issue by increasing the default 10 mins of
agent inactivity
tks & rdgs
"maxzsim" wrote:

> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs

replication error - agent is suspect

Hi,
I have set up a replication and it was doing the bulk copy from SrvA to
SrvB when it says "The agent is suspect as there's no response for the last
10 mins" or something like that ?
what could be the problem here ?
however, after i refresh it , it keeps running though but i am unsure if the
data has been successfully replicated over as the processing's running
appreciate any advise
tks & rdgsHi,
See the previous posts:-
http://groups.google.co.in/group/mi...936c788aeacadb7
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:13D1D8DF-E095-4F6C-9CAB-06D63015A95D@.microsoft.com...
> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the
> last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if
> the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs|||Hi ,
I have managed to resolve this issue by increasing the default 10 mins of
agent inactivity
tks & rdgs
"maxzsim" wrote:

> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the las
t
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if t
he
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs

replication error - agent is suspect

Hi,
I have set up a replication and it was doing the bulk copy from SrvA to
SrvB when it says "The agent is suspect as there's no response for the last
10 mins" or something like that ?
what could be the problem here ?
however, after i refresh it , it keeps running though but i am unsure if the
data has been successfully replicated over as the processing's running
appreciate any advise
tks & rdgsHi,
See the previous posts:-
http://groups.google.co.in/group/microsoft.public.sqlserver.replication/browse_thread/thread/45cba0e7e1543879/7936c788aeacadb7?q=replication+agent+is+suspect&rnum=2&hl=en#7936c788aeacadb7
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:13D1D8DF-E095-4F6C-9CAB-06D63015A95D@.microsoft.com...
> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the
> last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if
> the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs|||Hi ,
I have managed to resolve this issue by increasing the default 10 mins of
agent inactivity
tks & rdgs
"maxzsim" wrote:
> Hi,
> I have set up a replication and it was doing the bulk copy from SrvA to
> SrvB when it says "The agent is suspect as there's no response for the last
> 10 mins" or something like that ?
> what could be the problem here ?
> however, after i refresh it , it keeps running though but i am unsure if the
> data has been successfully replicated over as the processing's running
> appreciate any advise
> tks & rdgs

replication - agent is suspect

I setup a client with merge replication, the following error was
returned after working successfully for a day "The agent is suspect.
No response within the last 10 minutes". Most research I found on
the newsgroup is this error does not stop merge replication from
working, but in my case it did stop replication from working. I was
able to get to working again by running the following command.
sp_replication_agent_checkup @.heartbeat_interval = 6000
Can anybody explain why replication stopped working altogether with the
agent is suspect message, and what can I do to avoid this message to
begin with?
Thank you,
Pauly C
Suspect means that the agent hasn't communicated with the job subsystem in
the interval defined in the heartbeat_interval.
The job will be failed after the heartbeat_interval has passed, but I am not
exactly sure when.
The agent could be busy, dead, or trying to connect. Run profiler on the
subscriber to try to figure out what is going on. Profiler might not reveal
anything. There is a condition when the publisher or subscriber has
exhausted buffers and hangs on initialization. You can clear this by
rebooting.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"paulysc" <paulysc@.optonline.net> wrote in message
news:1141228700.833217.245870@.t39g2000cwt.googlegr oups.com...
>I setup a client with merge replication, the following error was
> returned after working successfully for a day "The agent is suspect.
> No response within the last 10 minutes". Most research I found on
> the newsgroup is this error does not stop merge replication from
> working, but in my case it did stop replication from working. I was
> able to get to working again by running the following command.
> sp_replication_agent_checkup @.heartbeat_interval = 6000
> Can anybody explain why replication stopped working altogether with the
> agent is suspect message, and what can I do to avoid this message to
> begin with?
> Thank you,
> Pauly C
>
|||I saw this error message if the job runs against a wrong database. In my
case, the Queue Reader was running against the master database, not the
distribution, which resulted to the same error message as yours.
hope it helps,
FJY
"paulysc" wrote:

> I setup a client with merge replication, the following error was
> returned after working successfully for a day "The agent is suspect.
> No response within the last 10 minutes". Most research I found on
> the newsgroup is this error does not stop merge replication from
> working, but in my case it did stop replication from working. I was
> able to get to working again by running the following command.
> sp_replication_agent_checkup @.heartbeat_interval = 6000
> Can anybody explain why replication stopped working altogether with the
> agent is suspect message, and what can I do to avoid this message to
> begin with?
> Thank you,
> Pauly C
>