Symptom
The Data Flow object execution stopped because of the following error message:
DBS-070407: |Session Job_xxx|Data flow DF_xxx|Reader LoadMapper_xxx_producer1 SQL submitted to database <> resulted in error <[SAP AG][LIBODBCHDB SO][HDBODBC] Integrity constraint violation;301 unique constraint violated: Table(xxx), Index(xxx#xxx#xx#xx) with error: unique constraint violation in self check for table H00::xxx:xxx, column='', value='<value_in_HEX>', pos=xxxx; indexname=xxx#xxx#xx#xx>. The SQL submitted is xxx
Possible scenario(s):
- There are two source tables with INNER JOIN
Environment
SAP Datasphere
Reproducing the Issue
- Run the Data Flow object in SAP Datasphere tenant.
- Check the error message in Data Integration Monitor.
Cause
Duplicate values from the Data Flow target object's sources.
Resolution
- Copy the HEX value from the error message (see Symptom <value_in_HEX>)
- Use a HEX to ASCII converter
- Check the ASCII values in the source objects via Data Preview to find the duplicate values
Keywords
INNER JOIN, TRUNCATE, unique key constraint , KBA , DS-DI-DF , Data Flows , Problem