Cant Create an Idea in Clarity TEST, getting error message 'Error 500 Internal Server Error'

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

In the Modern, when trying to create an idea from the "New from Template" option, the following error occurs:

The user has all the possible admin rights.
Browser caches were cleared.

The APP logs show:

ERROR 2022-11-21 10:48:36,726 [http-nio-8082-exec-2385] service.AttributeWriteService (clarity:user:session:PPM_REST_API) Cannot write OBS 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_TEST.AUDIT_OBS_ATTRIBUTES", line 222
ORA-06512: at "NIKU_TEST.AUDIT_OBS_ATTRIBUTES", line 213
ORA-04088: error during execution of trigger 'NIKU_TEST.AUDIT_OBS_ATTRIBUTES'

Executed:
 delete from prj_obs_associations where id in (

Environment

Release : 16.0.1

Resolution

There is a trigger that is being used: NIKU_TEST.AUDIT_OBS_ATTRIBUTES.

From the audited idea and project object, review the audited attributes and find out which one is causing the issue. 

A Support case can be opened to review.