Symptom
An error occurs when attempting to enable real-time replication for a remote table using SAPI as source in SAP Datasphere. The main part of the error message is as follows: "Failed to send Begin Marker for remote subscription <subscription string> in remote source <source> and triggerID <ID>. Error: exception 151054: CDC begin marker failed".
Environment
SAP Datasphere
Reproducing the Issue
- Log in to SAP Datasphere.
- Data builder create new remote table or open existing remote table which is using SAPI source.
- Attempt to enable real-time replication.
Cause
During the real time replication, CDC begin marker will be sent first to the source system. If it is failed, the deployment or activation will fail. CDC begin marker failure can have many reasons, one possible reason is the wrong status in the SAPI source side.
Resolution
In source system, run SE38 -> program RODPS_REPL_TEST -> select relevant table/extractor name and run with 'Last Delta' mode. This will reset the status in SAPI source side.
Below is an example:
Once the program finished, try to activate real-time replication for remote table in Datasphere side again.
See Also
KBA 3228242 - ODP : Provide SAPI does not support function INIT-SIMU
Keywords
SAPI extractor, 0MATERIAL_ATTR, CDC failed, Operational Data Provisioning, Delta Queue, ODP, ODQ , KBA , DS-DI-RF , Replication Flows , BC-BW-ODP , Operational Data Provisioning (ODP) and Delta Queue (ODQ) , BC-BW , BW Service API , Problem