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

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

book

Article ID: 255231

calendar_today

Updated On:

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.