July 22, 2003 at 7:54 pm
Hi,
I am getting errors in my transactional replication. Both db's are on the same server which is running sql 2000 sp3.
The error occurs in the distribution agent and is as follows:
Error at parameter 401 during datastream processing of parameterized command.
Procedure or function sp_MSdel_personRole has too many arguments specified.
This is the last command being run:
{CALL sp_MSdel_personrole (9016229, 3, 2003-07-21 00:00:00, NULL, 120, {91F9CB5E-38A5-4318-964D-4CB05B26AD86})}
Transaction sequence number and command ID of last execution batch are 0x00000E550000004B000500000000 and 1.
If you need any more info I will be happy to provide it.
Thanks for your help.
matt
July 23, 2003 at 4:16 pm
Look at the proc and see if the params match the subscriber schema. Most often it happens because someone changes something on the subscriber, not understanding the impact. Reinitialzing the pub will fix it.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply