The process could not execute 'sp_repldone/sp_replcounters' on ''

• Meera

  SSCommitted

  Points: 1966

  More actions

  August 2, 2024 at 4:41 am

  #4441832

  Gone through google for this error - But our scenario is due to power shutdown. and so replication stopped working and the Logreader agent throws these errors,

  Unable to figure the solution to fix it - kindly help.

   

  Error messages:

  The process could not execute 'sp_repldone/sp_replcounters' on '<Servername>'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)

  Get help: http://help/MSSQL_REPL20011

  Warning: Fatal error 9004 occurred at Aug 2 2024 10:01AM. Note the error and time, and contact your system administrator. (Source: MSSQLServer, Error number: 21)

  Get help: http://help/21

  The process could not set the last distributed transaction. (Source: MSSQL_REPL, Error number: MSSQL_REPL22017)

  Get help: http://help/MSSQL_REPL22017

  The process could not execute 'sp_repldone/sp_replcounters' on '<servername.'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)

  Get help: http://help/MSSQL_REPL22037

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  August 2, 2024 at 4:36 pm

  #4441983

  I saw a note to try:  sp_replrestart here: https://www.sqlservercentral.com/forums/topic/the-process-could-not-execute-sp_repldonesp_replcounters

  Also: https://repltalk.com/2010/02/19/the-process-could-not-execute-sp_repldonesp_replcounters/

• September 26, 2024 at 4:00 pm

  This was removed by the editor as SPAM