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:
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'
delete from prj_obs_associations where id in (
Release : 16.0.1
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.