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

Document ID : KB000024614
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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

Solution:

Possible cause:

During trigger creation for the audit trail functionality, a temporary trigger is created. In this case, the trigger was 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. The temporary trigger should be removed.

Something interrupted or happened ,which prevented this temporary trigger from being removed.

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'

Deactivate the TT_PROJECT_IINV_INVESTMENTS trigger. If this resolves the error then delete the TT_PROJECT_IINV_INVESTMENTS trigger.

Verify the T_PROJECT_IINV_INVESTMENTS trigger contains the attributes that are currently selected in the Audit Trail. If there are missing attributes then remove the attributes from the Audit Trail, and then re-add them. Verify you still only have one trigger.