Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Merge replication issue

172 views
Skip to first unread message

Reuben Rinquest

unread,
Sep 2, 2009, 9:33:02 AM9/2/09
to
Hi There,

I'm running SQL merge replication between two servers. currently my job is
stuck on the following: "The process is running and is waiting for a response
from one of backend connections" and is not seeming to move from this. How
can I tell what it's doing or how can i get it start replication again as
before?

I'm runnning SQL 2000 (SP4) on Windows 2000 Server (SP4) with all latest MS
updates installed.

Thank you.
Reuben


Reuben Rinquest

unread,
Sep 2, 2009, 10:23:01 AM9/2/09
to

Please find below verbose output logging from the merge SQL replication:
(See last row for issue logged)
-----------------------------------------
Microsoft SQL Server Merge Agent 8.00.2055
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: ZA-DATA-Heat Product Developmen-Heat
Product Developmen-US-SUPPORT-GoldMine_Service_And_Su- 0

Percent Complete: 0
Connecting to Subscriber 'US-SUPPORT'
Connecting to Subscriber 'US-SUPPORT.GoldMine_Service_And_Support'

Server: US-SUPPORT
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:01 AM]US-SUPPORT.GoldMine_Service_And_Support: {call
sp_MSgetversion }
[9/2/2009 9:58:01 AM]US-SUPPORT.GoldMine_Service_And_Support: {?=call
sp_helpsubscription_properties (N'ZA-DATA', N'Heat Product Development',
N'Heat Product Development')}
Distributor security mode: 1, login name: sa, password: ********.
[9/2/2009 9:58:01 AM]US-SUPPORT.GoldMine_Service_And_Support: {?=call
sp_helpsubscription_properties (N'ZA-DATA', N'Heat Product Development',
N'Heat Product Development')}
Publisher security mode: 1, login name: , password: *********.
Percent Complete: 0
Connecting to Distributor 'ZA-DATA'
Connecting to Distributor 'ZA-DATA.'

Server: ZA-DATA
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:05 AM]ZA-DATA.: {call sp_MSgetversion }
[9/2/2009 9:58:05 AM]ZA-DATA.: {call sp_helpdistpublisher (N'ZA-DATA') }
[9/2/2009 9:58:06 AM]ZA-DATA.distribution: select datasource, srvid from
master..sysservers where upper(srvname) = upper(N'ZA-DATA')
[9/2/2009 9:58:07 AM]ZA-DATA.distribution: select datasource, srvid from
master..sysservers where upper(srvname) = upper(N'US-SUPPORT')
[9/2/2009 9:58:07 AM]ZA-DATA.distribution: {call sp_MShelp_merge_agentid (0,
N'Heat Product Development', N'Heat Product Development', 10,
N'GoldMine_Service_And_Support')}
[9/2/2009 9:58:08 AM]ZA-DATA.distribution: {call sp_MShelp_profile (27, 4,
N'')}
Connecting to Publisher 'ZA-DATA.Heat Product Development'
Percent Complete: 0
Initializing
Percent Complete: 1
Connecting to Publisher 'ZA-DATA'

Server: ZA-DATA
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:12 AM]ZA-DATA.Heat Product Development: 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 'ZA-DATA.Heat Product Development'

Server: ZA-DATA
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:18 AM]ZA-DATA.Heat Product Development: {call sp_MSgetversion }
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 'Heat Product
Development'.
Percent Complete: 4
The merge process cleaned up 236 row(s) in MSmerge_genhistory, 160 row(s) in
MSmerge_contents, and 131 row(s) in MSmerge_tombstone.
Percent Complete: 4
The merge process is cleaning up meta data in database
'GoldMine_Service_And_Support'.
Percent Complete: 4
The merge process cleaned up 340 row(s) in MSmerge_genhistory, 124 row(s) in
MSmerge_contents, and 0 row(s) in MSmerge_tombstone.
Percent Complete: 4
Uploading data changes to the Publisher
Connecting to Subscriber 'US-SUPPORT.GoldMine_Service_And_Support'

Server: US-SUPPORT
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:42 AM]US-SUPPORT.GoldMine_Service_And_Support: {call
sp_MSgetversion }
Connecting to Publisher 'ZA-DATA.Heat Product Development'

Server: ZA-DATA
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:46 AM]ZA-DATA.Heat Product Development: {call sp_MSgetversion }
Connecting to Subscriber 'US-SUPPORT.GoldMine_Service_And_Support'

Server: US-SUPPORT
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:47 AM]US-SUPPORT.GoldMine_Service_And_Support: {call
sp_MSgetversion }
Connecting to Publisher 'ZA-DATA.Heat Product Development'

Server: ZA-DATA
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:51 AM]ZA-DATA.Heat Product Development: {call sp_MSgetversion }
Connecting to Subscriber 'US-SUPPORT.GoldMine_Service_And_Support'

Server: US-SUPPORT
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:52 AM]US-SUPPORT.GoldMine_Service_And_Support: {call
sp_MSgetversion }
Connecting to Publisher 'ZA-DATA.Heat Product Development'

Server: ZA-DATA
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:56 AM]ZA-DATA.Heat Product Development: {call sp_MSgetversion }
Connecting to Subscriber 'US-SUPPORT.GoldMine_Service_And_Support'

Server: US-SUPPORT
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:58:56 AM]US-SUPPORT.GoldMine_Service_And_Support: {call
sp_MSgetversion }
Connecting to Publisher 'ZA-DATA.Heat Product Development'

Server: ZA-DATA
DBMS: Microsoft SQL Server
Version: 08.00.2055
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

[9/2/2009 9:59:01 AM]ZA-DATA.Heat Product Development: {call sp_MSgetversion }
Percent Complete: 4
Uploaded 88 data changes (31 inserts, 34 updates, 23 deletes, 0 conflicts).
Percent Complete: 4
Downloading data changes to the Subscriber
Percent Complete: 0
The process is running and is waiting for a response from one of the backend
connections.

---------------------------------------------

Reuben Rinquest

unread,
Sep 2, 2009, 10:34:10 AM9/2/09
to
When we stopped the SQL server service the following was logged:

-------------------------


The process is running and is waiting for a response from one of the backend
connections.

The process could not increment the lineage version.
The process could not increment the lineage version.
The process could not query row data at the 'Publisher'.
The process could not increment the lineage version.
Percent Complete: 0
The process was successfully stopped.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147200987
Message: The process was successfully stopped.
Disconnecting from Publisher 'ZA-DATA'
Disconnecting from Subscriber 'US-SUPPORT'
Disconnecting from Publisher 'ZA-DATA'
Disconnecting from Publisher 'ZA-DATA'
Disconnecting from Publisher 'ZA-DATA'
Disconnecting from Publisher 'ZA-DATA'
Disconnecting from Subscriber 'US-SUPPORT'
Disconnecting from Subscriber 'US-SUPPORT'
Disconnecting from Subscriber 'US-SUPPORT'
Disconnecting from Subscriber 'US-SUPPORT'
Disconnecting from Publisher 'ZA-DATA'
Disconnecting from Distributor 'ZA-DATA'
-------------------------

drewmann73

unread,
Sep 16, 2009, 1:46:22 AM9/16/09
to
HI,
i had this error and found running this script on client (subsriber) fixed
problem.

update sysmergepublications set [generation_leveling_threshold] = 0

Apparently this value can be set on the subscription properties in SQL on the
Server but I need to find this setting.

0 new messages