SAP Knowledge Base Article - Public

3449717 - Data Flow execution error because of duplicate values

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

  1. Run the Data Flow object in SAP Datasphere tenant.
  2. Check the error message in Data Integration Monitor.

Cause

Duplicate values from the Data Flow target object's sources.

Resolution

  1. Copy the HEX value from the error message (see Symptom <value_in_HEX>)
  2. Use a HEX to ASCII converter
  3. 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

Product

SAP Datasphere all versions