Clarity

  • 1.  Total Project Cost job is not updating the Cost of Plan

    Posted Feb 02, 2018 08:46 AM

    Hello,

     

    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.

     

    Navigation:

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



  • 2.  Re: Total Project Cost job is not updating the Cost of Plan
    Best Answer

    Broadcom Employee
    Posted Feb 02, 2018 02:13 PM

    Arun,

     

    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.

     

    Liz