SAP Knowledge Base Article - Preview

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

Symptom

  • 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>."


Read more...

Environment

SAP Data Services

Product

SAP Data Services 4.2

Keywords

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 for Me (Login required).

Search for additional results

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