Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

problem with merge replication

 
   Database Forums (Home) -> Replication RSS
Next:  Fact Table(s) Design Question  
Author Message
Pingx

External


Since: Jan 16, 2008
Posts: 27



(Msg. 1) Posted: Wed Jan 16, 2008 7:01 pm
Post subject: problem with merge replication
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hi,
I ran an update query on the publisher.
When I start the merge agent manually, I got the following error after a
while.

The merge process failed to execute a query because the query timed out. If
this failure continues, increase the query timeout for the process. When
troubleshooting, restart the synchronization with verbose history logging and
specify an output file to which to write

Could you tell me how I can increase the query timeout for the process?
The replication is not moving now.

Thanks in advance.

Pingx

 >> Stay informed about: problem with merge replication 
Back to top
Login to vote
Hilary Cotter3

External


Since: Aug 28, 2004
Posts: 1259



(Msg. 2) Posted: Thu Jan 17, 2008 10:28 am
Post subject: Re: problem with merge replication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Right click on the agent, select agent properties, select steps, double
click on run agent, and at the end of the command string type -QueryTimeOut
600

--
http://www.zetainteractive.com - Shift Happens!

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
"Pingx" wrote in message

> Hi,
> I ran an update query on the publisher.
> When I start the merge agent manually, I got the following error after a
> while.
>
> The merge process failed to execute a query because the query timed out.
> If
> this failure continues, increase the query timeout for the process. When
> troubleshooting, restart the synchronization with verbose history logging
> and
> specify an output file to which to write
>
> Could you tell me how I can increase the query timeout for the process?
> The replication is not moving now.
>
> Thanks in advance.
>
> Pingx
>

 >> Stay informed about: problem with merge replication 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]