When updating any object instance in Clarity, i.e, Project, an error is thrown:
Error in app-ca.logs:
ERROR 2018-11-16 20:15:56,513 [http-nio-80-exec-75] niku.xql2 (clarity:admin:session_id:projmgr.projectPropertiesPost) Internal Processing exception
com.niku.union.persistence.PersistenceException:
SQL error code: 1422
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "NIKU.ODF_AUD_5001168_FCT", line 5
ORA-06512: at "NIKU.T_PROJECT_OODF_CA_PROJECT", line 291
ORA-04088: error during execution of trigger 'NIKU.T_PROJECT_OODF_CA_PROJECT'
How to proceed with troubleshooting this. If we disable the attribute it works however we need it enabled
Release: Any Supported Releases
Clarity is not accepting the values that are being passed to the audit trigger by the function as there are duplicates in the dynamic lookup query