Error on cmn_sec_users_u1 with user XOG on update

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When trying to update a Clarity user with XOG, there is an error. This only happens on update not insert.

ERROR: duplicate key value violates unique constraint "cmn_sec_users_u1"
  Detail: Key (user_name)=([email protected]) already exists.

Environment

Any Supported Clarity Releases

Cause

in XOG, resourceId should match srm_resources unique_name

Resolution

• If srm_resources.unique_name does not match what is set to resourceId in the XOG, Clarity detects this is a new resource
• Then it tries to insert the record, then cmn_sec_users.user_name is already there and it fails
• Both srm_resources.unique_name for resourceId and cmn_sec_users.user_name for username should be matching what is already in Clarity to be able to perform a XOG update