Error 20598 in transactional replication

• Sammoayedi

  SSC-Addicted

  Points: 426

  More actions

  September 4, 2003 at 12:17 pm

  #81098

  I am getting error 20598 in transactional replication

  The row was not found at the Subscriber when applying the

  replicated command.

  {CALL sp_MSupd_tblAcct

  (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,791.0500,NULL,NULL,NULL,'17360906-1',0x0001)}

  It seems that the primary key value is missing( 1st column

  should be PK)

  This was working before, just happen today

  Any idea

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 4, 2003 at 2:10 pm

  #472667

  Maybe someone deleted a row on the subscriber? Quick fix is to put it back so the update can continue.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn