Skip to Content
avatar image
Former Member

unique constraint violated: Table SOPDD_STAGING_KFTAB*

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 13, 2017 at 11:41 AM

    Hi Kosuke,

    use the following mapping for "ID":

    gen_uuid()

    Doku

    Best regards,

    Benjamin

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 17 at 07:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded