When creating new projects from either New or New From Template we get the following error: ODF-0015: Value must be unique.

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When creating new projects from either "New" or "New From Template" we get the following error: ODF-0015: Value must be unique.

Cause

• During trigger creation for the audit trail functionality, a temporary trigger is created.
• In this case, the trigger is called: TT_PROJECT_IINV_INVESTMENTS
• After the trigger is validated and compiled by the database, it gets renamed or copied to a similarly named trigger: T_PROJECT_IINV_INVESTMENTS
• Afterwards, the temporary trigger should be removed.

Resolution

While triggers were being created, something went wrong that prevented the temporary trigger from being removed.
Verify the T_PROJECT_IINV_INVESTMENTS trigger contains the attributes that are currently selected in the Audit Trail.
1. Take a note the attributes that are selected on the audit trail.
2. Remove all attributes from the Audit trail
3. Save the changes
4. Re-add the attributes to the Audit Trail
Removing and re-adding the attributes to the audit trail will regenerate the trigger.

Additional Information

Here is the error from the application server log file:

ERROR 2015-04-28 15:28:50,200 [http-8080-Processor98] niku.xql2 (admin:37590683__-56afff8c:projmgr.projectNewPost) Invalid Throw
element, missing sub elements:com.niku.xql2.XQLVisitorException
Here is the error from an Action Trace:

NDE:PSTM@48234823: FAIL: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint 
(CLARITYDB.ODF_AUD_OBJ_INST_CONTEXT_N1) violated ORA-06512: at "CLARITYDB.T_PROJECT_IINV_INVESTMENTS", line 64 
ORA-04088: error during execution of trigger 'CLARITYDB.T_PROJECT_IINV_INVESTMENTS'