Error returning to Roadmap list: An error occurred while saving preferences

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

After editing a roadmap when trying to get back to the Roadmap list I get an error: An error occurred while saving preferences

When looking to the log files I see the following error:

ERROR 2022-08-05 11:25:04,242 [http-nio-8080-exec-1378] object.CustomObjectInstanceClass (clarity:[email protected]:24456100__A2468D33-2A4C-4615-8C54-A02DB7F0A7A1:PPM_REST_API) Exception on insert
com.niku.union.persistence.PersistenceApplicationException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "cmn_ui_personalizations_u1"
  Detail: Key (user_id, component)=(5009032, undefined) already exists.

Resolution

1. Get CMN_SEC_USERS.id of the user having the issue.

2. Run the query:

select * from CMN_UI_PERSONALIZATIONS
WHERE user_id = 5009032
AND component = 'undefined'

3. Make a backup of the table CMN_UI_PERSONALIZATIONS

4. Run query:

delete from CMN_UI_PERSONALIZATIONS
where user_id = 5009032
AND component = 'undefined'
commit;

Additional Information

Also see: MUX project.errors.couldnotloadprojectpreference - Cannot insert duplicate key Row

It has also been noticed that saving a new view in the Roadmap List stops this error from appearing, under certain circumstances.