June 2, 2011 at 12:43 am
--sql server version - Microsoft SQL Server 2000 - 8.00.2050
--source server - server-xxxxx
--SUBCRIBER DB - SUBSERVERa
--Database- TESTDBa
--Table- TESTTABLEa,TESTTABLEb
-- output captured after enabling- -Output <Path .txt> -Outputverboselevel [3]
-
-
-
-
Last transaction timestamp: 0x000de8b7000003f8000400000000
Transaction seqno: 0x000de8b7000004230001
Command Id: 1
Partial: 0
Type: 30
Command: <<parameterized command>>
Agent message code 20082. Error at parameter 99 during datastream processing of parameterized command.
Repl Agent Status: 5
[6/2/2011 9:42:24 AM]SERVER-XXXX.distribution: {call sp_MSadd_distribution_history(72, 5, ?, ?, 0, 0, 0.00, 0x01, 1, ?, 1, 0x00, 0x01)}
Adding alert to msdb..sysreplicationalerts: ErrorId = 3047,
Transaction Seqno = 000de8b600001b33000100000000, Command ID = 1
Message: Replication-Replication Distribution Subsystem: agent SERVER-XXXX-AR-SUBSERVERa-72 scheduled for retry. Error at parameter 99 during datastream processing of parameterized command.[6/2/2011 9:42:24 AM]SERVER-XXXX.distribution: {call sp_MSadd_repl_alert(3, 72, 3047, 14152, ?, 1, N'SERVER-XXXX', N'AR', N'SUBSERVERa', N'AR', ?)}
ErrorId = 3047, SourceTypeId = 1
ErrorCode = ''
ErrorText = '{CALL sp_MSupd_TESTTABLEa (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2011-05-31 14:43:23.720,2011-05-31 14:43:23.720,NULL,NULL,61716377,0x0000000c)} {CALL sp_MSupd_TESTTABLEa (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,253,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61716377,0x00000400)} {CALL sp_MSins_TESTTABLEb (5785834, 35'
[6/2/2011 9:42:24 AM]SERVER-XXXX.distribution: {call sp_MSadd_repl_error(3047, 0, 1, ?, N'', ?)}
Category:COMMAND
Source: Failed Command
Number:
Message: {CALL sp_MSupd_TESTTABLEa (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2011-05-31 14:43:23.720,2011-05-31 14:43:23.720,NULL,NULL,61716377,0x0000000c)} {CALL sp_MSupd_TESTTABLEa (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,253,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61716377,0x00000400)} {CALL sp_MSins_TESTTABLEb (5785834, 35
Repl Agent Status: 3
ErrorId = 3047, SourceTypeId = 5
ErrorCode = '11'
ErrorText = 'General network error. Check your network documentation.'
[6/2/2011 9:42:24 AM]SERVER-XXXX.distribution: {call sp_MSadd_repl_error(3047, 0, 5, ?, N'11', ?)}
Category:SQLSERVER
Source: SUBSERVERa
Number: 11
Message: General network error. Check your network documentation.
Repl Agent Status: 3
ErrorId = 3047, SourceTypeId = 4
ErrorCode = '08S01'
ErrorText = 'Communication link failure'
[6/2/2011 9:42:24 AM]SERVER-XXXX.distribution: {call sp_MSadd_repl_error(3047, 0, 4, ?, N'08S01', ?)}
Category:ODBC
Source: ODBC SQL Server Driver
Number: 08S01
Message: Communication link failure
Repl Agent Status: 3
[6/2/2011 9:42:24 AM]SUBSERVERa.TESTDBa: exec dbo.sp_MSupdatelastsyncinfo N'SERVER-XXXX',N'TESTDBa', N'', 0, 5, N'Error at parameter 99 during datastream processing of parameterized command.'
Disconnecting from Subscriber 'SUBSERVERa'
Disconnecting from Distributor 'SERVER-XXXX'
Disconnecting from Distributor History 'SERVER-XXXX'
The agent failed with a 'Retry' status. Try to run the agent at a later time.
Early reply is appreciated
June 2, 2011 at 2:09 am
seems like there is issue with your network to replicate commands/transaction across network to subscriber.
Open replication monitor and see the error there.
Try to resync it again if there are not much articles or else reconfigure transactional replication if there are lot of transaction in wait for sync.
----------
Ashish
June 2, 2011 at 2:11 am
That looks very much like it's just a problem with the publisher not being able to connect to the subscriber.
June 2, 2011 at 3:13 am
Thank you, we checked, connectivity is fine only this transactional replication fails all other succeeds we even tried to drop and recreate it, but does not work, confused about the message - Error at parameter 99 during datastream processing of parameterized command
June 2, 2011 at 3:49 am
seems like conflicting with some objects.
Can you try to just replicate one table and see how it goes?
----------
Ashish
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply