SAP Knowledge Base Article - Public

3508795 - Replication Flow fails with missing Consumer ID for ODP objects in SAP Datasphere

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.

  1. Open Replication Flow
  2. Click on Settings -> Check the TRUNCATE box
  3. Redeploy the Replication Flow
  4. 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.

  1. Delete the existing replication flow entirely.
  2. Recreate the replication flow from scratch.
  3. Verify that a new consumer ID is generated.
  4. 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

Product

SAP Datasphere all versions