Error adding team members to an investment due to an ODF_AUD_OBJ_INST_CONTEXT_N1 index

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We are encountering the following error when adding team members to an investment:

Cannot insert duplicate key row in object 'niku.ODF_AUD_OBJ_INST_CONTEXT' with unique index 'ODF_AUD_OBJ_INST_CONTEXT_N1'. The duplicate key value is (team, 8990011)

The app-ca.log states the following:

ERROR 2025-04-01 14:12:25,323 [https-openssl-nio2-443-exec-5] audit.ObjectAuditService (clarity:myuser:mysession:odf.saveAuditedAttributesListAndExit) (mycookie) Exception building triggers
com.niku.union.persistence.PersistenceException: 
SQL error code: 2714
Error message: There is already an object named 'TT_TEAM_PPRTEAM' in the database.

Environment

Clarity 16.1.3

Cause

This is caused by duplicate triggers

Resolution

In order to resolve this will need to drop the affected trigger(s):

• Look at the log files to understand which trigger is causing the issue, in this case TT_TEAM_PPRTEAM
• In Administration > Studio > Objects > Edit the team object
• Go to the Audit Trail tab and take note or screenshot of the data being audited
• Remove the audited fields and Save and Return
• Try to add a team member to the investment.
• If it errors out, look at the log file again and see if a different trigger is the cause.
• If there is a new trigger causing the issue, perform the same steps with the object of the trigger in error