Prev: Indexed Views - Clustered Index is NOT replicated (not scripte
Next: Replication Skipped Records
From: CEN05 on 2 Mar 2010 14:51 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 2 Mar 2010 15:54 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 2 Mar 2010 18:12 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
|
Pages: 1 Prev: Indexed Views - Clustered Index is NOT replicated (not scripte Next: Replication Skipped Records |