all groups > sql server replication > february 2005 >
You're in the

sql server replication

group:

Error at parameter 1 during datastream processing of parameterized


Error at parameter 1 during datastream processing of parameterized Carlos Selonke
2/28/2005 6:19:04 AM
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
Error at parameter 1 during datastream processing of parameterized Paul Ibison
2/28/2005 7:53:40 AM
Do you have different service pack levels involved here?
Please check the publisher, distributor and subscriber to
check they are all sp3.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
RE: Error at parameter 1 during datastream processing of parameterized Carlos Selonke
2/28/2005 8:42:09 AM
Hello

Below are the SQL Server versions:

Publisher - Microsoft SQL Server 2000 - 8.00.933 (Intel IA-64)
Subscriber - Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Distribution - Microsoft SQL Server 2000 - 8.00.837 (Intel X86)



[quoted text, click to view]
RE: Error at parameter 1 during datastream processing of parameterized Carlos Selonke
2/28/2005 8:45:02 AM
Publisher - Microsoft SQL Server 2000 - 8.00.933 (Intel IA-64)
Subscriber - Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Distributrion - Microsoft SQL Server 2000 - 8.00.837 (Intel X86)

[quoted text, click to view]
RE: Error at parameter 1 during datastream processing of parameterized Paul Ibison
2/28/2005 9:59:26 AM
I'd tend to see if having the same patch level fixes
things, and if not, then raise a PSS support call for
this.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
AddThis Social Bookmark Button