When opening Modern UX / New User Experience (UX), users are seeing error - project.errors.couldnotloadprojectpreference / An error occurred while saving preferences / An error occurred while retrieving preferences.
Error seen in app-ca.logs:
ERROR 2020-01-23 13:48:18,421 [ajp-nio-127.0.0.1-30001-exec-6] object.CustomObjectInstanceClass (clarity:admin:17741019__71ED4DB4-57B6-4347-A5EC-B546674415B7:PPM_REST_API) Exception on insert
com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'niku.CMN_UI_PERSONALIZATIONS' with unique index 'CMN_UI_PERSONALIZATIONS_U1'. The duplicate key value is (5145024, project).
When checking in CMN_UI_PERSONALIZATIONS there is a duplicate value for user_id /project
Release :Any
Those personalizations get generated the first time the user accesses the MUX interface.
http://<servername:port>/ppm/rest/v1/private/personalizations
http:// <servername:port>/ppm/rest/v1/private/personalizations/5001003
http:// <servername:port>/ppm/rest/v1/private/personalizations/5001003
5001003 in this case refers to ID column in the cmn_ui_personalizations table
Also on table CMN_UI_PERSONALIZATIONS there is a column called USER_ID and this column holds The user ID of the user for whom these personalizations apply.