Symptom
- This is an environment with replication from one MS-SQL SERVER to another MS-SQL SERVER using SAP Replication Server (SRS).
- DDL replication in a heterogeneous replication environment where there is a database replication definition an a database replication subscription between two MSSQL servers during the application of the transaction on the replicated site.
- The connection on the replicated site never applies the commit. Selects on the new table on the replicated site get locked. If the connection is suspended the transaction get lost. the next time the connection is resumed the DDL transaction is not applied.
Read more...
Environment
- Replication Server/16.0/EBF 27615 SP03 PL03 rs160sp03pl03/X64/Windows 2008 R2/2214/OPT64/Wed Dec 20 03:42:58 2017
- Replication Agent for Unix & Windows/15.7.1 SP206/P/generic/JDK 7.0/rax1571sp206/62060.206/VM: SAP AG 1.7.0_25/OPT/Tue Feb 10 08:41:01 MST 2015
- DirectConnect 15.7 SP05 P-EBF25406
Product
SAP Replication Server 16.0 ; SAP Replication Server, heterogeneous edition 16.0 ; Sybase Enterprise Connect Data Access 15.0
Keywords
CR814858 CR#814858 814858 ECDA MSSQL replication agent server TransactionMode long short microsoft sql server commit DDL heterogeneous , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-ECD , Enterprise Connect (ECDA) , 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.