SAP Knowledge Base Article - Public

3800650 - SAP Datasphere - Cannot use "Initial Only" load type for replication flow

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

  1. Open the replication flow.
  2. Attempt to set the load type to "Initial only".
  3. 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

  1. Create a new local target table with Delta Capture set to "Off".
  2. Deploy the new local table.
  3. Update the replication flow to use the new table as the target.
  4. Set the load type to "Initial only".
  5. Run the replication flow to complete the initial load.

See Also

Capturing Delta Changes in Your Local Table

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

Product

SAP Datasphere 1.0