AnsweredAssumed Answered

Total Project Cost job is not updating the Cost of Plan

Question asked by Arunpandiyan1 on Feb 2, 2018
Latest reply on Feb 2, 2018 by wilel06



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).