New UX project.errors.couldnotloadprojectpreference and Cannot insert duplicate key row in object 'niku.CMN_UI_PERSONALIZATIONS' with unique index 'CMN_UI_PERSONALIZATIONS_U1'
Article ID: 182916
Updated On:
Products
Issue/Introduction
When we are opening new user experience, we are seeing error - project.errors.couldnotloadprojectpreference/An error occurred while saving preferences/An error occurred while retrieving preferences.
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 we can see there is a duplicate value for user_id /project
Environment
Release : 15.7.1
Component : CA PPM INTEGRATIONS & INSTALLATIONS
Resolution
Those personalizations get generated the first time the user accesses the New UX interface.
You can delete them from REST API via Postman, example URLs:
To check all personalizations:
http://<servername:port>/ppm/rest/v1/private/personalizations
To access a specific personalization:
http:// <servername:port>/ppm/rest/v1/private/personalizations/5001003
To remove flip to DELETE and apply
Feedback
