SAP Knowledge Base Article - Preview

3208636 - Error: "could not insert into table due to a unique constraint violation" while executing flowgraph that use "writer type" as upsert

Symptom

  • Execute flowgraph with "write type" set to upsert
  • Failed with error
    "start task error: "flowgraph_name": executor: plan operation failed: Error executing "UPSERT *** from _SYS_CE_popid_*****:
    Could not insert into table due to a unique constraint violation"


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

upsert, unique constraint, duplicate keys, sub select, SDI, flowgraph , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.