ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unique Constraint error on ODF_MULTI_VALUED_LOOKUPS

book

Article ID: 213511

calendar_today

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.