Symptom
- In SAP Replication Server (SRS), if a subscription for a database replication definition is created or defined omitting the "subscribe to truncate table" clause.
- There is no way to include that clause later.
- Under these circumstances one has to drop and recreate the subscription.
- The "alter subscription ... for database replication definition.." command does not allow the "subscribe to truncate table" clause.
- Even the "sysadmin apply_truncate_table" command does not work with MSA and reports error:
Msg 15348, Level 12, State 0:
Server 'Server_name:
There are no subscriptions which reference the table 'dbo.table_name'. The 'sysadmin' command is not executed
Read more...
Environment
- SAP Replication Server 15.7 (SRS)
- Multi-Site Availability (MSA)
Product
SAP Replication Server 15.7
Keywords
773631, MSA, alter subscription, subscribe to truncate table , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed
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