SAP Knowledge Base Article - Preview

2103998 - Duplicates being created when running a Data Services dataflow that includes a hierarchy flattening transform - Data Services


  • Data flow is duplicating records.
  • Hierarchy flattening creates duplicate values.
  • Hierarchy flattening transform not working.
  • Potential constraint error after upgrade.
  • Potentially if loading a table with primary keys, the following error may be received: "DBS-070401: |Data flow dataflowname | Loader loaderobjectname ODBC data source <Datastore> error message for operation <SQLExecute>: <[SAP AG][LIBODBCHDB SO][HDBODBC] Integrity constraint violation;301 unique constraint violated>."



SAP Data Services


SAP Data Services 4.2


BODS, DSXI, HANA, SQL Server, , KBA , EIM-DS , Data Services , EIM-DS-EXE , Job Execution , Bug Filed

About this page

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

Search for additional results

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