Sunday, March 11, 2012

Cannot log conflict data

Hi,
I'm having problme when performing the Merge replication and the error as
belows:
1) The process could not log conflict information
follow by
2) Too many arguments were supplied for procedure sp_cft_xxxxxxx
Pls help, it is urgent!!!
Thanks.
Ringo
Message posted via http://www.sqlmonster.com
does this help?
http://support.microsoft.com/default...;en-us;Q241658
Hilary Cotter
Looking for a SQL Server replication book?
<http://www.nwsu.com/0974973602.html>
Looking for a FAQ on Indexing Services/SQL FTS
<http://www.indexserverfaq.com>
|||Hi,
This doesn't really help. Maybe I should address more on my problem. The
problem happened when there;s conflict during replication and try to record
info into the conflict table through sp_cft_xxxxx stored procedure. The
error shows that the parameters passing to the sp_cft_xxxxx SP is more (one
extra parameter which I think is "0x00" as the last parameter).
The above replication is between the SQL CE (PDA) and MS SQL 2000 server
where I'm using the "Synchronize()" method.
BTW, thanks for your help
Message posted via http://www.sqlmonster.com
|||where are you calling this proc? Its on the publisher correct?
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ringo law via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:daf883cd95a9432fba48b2a26852239f@.SQLMonster.c om...
> Hi,
> This doesn't really help. Maybe I should address more on my problem. The
> problem happened when there;s conflict during replication and try to
> record
> info into the conflict table through sp_cft_xxxxx stored procedure. The
> error shows that the parameters passing to the sp_cft_xxxxx SP is more
> (one
> extra parameter which I think is "0x00" as the last parameter).
> The above replication is between the SQL CE (PDA) and MS SQL 2000 server
> where I'm using the "Synchronize()" method.
> BTW, thanks for your help
> --
> Message posted via http://www.sqlmonster.com
|||Hi,
No, I didn't call the stored proc. It's a system stored proc to log
conflict info in publisher table (conflict_tablename) when there's conflict
occurred.
If I try this Merge Replication between SQL Server (2000 to 2000), it can
work and the conflict record is created. But, if between SQL CE and 2000,
then this problem happened.
Thanks.
Ringo
Message posted via http://www.sqlmonster.com

No comments:

Post a Comment