search cancel

Populate from Allocation in cost plan not possible


Article ID: 229452


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


We receive the following error when we try to use "Populate from Allocation" in a Cost Plan, in the Modern UX:

Error while Populating Cost Plan from Allocations

The following corresponding error in the app-ca.log is noticeable:

ERROR 2021-31-31 25:06:08,273 [https-jsse-nio2-8444-exec-1903] services.CostPlanDetailInsertService (clarity:admin:130__06F1-A231-4CA3-B51D-D5AF29E6374B:PPM_REST_API) Exception while inserting cost plan detail 
com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (NIKU.FIN_COST_PLAN_DETAILS_U1) violated


The FIN_COST_PLAN_DETAILS_U1 defines that the data in following set of columns be unique. When a duplicate is attempted to be inserted, an error is raised.



Version: 15.X,16.X


The Cost Plan was being grouped by Resource, Role, Cost Type and Charge Code. One of the resources in the Project Team did not have a Primary Role. Assigning a Primary Role to that team member resolved this issue.