sql server replication:
Hello
Im getting the error below on my Distribution Server.
"Error at parameter 1 during datastream processing of parameterized command."
I followed the article below and configured the Distribution to log the
error on a text file.
Article ID 312292 - HOW TO: Enable Replication Agents for Logging to Output
Files in SQL Server.
http://support.microsoft.com/?id=312292 The log file that I configure on the step above shows the error below:
"Agent message code 20082. Error at parameter 1 during datastream processing
of parameterized command.
[2/28/2005 11:02:09 AM]BBARPLP1\P64.distribution: {call
sp_MSadd_distribution_history(14, 6, ?, ?, 0, 0, 0.00, 0x01, 1, ?, 2341,
0x01, 0x01)}
Adding alert to msdb..sysreplicationalerts: ErrorId = 407,
Transaction Seqno = 0000429f00005bb8000100000000, Command ID = 2341
Message: Replication-Replication Distribution Subsystem: agent
BBASQLPROD1-64-BBA_MFMO-BBASQLPDD-14 failed. Error at parameter 1 during
datastream processing of parameterized command.[2/28/2005 11:02:09
AM]BBARPLP1\P64.distribution: {call sp_MSadd_repl_alert(3, 14, 407, 14151,
?, 2341, N'BBASQLPROD1-64', N'BBA_MFMO', N'BBASQLPDD', N'BBA_CORPORATE', ?)}
ErrorId = 407, SourceTypeId = 1
ErrorCode = ''
ErrorText = ''
[2/28/2005 11:02:09 AM]BBARPLP1\P64.distribution: {call
sp_MSadd_repl_error(407, 0, 1, ?, N'', ?)}
[2/28/2005 11:02:09 AM]BBASQLPDD.BBA_CORPORATE: exec
dbo.sp_MSupdatelastsyncinfo N'BBASQLPROD1-64',N'BBA_MFMO', N'', 0, 6, N'Error
at parameter 1 during datastream processing of parameterized command.'
Disconnecting from Subscriber 'BBASQLPDD'
Disconnecting from Distributor 'BBARPLP1\P64'
Disconnecting from Distributor History 'BBARPLP1\P64'"
I would like some help to understand the error above.
Regards
--
Carlos Eduardo Selonke de Souza