Symptom
In SAP Datasphere, the Replication Flow for ODP-framework objects (BW or SAPI context) fails in the Data Integration Monitor with an error related to a missing Consumer ID. Cannot be resumed or restarted in Data Integration Monitor.
Typical error messages include:
Error: Failed to load consumer <Consumer_ID> for ODP object.
Consumer ID <Consumer_ID> does not exist.
or
Cleanup of source replication artifacts failed due to the following error:
Failed to load consumer <Consumer_ID> for ODP object XXX (context BW).
Consumer ID <Consumer_ID> does not exist (object XXX context BW).
The same error entries may also appear in the Application Log (T-Code SLG1) of the source system.
Environment
SAP Datasphere
Reproducing the Issue
Start data replication using the Replication Flow in Datasphere
Cause
The issue occurs because the Consumer ID used by the Replication Flow is no longer valid in the source system.
This can happen either due to incomplete cleanup after a previous fatal error in the Replication Flow, or because the delta Consumer ID object became corrupted after multiple restart and bug-fix cycles.
Resolution
First, try to resolve the issue by going to the Data Builder, opening the Replication Flow, enabling the TRUNCATE option in Settings, then redeploying and restarting the Replication Flow.
- Open Replication Flow
- Click on Settings -> Check the TRUNCATE box
- Redeploy the Replication Flow
- Restart the Replication Flow
If this does not solve the problem, delete the Replication Flow entirely, recreate it from scratch, and verify that a new Consumer ID is generated so that replication continues correctly.
- Delete the existing replication flow entirely.
- Recreate the replication flow from scratch.
- Verify that a new consumer ID is generated.
- Confirm that the further data replication proceeds correctly.
See Also
- SAP Note 3645926 - Data Integration ABAP(DMIS 2011 / DMIS 2018 / S/4 HANA): Improving setup and teardown order for ODP replications
Keywords
replication flow, consumer ID, missing, ODP, ODP-SAPI, ODQMON, ODP_SAPI, ODP_BW, SAPI , KBA , DS-DI-RF , Replication Flow Runtime , Problem
SAP Knowledge Base Article - Public