Receive ‘System Error’ when an attribute such as a custom attribute (Solution Owner) attribute is audited for Changes in Clarity PPM.
Excerpt of 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
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 "YOUR_SCHEMA.ODF_AUD_5001168_FCT", line 5
ORA-06512: at "YOUR_SCHEMA.T_PROJECT_OODF_CA_PROJECT", line 291
ORA-04088: error during execution of trigger 'YOUR_SCHEMA.T_PROJECT_OODF_CA_PROJECT'
The error in the logs above indicates that it is not accepting the values that are being passed to the audit trigger.