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.
SAP Knowledge Base Article - Preview