The ACWP amount is not rolled up the Task Hierarchy

Document ID : KB000028729
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

We are comparing the Project ACWP value to the individual Task ACWP values.  There is an inconsistency in some projects where the individual Task ACWP value is higher than the Project ACWP.  We tried updating the values by executing the 'Update Earned Value' job and also by selecting all the Tasks and clicking the 'Update Costs' value.  What could cause this discrepancy and how can we update the total ACWP for the project?  

Cause:

When you click the 'Update Costs' action for the selected Tasks you are executing the same code for the 'Update Earned Value' job.  So both actions should update the ACWP at all levels of the Task Hierarchy.  Examine the background log (BG-CA.LOG) file for error messages.  If you see the following message, this indicates a broken link in the sequencing of the Task Hierarchy.  

ERROR 2015-12-08 05:05:57,809 [Dispatch pool-5-thread-7 : bg@localhost (tenant=clarity)] Utils.EVSlicer 
(clarity:admin:16595786__808E17B3-784D-4349-360A-84DBE0302591: Update Earned Value Totals)  
EVProjectElement.AddTaskElement:  Cannot find parent task [seqNum= 24] for taskID 5365278 

Resolution:

To resolve this issue, follow these steps:  

  1. Go to the project and locate the Task identified by the internal Task ID value in the error message  
  2. Move this task to the top level of the hierarchy and then move it back to the original location 
  3. This will update the sequence number and restore the parent-child relationship of the task in the hierarchy 
  4. Execute the 'Update Earned Value' job again for the entire project 
  5. Check the ACWP values in the UI
  6. If a discrepancy still appears, check the BG log again for further messages and repeat the steps if necessary