Symptom
A local table is exported from source Datasphere tenant, in target Datasphere tenant, a local table with same name already exists. When importing the local table in target tenant, one of the following error messages occurs, even if the import option is selected as "Overwrite objects and data".
"Delta Capture cannot be switched on for <table name> because it has already been deployed with Delta Capture off."
or
"Delta Capture cannot be switched off for <table name> because it has already been deployed with Delta Capture on."
Environment
SAP Datasphere
Reproducing the Issue
- In the source Datasphere tenant, Transport->Export, export a package that includes a local table of "Delta Capture" property set to "ON".
- In the target Datasphere tenant, confirm there already has a local table with same name but "Delta Capture" property set to "OFF".
- In the target Datasphere tenant, Transport->Import, import the package in step 1, select the "Overwrite objects and data" option.
- Observe the error message:
"Delta Capture cannot be switched on for <table name> because it has already been deployed with Delta Capture off." - If in step 1 and 2, the source table has "Delta Capture" property set to "OFF", and target table has "Delta Capture" property set to "ON", error message is:
"Delta Capture cannot be switched off for <table name> because it has already been deployed with Delta Capture on."
Cause
The local table in source tenant and in target tenant has different "Delta Capture" property. As documented in Capturing Delta Changes in Your Local Table, to change "Delta Capture selection, the table must have a status 'Not Deployed'. The "Delta Capture" property of a local table cannot be modified anymore after the table has been deployed. Therefore importing a table to change and overwrite an existing table with a different "Delta Capture" setting is not possible and results in the reported error.
Resolution
In target Datasphere tenant, delete the local table with same name first before importing.
See Also
Keywords
delta capture, import error, table deployment, overwrite objects and data, table property, table recreation, Delta Capture cannot be switched on for, Delta Capture cannot be switched on off , KBA , DS-MD-REPO , Repository Backend , Problem
SAP Knowledge Base Article - Public