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.