SQL Error changing from custom primary key to Auto | Community
Skip to main content
M
michaelwilding
Level 3
February 22, 2023
Question

SQL Error changing from custom primary key to Auto

  • February 22, 2023
  • 1 reply
  • 1473 views

When changing a custom resource from having a custom primary key to an auto key we are getting this error:

 

PGS-220000 PostgreSQL error: ERROR: could not create unique index "customfield_id" DETAIL: Key (****)=(0) is duplicated.

 

I've not yet found a solution to resolving this so that the custom primary key is removed, does anybody have any solutions?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee
Adobe Employee
February 23, 2023

Hi Michael,

 

I would suggest engaging Campaign Support. This error can be caused by numerous conditions when making changes or publishing the custom resource; however, from what I can see on my end, this error has not been reported previously using your reproduction steps and will require further investigation.

 

Thanks,

Craig

    M
    michaelwildingAuthor
    Level 3
    February 23, 2023

    Thanks @craig_thonis I'm in touch with Campaign Support as well. They're looking into it, but sometimes I have found it quicker to get solutions here 🙂

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    April 4, 2023

    Hi @michaelwilding,

    Were you able to get a resolution from the Campaign Support? Kindly share the solution here with the Community as well, so that users facing similar issues can also gain from your solution. 

    Best,

    Sukrity 

    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...