skiperrors - 03-02-2010 , 01:51 PM
I have setup a transactional replication and I want to be able to skip errors
2627 and 20598 due to project requirement....
The replication distriburtor job command is as follow: ( from jobs/step (
run agent ))
-Subscriber [SQ01] -SubscriberDB [db_Rep] -Publisher [SQ03] -Distributor
[SQ03] -DistributorSecurityMode 1 -Publication [VisitsUpdates] -PublisherDB
[testdb] -Continuous -SkipErrors 2601;2627;20598
I also set the distributor job to run on the "Continue on data consistency
errors" agent profile.
I am still getting the error
The row was not found at the Subscriber when applying the replicated command.
( Error 2627! )
I restarted the distribution agent job but still getting the same error
above. I already spent hours on this! please help
Using sql server 2008 sp1 on all servers.
RE: skiperrors - 03-02-2010 , 02:54 PM
BTW: there are no triggers on the subscriber database.
Re: skiperrors - 03-02-2010 , 05:12 PM
BOL is inconsistent; on the page documenting the distrib executable,
it says the -SkipErrors parameter is a *colon* separated list, while
on the page titled "Skipping Errors in Transactional Replication", it
says it's a *semi-colon* separated list. Try changing the semi-colons
in your agent to colons and see if that helps.
On Mar 2, 1:51*pm, CEN05 <CE... (AT) discussions (DOT) microsoft.com> wrote: