System error returned when trying to save changes to an idea. Log file refers to an Error updating Financial Metrics

Document ID : KB000118003
Last Modified Date : 23/10/2018
Show Technical Document Details
Issue:
I am getting a system error returned when trying to save changes to an idea. Log file refers to an Error updating Financial Metrics
Environment:
CA PPM 15.X
Cause:
PPM is unable to calculate the simple budget page financial metrics.

Log files show the following error:

INFO  2018-10-22 14:35:26,591 [https-jsse-nio-8043-exec-25] niku.xql2 (clarity:s6238sg:12879313__AF163EE6-CCE8-4BF8-B1BA-8D2CF3F7ADAE:pma.ideaPropertiesSave) Invalid expression cocFunction('BUDGET', $recalcCOC_obj_id, $odf_object_code)
com.niku.union.service.ServiceException: RecalcCostOfCapitalFields: processThisObjectInstance: Error updating Financial Metrics Object Instance ID : 5501021( idea)
    at com.niku.xql2.functions.RecalcCostOfCapitalFields.processThisObjectInstance(RecalcCostOfCapitalFields.java:341)
    at com.niku.xql2.functions.RecalcCostOfCapitalFields.eval(RecalcCostOfCapitalFields.java:133)
    at com.niku.xql2.eval.XQLFunctionNode.eval(XQLFunctionNode.java:27)
    at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)

 
Resolution:
1. Go to Idea Properties > Financial Summary 
2. Ensure Planned Cost Start and Finish Dates are populated
3. Ensure Planned Capital Cost, Planned Operating Cost, Planned capital %, Planned Operating % are populated
4. Planned Benefit value and Planned benefit Start and Finish should also be populated
5. Above data is used to calculate NPV, ROI and other metrics.
6. If data is populated, please do a save action on the financial summary page
The issue is caused due to a problem when recalculating data. The save action can ensure data is populated correctly at DB level and therefore the metric recalculation gets forced