ODF-0015 on custom subobjects when repeating a unique set of values

Products

• Clarity PPM On Premise
• Clarity PPM SaaS
• STARTER PACK-CLARITY PPM

Issue/Introduction

Custom subobjects throwing ODF-0015 Value must be unique only when a set of attributes is repeated. Attributes are not set to Unique in Studio, everything is looking well.  No error in app-ca, which indicates a database issue

Environment

Release : 15.9

Component : CA PPM PROJECT MANAGEMENT

Resolution

• Look to disable the audit triggers and custom triggers on this object
• It's possible than a unique index is created for the fields combination. Check for any unique index in the database, and drop it if no longer needed or recreate as non unique index