Unable to save a Project in Clarity with ORA-01422 / ORA-04088

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When saving a project, you get a System error, and the below error is thrown in logs:

Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "NIKU.ODF_AUD_5003539_FCT", line 5
ORA-06512: at "NIKU.T_PROJECT_OODF_CA_INV", line 22
ORA-04088: error during execution of trigger 'NIKU.T_PROJECT_OODF_CA_INV'

This happens when when saving the attribute in the Object instance page. The error is thrown by the trigger from the audit trail. 

Note: This error may be on any Clarity object

Cause

• The attribute which is attached to a Dynamic lookup query is throwing the error due to duplicates in the function. 
• The lookup query may have been recently modified and is returning duplicate values when only one value was expected.

Resolution

Workaround: Disable attribute from Audit on the corresponding object

• It is recommended to fix the query to ensure lookup query does not return duplicates and function query matches the lookup query
• Example on how to fix the query can be found here: Can't update a Task if auditing a custom field, System Error
• Also check the troubleshooting article : System Error on Object Update with attribute audit - Troubleshooting