Modern UX global.errors.load.couldNotRetrievePreferences Error

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We are getting following error while accessing Modern User Experience (UX) using following URL: https://clarityurl/pm/#/projects

global.errors.load.couldNotRetrievePreferences

We find the following errors in the app-ca.log:

ERROR 2021-03-11 18:28:38,596 [ajp-nio-127.0.0.1-8009-exec-7] rest.validation (clarity:admin:.......:PPM_REST_API) ODFResourceProvider :: Could not create resource. Object code alias: [ requestUrl: https://clarityurl/ppm/rest/v1/private/personalizations , _restResourceName : personalizations , _id : null , _parentInfo : null , _apiVersion : v1 , _includeLinksArray : true , _contextId : -1 , _hierarchyId : -1]
ERROR 2021-03-11 18:28:38,596 [ajp-nio-127.0.0.1-8009-exec-7] rest.validation (clarity:admin:.......:PPM_REST_API) ExceptionInfo ::  Could not create resource. Resource name: personalizations. Error code: odf.uniqueIndexViolation Error message: ODF-0015: Value must be unique.
ERROR 2021-03-11 18:29:00,490 [ajp-nio-127.0.0.1-8009-exec-6] ppm.rest (clarity:admin:.......:PPM_REST_API) Invalid operator = for filter string ((component = 'blueprint'
ERROR 2021-03-11 18:29:34,152 [ajp-nio-127.0.0.1-8009-exec-5] ppm.rest (clarity:admin:.......:PPM_REST_API) Invalid operator = for filter string (isSystem = true)
ERROR 2021-03-11 18:39:49,682 [ajp-nio-127.0.0.1-8009-exec-10] ppm.rest (clarity:admin:.......:PPM_REST_API) Invalid operator = for filter string ((component = 'project'
ERROR 2021-03-11 18:39:49,744 [ajp-nio-127.0.0.1-8009-exec-7] ppm.rest (clarity:admin:.......:PPM_REST_API) Invalid operator = for filter string ((component = 'general'
ERROR 2021-03-11 18:39:50,166 [ajp-nio-127.0.0.1-8009-exec-7] object.CustomObjectInstanceClass (clarity:admin:.......: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 (5xxxxx, project).
 at com.niku.union.persistence.PersistenceController.checkPMDOverride(PersistenceController.java:2067)
 at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2253)

Environment

Release : 15.9

Component : CA PPM STUDIO

Resolution

1. Obtain and review the APP access logs for the day and time period the issue was reported.
Check for HTTP errors that have occurred.

2. Restart Clarity app services. 

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

Additional Information

Note: If the issue is only through SSO:

• Work with your SSO/LB team to check:
• If there is any change in SSO (SSO blocking certain characters in the request as bad characters)