2103998 - Duplicates being created when running a Data Services dataflow that includes a hierarchy flattening transform - Data Services | SAP Knowledge Base Article

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 (Use Subcomponent) , EIM-DS-EXE , Data Services 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.