3467874 - Datasphere real-time replication with remote tables has data differences

When checking the data for remote tables realtime replication, there are data differences between S/4HANA source system table and Datasphere remote tables.

SAP Datasphere

1. Login to Datasphere
2. Check the Remote Table Data
3. Datasphere Remote table has less records compared to Source System

• Check for the records count in Hana Database Explorer using the below query in virtual table and source table
  select count (*) from <schema>."RemoteTable$CT"
  select count (*) from <schema>."RemoteTable$VT"
• Compare the data records in transacation ODQMON. If possible, provide us the missing/wrong data record.
• Download and upgrade into latest DP Agent version (see KBA 2563103 - How to check the Data Provisioning Agent version).
• Check for any errors raised in DP agent log as per 2807852 - How to create DP agent FullSystemDump - SDI 
• Disable and enable real-time replication and retest the behavior.

Before upgrading DP Agent it is necessary to pause the real-time replication and after the upgrade process you can restart the real-time replication and all the delta data will be replicated automatically

Pausing and Restarting Real-Time Replication | SAP Help Portal

ODQMON, DHCDCMON, records, table, Datasphere, delta, missing, source system, remote tables, ABAPAdapter, CDS view, DP agent, RODPS_REPL_TEST, subscription , KBA , DS-DI-RT , Remote Tables , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem