The row was not found at the Subscriber when applying the replicated command.

neo — Wed, 22 Sep 2010 09:58:00 GMT

salut ,

am intr-o replicare tranzactionala bidirectionala (sql serv 2005) mesajul "The row was not found at the Subscriber when applying the replicated command. " Am rulat "SELECT DISTINCT
subscriptions.publisher_database_id
FROM sys.servers AS [publishers]
INNER JOIN distribution.dbo.MSpublications AS [publications] ON publishers.server_id = publications.publisher_id
INNER JOIN distribution.dbo.MSarticles AS [articles] ON publications.publication_id = articles.publication_id
INNER JOIN distribution.dbo.MSsubscriptions AS [subscriptions] ON articles.article_id = subscriptions.article_id
AND articles.publication_id = subscriptions.publication_id
AND articles.publisher_db = subscriptions.publisher_db
AND articles.publisher_id = subscriptions.publisher_id
INNER JOIN sys.servers AS [subscribers] ON subscriptions.subscriber_id = subscribers.server_id
WHERE publishers.name = 'MyPublisher'
AND publications.publication = 'MyPublication'
AND subscribers.name = 'MySubscriber'
"

si

EXECUTE distribution.dbo.sp_browsereplcmds
@xact_seqno_start = '0x0000001900001926000800000000',
@xact_seqno_end = '0x0000001900001926000800000000',
@publisher_database_id = 29,
@command_id = 1
pentru a vedea unde e problema.

in monitorul de replicare apare mesajul

if @@trancount>0 rollback tran
(Transaction sequence number 0x0023F7...... Comand ID: 2)

ce ar trebui sa fac? sa rulez doar aceasta comanda de rollback? daca da cum pot rula rolback atat de personalizat?

multumesc

T-SQL

The row was not found at the Subscriber when applying the replicated command.