Symptom
- Running sp_stop_rep_agent reports:
"The Replication Agent thread for the database is being stopped. (return status = 0)"
but the Rep Agent never terminates. - Subsequent sp_start_rep_agent fails with:
Msg 9431, Level 16, State 0: Procedure 'sp_start_rep_agent': A Rep Agent Thread for the database is being stopped.
Msg 18421, Level 16, State 1: Procedure 'sp_start_rep_agent': Failed to start the Replication Agent thread for the database. (return status = 1) - DBCC stacktrace on the Rep Agent spid shows a call stack including:
upsleepgeneric
ksctsuspend
ra_get_rs_truncpt
rep_agent_thread
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0
- SAP Replication Server (SRS) 16.0
Keywords
sp_stop_rep_agent, sp_start_rep_agent, replication agent, rep agent, hang, freeze, 9431, 18421, ra_get_rs_truncpt, rep_agent_thread, ase, replication server, rep server, , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview