Symptom
Cannot use "Initial only" load type for replication flow. When select "Initial only", an error occurred: "You must select the load type "Initial and Delta" for the replication with target object name XXX."
Environment
SAP Datasphere
Reproducing the Issue
- Open the replication flow.
- Attempt to set the load type to "Initial only".
- Observe that the system requires selecting "Initial and Delta".
Cause
The target local table already has Delta Capture enabled.
For deployed tables with Delta Capture enabled, "Initial only" is not allowed.
Additionally, once a table is deployed with Delta Capture enabled, it cannot be turned off.
Resolution
- Create a new local target table with Delta Capture set to "Off".
- Deploy the new local table.
- Update the replication flow to use the new table as the target.
- Set the load type to "Initial only".
- Run the replication flow to complete the initial load.
See Also
Keywords
datasphere, replication flow, initial only, initial and delta, delta capture, local table, target table, load type, cannot select initial only, deployed table, runtime, error selecting load type, enable delta, disable delta capture , KBA , DS-DI-RF , Replication Flow Runtime , Problem
SAP Knowledge Base Article - Public