SAP Knowledge Base Article - Preview

2325947 - Create Route never completes Message: -- 'Have your DBO execute 'sp_setreplicate' on the procedure 'rs_marker' - SRS

Symptom

  • Both Primary Replication Server (PRS) and Replicate Replication Server (RRS) were upgraded
  • Both PRS and RRS are using Embedded RSSD (ERSSD)
  • Create route never completes
  • rs_helproute displays the following output in Primary RSSD:

    PRS --------> RRS    Route is being created. Destination has not yet finished creating system table  rs_subscription                                    

           Systable Subs to be created                                                                                                      
           -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
           rs_objects0_at_16777353                                                                                                         
           rs_columns1_at_16777353                                                                                                         
           rs_classes2_at_16777353                                                                                                         
           rs_functions3_at_16777353                                                                                                       
           rs_funcstrings4_at_16777353                                                                                                     
           rs_routes5_at_16777353                                                                                                          
           rs_databases6_at_16777353                                                                                                       
           rs_systext7_at_16777353                                                                                                         
           rs_systext8_at_16777353                                                                                                         
           rs_erroractions9_at_16777353                                                                                                    
           rs_dbreps10_at_16777353                                                                                                         
           rs_dbsubsets11_at_16777353                                                                                                      
           rs_clsfunctions12_at_16777353                                                                                                   
           rs_objfunctions13_at_16777353                                                                                                   
           rs_asyncfuncs14_at_16777353

  • RS errorlog prints this message:
       RSI: Trying to connect to 'RRS'.
       Starting Routing thread for 'PRS'
             Message from server: Message: 0, State 0, Severity 10 -- 'Have your DBO execute 'sp_setreplicate' on the procedure 'rs_marker'                                                                                         


Read more...

Environment

  • SAP Replication Server (SRS) 15.7.1
  • Sybase Replication Server (SRS) 12.6 - 15.6

Product

SAP Replication Server 15.7 ; Sybase Replication Server 15.5 ; Sybase Replication Server 15.6

Keywords

rs_marker, ERSSD, Msg 174, RSI, rs_helproute , 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.