SQL Server Performance Forum – Threads Archive

Merge Replication error

Hi, I am getting error from a Merge replication: "The process could not deliver insert(s) at the ‘Subscriber’." I have another 3 transactional replications involving same servers and they’re working properly. Thanks,
Claudionor C. Rocha Filho

What is load (no.of rows) of this snapshot?
Do you have any other application like virus scanner on SQL Server>? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi, Thanks for your reply, In then initial snapshot there are about 100,000 rows. But the initial snapshot was aplied properly. After that, sometimes the error occurs. There is a Norton Enterprise Antivirus installed on the both servers (Publisher and Subscriber) How can i see the no of rows there will be transfered in the merge replication after the initial snapshot was aplied? Thanks again Claudionor C. Rocha Filho

I suggest to stop the AV scanner during the snapshot process in order to continue the merge replicaiton. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Can you show full error message? (add parameter -OutputVerboseLevel 3 to the agent’s command line) WBR, Vlad A. Scherbinin

]]>