MS SQL Server Replication - Time out error

Author

Time out error - querytimeout value

SouRa

2005-09-16, 3:24 am

Hi ,

In order to mimic the time out error in our application,
I have doubled the query time out in agent profile from 5 minutes to 10
minutes.

But, now I am getting the below error messages frequently,

1. The process is running and waiting for a response from one of the backend
connections
2. The process could not make a generation at the ‘Publisher’
3. Initializing
4. Connecting to publisher ‘publisher name’
5. The process is running and waiting for a response from one of the
backend
connections
6. The process could not perform retention-based meta data cleanup in
database
'database name'

Please advise.

Thanks,
Soura

Hilary Cotter

2005-09-16, 9:23 am

basically querytimeout tells the replication subsystem to wait longer before
marking agents suspect. If the replication binary does not report back to
the replication subsystem within a certain amount of time you get the
waiting for response from backend components. This can be a benign warning
or it could be symptomatic of something more serious.

What happens when you repeatedly run this agent? Sometimes these errors are
transitory.

--
Hilary Cotter
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
"SouRa" <SouRa@discussions.microsoft.com> wrote in message
news:7EB4CEE9-2AA3-4C9B-90C6- F46DD6676227@microso
ft.com...
> Hi ,
>
> In order to mimic the time out error in our application,
> I have doubled the query time out in agent profile from 5 minutes to 10
> minutes.
>
> But, now I am getting the below error messages frequently,
>
> 1. The process is running and waiting for a response from one of the
backend
> connections
> 2. The process could not make a generation at the 'Publisher'
> 3. Initializing
> 4. Connecting to publisher 'publisher name'
> 5. The process is running and waiting for a response from one of the
> backend
> connections
> 6. The process could not perform retention-based meta data cleanup in
> database
> 'database name'
>
> Please advise.
>
> Thanks,
> Soura
>

Sponsored Links