Skip to Content
0

unique constraint violated: Table SOPDD_STAGING_KFTAB*

Dec 26, 2016 at 05:26 AM

138

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Benjamin Schu Jan 13, 2017 at 11:41 AM
0

Hi Kosuke,

use the following mapping for "ID":

gen_uuid()

Doku

Best regards,

Benjamin

Share
10 |10000 characters needed characters left characters exceeded