SAP Knowledge Base Article - Preview

3328900 - What is the correct method to mark procedure "rs_marker" as replicated with SRS 16 - SRS

Symptom

  • "rs_marker" stored procedure is not marked as replicated.
  • No valuable instruction are existing in Replication Server documentation about the steps to mark rs_marker as replicated.

  • When searching how Replication Server is marking "rs_marker" as replicated during installation, we found the following instruction in file "rs_install_primary.sql": 
          sp_setreplicate rs_marker, true
          go
  • But the procedure sp_setreplicate is deprecated.

  • In documentation, the new method is described :  Create the rs_marker Stored Procedure.
  • When using instruction provided in previous link, it fails with the following error :
          sp_setrepproc rs_marker, 'true'
          go
     
          Msg 18108, Level 16, State 1:
          Server 'ASE_HOST1', Procedure 'sp_setrepproc', Line 440:
          Usage: sp_setrepproc [proc_name [, {'false' | 'table' | {'function' [,{'log_current' | 'log_sproc'}]}}]]
          (return status = 1)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP Replication Server (SRS) 16.0
  • SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
  • SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite

Product

SAP Replication Server 16.0

Keywords

rs_marker, rs_install_primary.sql, sp_setreplicate, sp_setrepproc, 18108, CR#828107, CR 828107, 828107 , 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.