Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2009-11-11 : 10:51:36
|
| Hi All,Can anyone throw some light here.My distributor agent is failing with the below error.The row was not found at the Subscriber when applying the replicated command. (Source: MSSQLServer, Error number: 20598)Command attempted:if @@trancount > 0 rollback tran(Transaction sequence number: 0x0000005C0000009B000D00000000, Command ID: 1)..Kindly let us know how to fix the issue.Regards,Rao |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-11 : 13:04:14
|
| someone modified a record on the publisher that doesn't exist on the subscriber. this usually happens one of two ways:1) updates are performed from joins where the join table doesn't exist on the subscriber2) someone is performing write operations on the subscriber (big no no).If you can identify the offending transaction, you may be able to fix it manually. Else you'll need to re-snapshot |
 |
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2009-11-13 : 14:47:55
|
| Thanks for the reply.Can you tell me how to find the exact tables and rows that were not found on the subscribers based on the errors found in the replication.I want to make a dummy update at the subscribers end because reinitialize will take much time (300 GB) of data.I heard that we can proceed further by skipping the errors and later compare the tables but for this also articles need to know. Can you provide some information in this regard.Regards,Rao |
|
|
|
|
|
|
Distributing agent failing