SAP Knowledge Base Article - Public

3433995 - Error "Integrity constraint violation;301 unique constraint violated" in Data Flow for currency and unit codes

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

Product

SAP Datasphere all versions