3331989 - Error "Could not insert into table due to a unique constraint violation" when replicating Hierarchy data using CDS view in Datasphere

Symptom

Replication of Hierarchy data using CDS view fails in SAP Datasphere:
Error: {"timestamp":"XXXX-XX-XX XX:XX:XX.XXXXXXX", "origin":"_sys_task", "message":"Could not insert into table due to a unique constraint violation.; Statement: ,INSERT INTO ...

Environment

SAP Datasphere

Product

SAP Datasphere all versions

Keywords

ABAP_CDS, $H, dwc, data warehouse cloud, replicating, persisting, persist, persistance, nodeid, headerid, hier , KBA , DS-DI-RT , Remote Tables , 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.