Error 'value must be unique' when creating a new line in the table - Modern UX

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• A custom object is created
• Instances are then created using direct DB operations, via a Gel Script
• Now, when trying to create a new instance via the UI, the application throws the following error:
  • ODF-0015: Value must be unique.
• The app-ca.log does not tell which specific unique index got violated.

Resolution

Do not use DB operations for instance creations. Use XOG or REST API calls instead.