SAP HANA XSA Flowgraph: could not insert into table due to a unique constraint violation

[rahulvilas_chaudhari]

We are currently having error as : "could not insert into table due to a unique constraint violation". We have defined the primary keys for the target table but still continue to have the error.

Data from datasource: 2LIS_02_ITM

Primary key at target table: EBELN & EBELP

Writer type: UPSERT

I have attached the snapshots below. Kindly inform if I am missing something.

[SergioG_TX]

have you verify that your data does not have duplicates based on your keys ?

[rahulvilas_chaudhari]

Yes there are duplicates based on the key but I suppose, shouldn't UPSERT be able to handle them?

[yamit]

Hello Raul,

Did you have an anwer to this problem? i have the same..

Regards.

[rahulvilas_chaudhari]

pr0x1 You may try using replication task for this purpose instead. It works ok.