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

• 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

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

KBA , mda , monitoring tables , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed