We've made a cost plan as plan of record and ran "Total Project cost: job. But theTotal Project Cost job is not updating the Cost Plan of Record for frew projects.Kindly could be the possible root cause that is causing this issue. Thank you.
Financial Plans / click Cost Plan of Record / Properties / Check "Update Planned Cost with Actuals" checkbox / click "Save and Return".
Error Message in the process messages page:
<ErrorInformation> <Severity>ERROR</Severity> <Description>An exception occurred while trying to update an object instance costplandetail</Description> </ErrorInformation>
Error message in app-ca:
com.niku.union.persistence.PersistenceApplicationException: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'niku.FIN_COST_PLAN_DETAILS' with unique index 'FIN_COST_PLAN_DETAILS_U1'. The duplicate key value is (5512013, 5001006, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, <NULL>, 5002735).
Is the job Total Project Cost a custom job?
In general, a cost plan already created will not update planned costs unless you repopulate it. It will only update actual costs from WIP.