From: CEN05 on
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.

Thank you


--
dev 2005
From: CEN05 on
BTW: there are no triggers on the subscriber database.
--
dev 2005


"CEN05" wrote:

> 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.
>
> Thank you
>
>
> --
> dev 2005
From: Ben Thul on
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.
--
Ben

On Mar 2, 1:51 pm, CEN05 <CE...(a)discussions.microsoft.com> wrote:
> 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.
>
> Thank you
>
> --
> dev 2005