2161415 - sp_help_rep_agent, monRepLogActivity, monRepScanners and monRepSenders report a value of 0 for spid on SAP ASE Cluster Edition | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2161415 - sp_help_rep_agent, monRepLogActivity, monRepScanners and monRepSenders report a value of 0 for spid on SAP ASE Cluster Edition

Symptom

  • Problem is specific to SAP Adaptive Server Enterprise Cluster Edition.
  • When querying monRepLogActivity, monRepScanners or monRepSenders, the SPID value is 0 dispite having a valid spid in master..sysprocesses.
  • sp_help_rep_agent will report a value of 0 for the spid.

    Example output:

    select spid as spid_sysprocesses from sysprocesses where cmd= "REP AGENT"
    go

    spid_sysprocesses
    -----------------
                    51
  • Querying monRepScanners retuns 0

   select ScannerSPID as ScannerSPID_monRepScanners from monRepScanners
   go

   ScannerSPID_monRepScanners
   --------------------------
                          0

  • sp_help_rep_agent returns 0 for spid

sp_help_rep_agent
go

[output truncated for legibility]
Replication Agent Scanner Process Status
dbname       pathname         scanner_spid
         start_marker             end_marker
         current_marker               sleep_status             state
------------ ---------------- ------------------------
         ------------------------ --------------------
         ---------------------------- ------------------------ ----------------
mydb        n/a                         0
         (25994,0)                (25994,7)
         (25994,7)                    not sleeping             sleeping


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 (CE) Cluster Edition
  • SAP Replication Server (RS) 15.7

Product

SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Replication Server 15.7

Keywords

KBA , mda , monitoring tables , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BC-SYB-REP , Sybase Replication Server (standalone) , 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.