SAP Knowledge Base Article - Public

3567167 - Replication flow based on CDS view (ACDOCA) is not pulling data

Symptom

Replication flow based on CDS view on top of ACDOCA table is not pulling data.
You can see partitions happening and transferring count increasing, also data in ready status in transaction DHRDBMON, but data load is not happening.
In the Partition Details, you can find reason DATA_NOT_READY in the Retry Log.

Environment

SAP Datasphere

Reproducing the Issue

Execute the Replication Flow to load data from CDS View to SAP Datasphere.

Cause

Program error in timestamp conversion after SAP Datasphere Wave 2025.02 update.

Resolution

Fix will be delivered via SAP Datasphere Wave 2025.03. Please refer to Note 2984828 regarding the planned availability of the fix.
After the fix is delivered, please follow the steps below to fix the existing replication flow:

  1. Delete the replication flow.
  2. If the target table has already been created, you can either:
    • Delete the target table, or
    • Change the datatype of the "Timestamp" column from Decimal(15, 0) to Timestamp.
  3. Recreate the replication flow.

If you would prefer to apply the workaround for the issue without waiting for the fix, please follow these steps:

  1. If the target table is already created, change the "Timestamp" column’s datatype from Decimal(15, 0) to Timestamp in the HANA table (please connect to the HANA instance to make this change).
  2. In the replication flow UI editor, click on "Map to Existing Target Object" (click the three dots next to the target object name). In the dialog, select the same target table in Step 1 to apply the HANA table changes.
  3. Use the "Export to CSN/JSON File (in the top menu under Edit option)" option in the Replication Flow Editor to export the CSN definition of the RF.
  4. Open the exported file, search for '$DYNAMIC.decimal_15_0' under Timestamp column, and replace it with 'com.sap.core.timestamp'.
                     {

                        "name": "Timestamp",

                        "vflow.type": "scalar",

                        "vtype-ID": "$DYNAMIC.decimal_15_0",

                        "metadata": {}

                      }
    with 
                    {

                        "name": "Timestamp",

                        "vflow.type": "scalar",

                        "vtype-ID": "com.sap.core.timestamp",

                        "metadata": {}

                      }
  5. Save the CSN file.
  6. Navigate to the Data Builder landing page and import the file using the "Import Objects from CSN/JSON File" option.
  7. Deploy the replication flow from the landing page (please DO NOT deploy it from the editor).
  8. After a successful deployment, run the replication flow.

Keywords

KBA , DS-DI-RF-UI , Replication Flow editor, monitoring and deployment , Problem

Product

SAP Datasphere all versions