New UX project.errors.couldnotloadprojectpreference - Cannot insert duplicate key Row

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When we are opening Modern UX / New User Experience (UX), we 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 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

Additional Information

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.