Symptom
When executing a Data Flow in SAP Datasphere which involves currency and unit codes, following error may occur:
Integrity constraint violation;301 unique constraint violated
However Data flow uses same key as defined in source CDS View.
Environment
SAP Datasphere
Cause
Data Flows use the "Enhanced Format Conversion" to convert currency and unit codes from ABAP to ISO. However there are codes without unique ISO code.
Different from Data Intelligence Cloud, currently there is no way to change format conversions in SAP Datasphere.
Resolution
Instead of using Data Flows, SAP recommends using Replication Flows.
See Also
SAP Data Intelligence Cloud SAP Help Data Type Mapping and Conversion
Keywords
KBA , DS-DI-DF , Data Flows , DS-DI-RF , Replication Flows , Known Error