Unique Constraint error on ODF_MULTI_VALUED_LOOKUPS
Article ID: 213511
Updated On:
Products
Clarity PPM On Premise
Clarity PPM SaaS
Issue/Introduction
When can an unique constraint error be raised against the ODF_MULTI_VALUED_LOOKUPS table?
Environment
Latest version applicable: 15.9.1
Resolution
There is an unique constraint defined against the combination of following set of columns:
("OBJECT", "PK_ID", "ATTRIBUTE", "SEQ")
If a row is attempted to be inserted, with same values against these columns as compared to an already existing record, then an error is thrown.
Feedback
Yes
No
Powered by
