Symptom
After new SAP Datasphere Wave (2024.25.2) the deployment of Replication Flow might be failed in case one of the column's data type is timestamp:
Error creating replication for dataset XYZ: data type of source column ASD (vtype:$DYNAMIC.decimal_undefined_undefined) is incompatible with target column ASD(vtype:com.sap.core.timestamp); please map the source column to a target column with a compatible data type
Environment
SAP Datasphere
Reproducing the Issue
- Open the Replication Flow in Data Builder
- Deploy
Resolution
22.01.2025: The reported Replication FLow issue has been identified by the development team. They are already working on the investigation and the possible solution.
27.01.2025: The fix is planned to be available with SAP Datasphere release 2025.03. For updated deployment information, please see SAP Note 2984828 - SAP Datasphere Release & Delivery Schedule. As global deployment usually takes 24 hours, you may plan to test the fix one day later.
Possible workaround until the fix is delivered:
1. Open the Replication Flow (RF)
2. Use Export to CSN/SON file from the RF editor and export the csn definition of the RF
3. Open the exported file and search for the column which is mentioned in the error message during the deployment - in our example ASD
4. Update only the vtype-ID of the column as below and save the file:
Under "replicationTasks"
- "sourceObject": {
"name": "XYZ",
"definition": {
"columns": [
{
"name": "ASD",
"vflow.type": "scalar",
"vtype-ID": "com.sap.core.timestamp",<<!
"businessName": "businesstext",
"metadata": {}
},
5. Please update the same for other columns as well which has timestamp as datatype
6. Navigate to Data Builder landing page and import the file using the option Import Objects from CSN/JSON File
7. Deploy the RF from the landing page - (Please do not deploy the RF from the editor)
Keywords
flow, error, failed, stopped, date, time , KBA , DS-DI-RF , Replication Flows , Known Error