SAP Knowledge Base Article - Preview

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


Read more...

Environment

SAP Datasphere

Product

SAP Datasphere all versions

Keywords

INNER JOIN, TRUNCATE, unique key constraint  , KBA , DS-DI-DF , Data Flow Runtime , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.