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
Status: Published
Updated On: 27-02-2020 10:53
Products:
Clarity PPM On Premise
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