SAP Knowledge Base Article - Preview

2667452 - SDI monitoring views show no issue but replication from MSSQL database not happening

Symptom

  • The "Data Provisioning Remote Subscription Monitor" shows the remote source state is OK for a MSSQL database.
  • You have created several table subscription, all in state "Replicating changes in real-time" with replication status "successful". 
  • The source tables have inserts and updates all the time but it states that the last processed transaction was x number of days ago.
  • Comparing the content of one replicated table using the virtual table and its target and indeed, there is x number of days gap.
  •  REMOTE_SUBSCRIPTION_EXCEPTION table is empty. 


Read more...

Environment

SAP HANA Smart Data Integration

MssqlLogReaderAdapter

Product

SAP HANA smart data integration all versions

Keywords

stale, data, task, DP , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.