merge replication error ....urgent
-
hi,
i am facing a problem in merge replication which was setup in LAN with Push subscription. snapshot was successfully created and after that the merge process is failing with an error "Process could not retrieve the generation information at subscriber"..querytimeout value is unilimited on both publisher and subcriber machines...solution urgent pls
-
Hi,
Can you attach your replication log file? In case you dont have one you can create one by referring to
Regards,
Karthik
-
hi karthik,
tq for the reply..pls see hereunder the log output..
Microsoft SQL Server Merge Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: ERPSERVER-mejdafERP-mejdafERP-AL-KHOBER-4
Percent Complete: 0
Connecting to Distributor 'ERPSERVER'
Connecting to Distributor 'ERPSERVER.'
Server: ERPSERVER
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
[3/7/2005 11:27:44 AM]ERPSERVER.: {call sp_MSgetversion }
[3/7/2005 11:27:44 AM]ERPSERVER.: {call sp_helpdistpublisher (N'ERPSERVER') }
[3/7/2005 11:27:44 AM]ERPSERVER.distribution: select datasource, srvid from master..sysservers where upper(srvname) = upper(N'ERPSERVER')
[3/7/2005 11:27:44 AM]ERPSERVER.distribution: select datasource, srvid from master..sysservers where upper(srvname) = upper(N'AL-KHOBER')
[3/7/2005 11:27:44 AM]ERPSERVER.distribution: {call sp_MShelp_merge_agentid (0, N'mejdafERP', N'mejdafERP', 5, N'mejdafERP')}
[3/7/2005 11:27:44 AM]ERPSERVER.distribution: {call sp_MShelp_profile (4, 4, N'')}
Percent Complete: 0
Connecting to Publisher 'ERPSERVER.mejdafERP'
Initializing
Server: ERPSERVER
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
[3/7/2005 11:27:44 AM]ERPSERVER.mejdafERP: 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 'ERPSERVER.mejdafERP'
Server: ERPSERVER
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
Percent Complete: 1
Connecting to Publisher 'ERPSERVER'
[3/7/2005 11:27:44 AM]ERPSERVER.mejdafERP: {call sp_MSgetversion }
[3/7/2005 11:27:45 AM]ERPSERVER.distribution: {call sp_MShelp_subscriber_info (N'ERPSERVER', N'AL-KHOBER')}
Connecting to Subscriber 'AL-KHOBER.mejdafERP'
Server: AL-KHOBER
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
[3/7/2005 11:27:46 AM]AL-KHOBER.mejdafERP: {call sp_MSgetversion }
Percent Complete: 2
Connecting to Subscriber 'AL-KHOBER'
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 'mejdafERP'.
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 'mejdafERP'.
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
The merge process could not retrieve generation information at the 'Subscriber'.
Percent Complete: 0
The merge process could not retrieve generation information at the 'Subscriber'.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147201004
Message: The merge process could not retrieve generation information at the 'Subscriber'.
Percent Complete: 0
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call sp_MSenumgenerations (640100, ?, 1) }
Percent Complete: 0
Category:SQLSERVER
Source: AL-KHOBER
Number: 0
Message: The merge process timed out while executing a query. Reconfigure the QueryTimeout parameter and retry the operation.
Disconnecting from Subscriber 'AL-KHOBER'
Disconnecting from Publisher 'ERPSERVER'
Disconnecting from Publisher 'ERPSERVER'
Disconnecting from Distributor 'ERPSERVER'
pls help me
-
This line: "Message: The merge process timed out while executing a query. Reconfigure the QueryTimeout parameter and retry the operation."
Tells me that your replication is timing out. Open up the folder that contains the Merge Agent, right click on the agent and select Agent Profile. Scroll down to the Query Timeout and increase the number, or change the profile to "High Volume server-to-server profile"
This is what the screen looks like for the QueryTimeout
Just remember, this is only an opinion and it is best to make backups of all of your data before making any changes.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply