book
Article ID: 191242
calendar_today
Updated On:
Environment
Release : 15.7.1
Component : CA PPM INTEGRATIONS & INSTALLATIONS
Cause
ERROR 2020-05-12 14:08:16,124 [https-jsse-nio2-443-exec-123] object.CustomObjectInstanceClass (clarity:{user_id}:5692065__E84FF7E6-4E52-4845-ADA0-9AFBDC127F35:PPM_REST_API) Exception on insert
com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.CMN_UI_PERSONALIZATIONS_U1) violated
ERROR 2020-05-12 14:08:16,124 [https-jsse-nio2-443-exec-123] rest.validation (clarity:{user_id}:5692065__E84FF7E6-4E52-4845-ADA0-9AFBDC127F35:PPM_REST_API) ODFResourceProvider :: Could not create resource. Object code alias: [ requestUrl: https://{the_ustc_url}/ppm/rest/v1/private/personalizations , _restResourceName : personalizations , _id : null , _parentInfo : null , _apiVersion : v1 , _includeLinksArray : true , _contextId : -1 , _hierarchyId : -1]
ERROR 2020-05-12 14:08:16,124 [https-jsse-nio2-443-exec-123] rest.validation (clarity:{user_id}:5692065__E84FF7E6-4E52-4845-ADA0-9AFBDC127F35:PPM_REST_API) ExceptionInfo :: Could not create resource. Resource name: personalizations. Error code: odf.uniqueIndexViolation Error message: ODF-0015: Value must be unique.
Resolution
After customer enabled logging on the agent we identified an issue with bad characters. Had to remove %25 from BadQueryChars from SiteMinder configuration.