Merge Replication Hangs at Connecting To Subscriber

This has been working great up until last night when I manuall stopped the
merge publication while it was publishing. When I tried to start it again
the merge agent pushing the data to remote SQL 2k does not get past
'Connecting to Subscriber: XXX'
Below I have pasted the log file and the agent startup parameters.
Agent Config:
-Publisher [SQL_PUBLISHER] -PublisherDB [DB_Source] -Publication
[Pub_Products] -Subscriber [SQL_SUBSCRIBER] -SubscriberDB [DB_Target]
-Distributor [SQL_PUBLISHER] -DistributorSecurityMode 1 -Continuous -Output
c:\mergeDebug.txt -OutputVerboseLevel 2
Debug Log (ran for 30 min):
**** Start Of Log ****
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent:
SQL_PUBLISHER-DB_Source-Pub_Products-SQL_SUBSCRIBER-6
Percent Complete: 0
Connecting to Distributor 'SQL_PUBLISHER'
Connecting to Distributor 'SQL_PUBLISHER.'
Server: SQL_PUBLISHER
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
[4/14/2005 10:31:37 AM]SQL_PUBLISHER.: {call sp_MSgetversion }
[4/14/2005 10:31:37 AM]SQL_PUBLISHER.: {call sp_helpdistpublisher
(N'SQL_PUBLISHER') }
[4/14/2005 10:31:37 AM]SQL_PUBLISHER.BackOfficeDistribution: select
datasource, srvid from master..sysservers where upper(srvname) =
upper(N'SQL_PUBLISHER')
[4/14/2005 10:31:37 AM]SQL_PUBLISHER.BackOfficeDistribution: select
datasource, srvid from master..sysservers where upper(srvname) =
upper(N'SQL_SUBSCRIBER')
[4/14/2005 10:31:37 AM]SQL_PUBLISHER.BackOfficeDistribution: {call
sp_MShelp_merge_agentid (0, N'DB_Source', N'Pub_Products', 1, N'DB_Target')}
[4/14/2005 10:31:37 AM]SQL_PUBLISHER.BackOfficeDistribution: {call
sp_MShelp_profile (6, 4, N'')}
Percent Complete: 0
Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
Initializing
Server: SQL_PUBLISHER
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
[4/14/2005 10:31:38 AM]SQL_PUBLISHER.DB_Source: set nocount on declare
@.dbname sysname select @.dbname = db_name() declare @.collation nvarchar(255)
select @.collation = convert(nvarchar(255), databasepropertyex(@.dbname,
N'COLLATION')) select collationproperty(@.collation, N'CODEPAGE') as
'CodePage', collationproperty(@.collation, N'LCID') as 'LCID',
collationproperty(@.collation, N'COMPARISONSTYLE') as 'ComparisonStyle'
Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
Server: SQL_PUBLISHER
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
[4/14/2005 10:31:38 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
Percent Complete: 1
Connecting to Publisher 'SQL_PUBLISHER'
[4/14/2005 10:31:38 AM]SQL_PUBLISHER.BackOfficeDistribution: {call
sp_MShelp_subscriber_info (N'SQL_PUBLISHER', N'SQL_SUBSCRIBER')}
Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
Server: SQL_SUBSCRIBER
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
[4/14/2005 10:31:38 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
Percent Complete: 2
Connecting to Subscriber 'SQL_SUBSCRIBER'
Percent Complete: 3
Retrieving publication information
Percent Complete: 4
Retrieving subscription information
Percent Complete: 4
The merge process is cleaning up meta data in database 'DB_Source'.
Percent Complete: 4
The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s) in
MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
Percent Complete: 4
The merge process is cleaning up meta data in database 'DB_Target'.
Percent Complete: 4
The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s) in
MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
Percent Complete: 4
Uploading data changes to the Publisher
Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
Server: SQL_SUBSCRIBER
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
[4/14/2005 10:31:40 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
Server: SQL_PUBLISHER
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
[4/14/2005 10:31:40 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
Server: SQL_SUBSCRIBER
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
[4/14/2005 10:31:40 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
Server: SQL_PUBLISHER
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
[4/14/2005 10:31:41 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
Server: SQL_SUBSCRIBER
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
[4/14/2005 10:31:41 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
Server: SQL_PUBLISHER
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
[4/14/2005 10:31:41 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
Server: SQL_SUBSCRIBER
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
[4/14/2005 10:31:41 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
Server: SQL_PUBLISHER
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
[4/14/2005 10:31:41 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
**** End Of Log ****
there is a condition where resources are depleted on the publisher or
subcriber which could show up as this. Stop and start SQL Server to see if
it clears it.
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
"thejoneser" <thejoneser@.discussions.microsoft.com> wrote in message
news:C6C25879-5B53-43EE-9ACE-BB12C77FF7A4@.microsoft.com...
> This has been working great up until last night when I manuall stopped the
> merge publication while it was publishing. When I tried to start it again
> the merge agent pushing the data to remote SQL 2k does not get past
> 'Connecting to Subscriber: XXX'
> Below I have pasted the log file and the agent startup parameters.
> Agent Config:
> -Publisher [SQL_PUBLISHER] -PublisherDB [DB_Source] -Publication
> [Pub_Products] -Subscriber [SQL_SUBSCRIBER] -SubscriberDB [DB_Target]
> -Distributor [SQL_PUBLISHER] -DistributorSecurityMode
1 -Continuous -Output
> c:\mergeDebug.txt -OutputVerboseLevel 2
> Debug Log (ran for 30 min):
> **** Start Of Log ****
> Microsoft SQL Server Merge Agent 8.00.760
> Copyright (c) 2000 Microsoft Corporation
> Microsoft SQL Server Replication Agent:
> SQL_PUBLISHER-DB_Source-Pub_Products-SQL_SUBSCRIBER-6
> Percent Complete: 0
> Connecting to Distributor 'SQL_PUBLISHER'
> Connecting to Distributor 'SQL_PUBLISHER.'
> Server: SQL_PUBLISHER
> 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
> [4/14/2005 10:31:37 AM]SQL_PUBLISHER.: {call sp_MSgetversion }
> [4/14/2005 10:31:37 AM]SQL_PUBLISHER.: {call sp_helpdistpublisher
> (N'SQL_PUBLISHER') }
> [4/14/2005 10:31:37 AM]SQL_PUBLISHER.BackOfficeDistribution: select
> datasource, srvid from master..sysservers where upper(srvname) =
> upper(N'SQL_PUBLISHER')
> [4/14/2005 10:31:37 AM]SQL_PUBLISHER.BackOfficeDistribution: select
> datasource, srvid from master..sysservers where upper(srvname) =
> upper(N'SQL_SUBSCRIBER')
> [4/14/2005 10:31:37 AM]SQL_PUBLISHER.BackOfficeDistribution: {call
> sp_MShelp_merge_agentid (0, N'DB_Source', N'Pub_Products', 1,
N'DB_Target')}
> [4/14/2005 10:31:37 AM]SQL_PUBLISHER.BackOfficeDistribution: {call
> sp_MShelp_profile (6, 4, N'')}
> Percent Complete: 0
> Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
> Initializing
> Server: SQL_PUBLISHER
> 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
> [4/14/2005 10:31:38 AM]SQL_PUBLISHER.DB_Source: set nocount on declare
> @.dbname sysname select @.dbname = db_name() declare @.collation
nvarchar(255)
> select @.collation = convert(nvarchar(255), databasepropertyex(@.dbname,
> N'COLLATION')) select collationproperty(@.collation, N'CODEPAGE') as
> 'CodePage', collationproperty(@.collation, N'LCID') as 'LCID',
> collationproperty(@.collation, N'COMPARISONSTYLE') as 'ComparisonStyle'
> Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
> Server: SQL_PUBLISHER
> 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
> [4/14/2005 10:31:38 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
> Percent Complete: 1
> Connecting to Publisher 'SQL_PUBLISHER'
> [4/14/2005 10:31:38 AM]SQL_PUBLISHER.BackOfficeDistribution: {call
> sp_MShelp_subscriber_info (N'SQL_PUBLISHER', N'SQL_SUBSCRIBER')}
> Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
> Server: SQL_SUBSCRIBER
> 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
> [4/14/2005 10:31:38 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
> Percent Complete: 2
> Connecting to Subscriber 'SQL_SUBSCRIBER'
> Percent Complete: 3
> Retrieving publication information
> Percent Complete: 4
> Retrieving subscription information
> Percent Complete: 4
> The merge process is cleaning up meta data in database 'DB_Source'.
> Percent Complete: 4
> The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s) in
> MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
> Percent Complete: 4
> The merge process is cleaning up meta data in database 'DB_Target'.
> Percent Complete: 4
> The merge process cleaned up 0 row(s) in MSmerge_genhistory, 0 row(s) in
> MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
> Percent Complete: 4
> Uploading data changes to the Publisher
> Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
> Server: SQL_SUBSCRIBER
> 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
> [4/14/2005 10:31:40 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
> Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
> Server: SQL_PUBLISHER
> 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
> [4/14/2005 10:31:40 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
> Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
> Server: SQL_SUBSCRIBER
> 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
> [4/14/2005 10:31:40 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
> Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
> Server: SQL_PUBLISHER
> 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
> [4/14/2005 10:31:41 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
> Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
> Server: SQL_SUBSCRIBER
> 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
> [4/14/2005 10:31:41 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
> Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
> Server: SQL_PUBLISHER
> 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
> [4/14/2005 10:31:41 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
> Connecting to Subscriber 'SQL_SUBSCRIBER.DB_Target'
> Server: SQL_SUBSCRIBER
> 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
> [4/14/2005 10:31:41 AM]SQL_SUBSCRIBER.DB_Target: {call sp_MSgetversion }
> Connecting to Publisher 'SQL_PUBLISHER.DB_Source'
> Server: SQL_PUBLISHER
> 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
> [4/14/2005 10:31:41 AM]SQL_PUBLISHER.DB_Source: {call sp_MSgetversion }
> **** End Of Log ****
>
|||Thanks Hilary.
I had to get this fixed yesterday so I deleted the subscription. Did a
manual sync using a scripting tool, then recreated the subscription.
I'm going to try and get my hands on the current hotfix baseline build since
several similar merge replication issues seem to be fixed in it.
-- Chris
"Hilary Cotter" wrote:

> there is a condition where resources are depleted on the publisher or
> subcriber which could show up as this. Stop and start SQL Server to see if
> it clears it.
> --
> 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
> "thejoneser" <thejoneser@.discussions.microsoft.com> wrote in message
> news:C6C25879-5B53-43EE-9ACE-BB12C77FF7A4@.microsoft.com...
> 1 -Continuous -Output
> N'DB_Target')}
> nvarchar(255)
>
>