SAP Knowledge Base Article - Preview

2596728 - What are the steps to follow after a Resync of MSSQL to MSSQL databases - SRS

Symptom

  • Heterogeneous Replication from MSSQL to MSSQL, multiple SAP components are involved:
      
      Primary: RepAgent for MSSQL (RAM)
    • Replicate:ECDA for MSSQL
    • SAP Replication Server
        
  • After dumped primary database (PDB) and loaded to the replicate database (RDB), replicate dsi get suspended with the following problems:
     
    • All rs tables required by ECDA are missing
    • Msg 2812 Procedure ra_createtable_trig_, Could not find stored procedure 'sp_SybSetLogforReplTable'.

 


Read more...

Environment

  • SAP Replication Server (SRS) 16.0
  • SAP Replication Server (SRS) 15.7.1
  • SAP Replication Server Heterogeneous Edition 16.0
  • SAP Replication Server Heterogeneous Edition 15.7.1
  • SAP Replication Server Option (RSO) for Microsoft SQL Server 15.7.1
  • SAP Enterprise Connect Data Access (ECDA) 15.0

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0 ; SAP Replication Server, heterogeneous edition 16.0 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, option for Microsoft SQL Server

Keywords

ECDA MSSQL; resync MSSQL databases; using profile rs_msss_to_msss; rs_info , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To

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.