Default timeout in Log Reader Agent is 0 ??

Last Post 10 May 2004 12:10 PM by Ali baba_SQL. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Ali baba_SQL
New Member
New Member

--
10 May 2004 10:43 AM
Sometimes replication fails, because the default Log Reader Agent timeout is 0. But is it really 0 milliseconds, or is it some default number, like 1000 ??

Maybe it could be set to be higher??
Ali baba_SQL
New Member
New Member

--
10 May 2004 12:10 PM
Here's the error:


Microsoft SQL Server Log Reader Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: Server A -70



Connecting to Publisher Server A'

Server:
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288

[5/10/2004 1:58:34 PM]Server A: select @@SERVERNAME
[5/10/2004 1:58:35 PM]Server A: sp_MSgetversion
Status: 4096, code: 20024, text: 'Initializing'.
The agent is running. Use Replication Monitor to view the details of this agent session.
Repl Agent Status: 3
Publisher: {call sp_repldone ( 0x00003a8800002c390001, 0x00003a8800002c390001, 0, 0)}
Publisher: {call sp_replcmds (500, 0)}
Status: 2, code: 0, text: 'The process could not execute 'sp_replcmds' on 'MY SQL'.'.
The process could not execute 'sp_replcmds' on 'MY SQL'.
Repl Agent Status: 5
Status: 2, code: 0, text: 'Timeout expired'.
Disconnecting from Publisher 'MY SQL'
The agent failed with a 'Retry' status. Try to run the agent at a later time.

Ali baba_SQL
New Member
New Member

--
10 May 2004 12:27 PM
Its a log file from Log Reader agent on the distributor
Ali baba_SQL
New Member
New Member

--
10 May 2004 04:48 PM
thanks rm
You are not authorized to post a reply.

Acceptable Use Policy