3520040 - Replication flow CDS: execution fails after adding a new field to the table/CDS view - SAP Datasphere

When a new field is added to the table/CDS view in the source system, the replication flow in Datasphere fails with the following errors:

"No source data is available for replication. Replication runs are retrying."

"Subscriber XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX is not registered as a subscriber for object"

SAP Datasphere

1. Navigate to Data builder
2. Select the space
3. Search for the Replication Flow
4. Check the status of the replication flow in Data Integration Monitor

Structural changes to source objects are not supported.

Whenever there is an change in source CDS view/table, it must be compatible with targe object in Replication flow.

Workaround (see SAP Note 3297105 - Important considerations for SAP Datasphere Replication Flows)

1. Remove the replication object with schema changes from the replication flow
2. Deploy the replication flow so the specific object is removed
3. Add the same replication object to the replication flow
4. If source/target names are different, please follow the below additional step:
   • Select the replication object in the editor
   • Map to existing target to fetch metadata of target schema
5. Deploy the replication flow
6. Only the replication object with structural changes will be re-loaded and initial load for the specific object will be re-executed.
7. The structural changes supported through the workaround are below:
   • New columns
   • Remove columns
   • Changes to compatible data types
   • Add primary key

For more information, see Modify a Replication Flow | SAP Help Portal 

• SAP Note 3297105 - Important considerations for SAP Datasphere Replication Flows
• Modify a Replication Flow | SAP Help Portal

transform error, invalid transform table schema, column not found, field, column, replication flow, SAP Datasphere , KBA , DS-DI-RF , Replication Flows , DS-DI-ABA , Data Flow / Replication Flow with ABAP as data source , Problem