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:myuser@example.com: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.
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;
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.