SAP Knowledge Base Article - Preview

2872639 - Output of sp_hep_rep_agent when RepAgent is down SAP ASE - Stand-alone


  • According to the SAP Rep Server Manuals, sp_help_rep_agent dbname, 'recovery' should show 'not running' for a repagent that is down:

  • Status: Indicates RepAgent or scanner activity. Not running: RepAgent is not running.  
    • However the procedure actually produces no output whatsoever unless the rep agent is running, making it unusable to check a rep agent status which is not running. 

    >sp_help_rep_agent rcreptest,recovery


    Replication Agent Recovery Status dbname connect_dataserver connect_database status rs_servername rs_username

    ------ ------------------ ---------------- ------ ------------- -----------

    (1 row affected)

    (return status = 0)




      • SAP Adaptive Server Enterprise (ASE)
      • Replication Agent configured


      SAP Adaptive Server Enterprise 16.0


      CR 820689, CR# 820689,  820689 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

      About this page

      This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

      Search for additional results

      Visit SAP Support Portal's SAP Notes and KBA Search.