unique constraint violated: Table SOPDD_STAGING_KFTAB*

[Former Member]

Hi Experts,

We are trying to load the key figure from CSV and using the staging table for key figures is found under Timeseries Folder like SAPSOPG.SOPDD_STAGING_KFTAB_*.

However we are facing the key duplication error as follows.
(cause: [301]: unique constraint violated: Table(SOPDD_STAGING_KFTAB_SAPIBP1SAPIBP1))

I guess the reason is because "ID" column in the staging table for key figure is a key.

Please let me know the reason why "ID" is set as key and how I deal it to avoid the error.

Thanks in advance.

Regards,
Kosuke

[dhairya]

Hi Kosuke,

Even after mapping ID field with gen.uuid() if this error persists, then you need to need to change some configuration in Execution properties tab.

Please refer to the below link for more details.

https://blogs.sap.com/2018/09/16/how-to-resolve-db-301-unique-constraint-violated-error-in-cpi-ds/

I hope this blog helps you.

Regards,

Dhairya

[ben_sch]

Hi Kosuke,

use the following mapping for "ID":

gen_uuid()

Doku

Best regards,

Benjamin