You have an existing project that is financially enabled. You change the department (which clears out the Location attribute) and save the project. At a later date, you re-populats the location and save. The location shows up in the UI, but when you XOG the project out, the location is not present in the XML.
If you try to change the location in the UI, you the get the error message in the log file.
ERROR 2020-04-20 12:56:15,520 [ajp-nio-8009-exec-5] niku.xql2 (clarity:user:xxxxxxxxx:projmgr.projectPropertiesPost) Internal Processing exception
SQL error code: 2601
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'niku.OBS_UNIT_ENTITIES_V2' with unique index 'OBS_UNIT_ENTITIES_V2U1'. The duplicate key value is (5066009, SRM_PROJECTS, OBS_UNIT_AND_CHILDREN, 5001001).
SQL error code: 3621
What is causing this error in the environment and how we can avoid this error?
This is due to a permission issue when you have Location level OBS rights and maks the change to Location. Example:
Release : Any