2639669 - DDL replication is not working on RS 16 between two MSSQL servers | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2639669 - DDL replication is not working on RS 16 between two MSSQL servers

Symptom

This is an environment with replication from one MS-SQL SERVER to another MS-SQL SERVER.

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

ECDA MSSQL replication agent server TransactionMode long short microsoft sql server commit DDL heterogeneous 814858 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-ECD , Enterprise Connect (ECDA) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.