Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR: cost rollup with id xxxxxx failed

Highlighted
optinf
Occasional Advisor

ERROR: cost rollup with id xxxxxx failed

Hi,

We are running PPM 9.14.0004 and we get lot off error in server log like the following one.

 

 

ERROR :ppmHeavyServiceListenerContainer-1:com.mercury.itg.core.cost.CostEngine:2013/01/04-18:53:19.728 EST: Cannot find a matching cost rate rule at all, please contact your ITG administrator.
ERROR :ppmHeavyServiceListenerContainer-1:com.mercury.itg.core.cost:2013/01/04-18:53:19.728 EST: cost rollup with id 3028098 failed.
ERROR server:ppmHeavyServiceListenerContainer-1:com.mercury.itg.core.cost:2013/01/04-18:53:19.728 EST:


com.mercury.itg.exceptions.InfrastructureException: Cannot find a matching cost rate rule at all, please contact your ITG administrator.
GUID=32CCFA02-E506-8EFC-8162-1D1FD60AF431
 at com.mercury.itg.core.cost.CostEngine$CostRuleMatchingStrategy.getBestMatchingCostRate(CostEngine.java:716)
 at com.mercury.itg.core.cost.CostEngine.calculateCost(CostEngine.java:445)
 at com.mercury.itg.core.cost.CostEngine.calculateCostAndContour(CostEngine.java:376)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil$BaseCostRollupVisitor.updateTaskPlannedCost(ProjectCostUtil.java:554)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil$BaseCostRollupVisitor.updateTaskCosts(ProjectCostUtil.java:309)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil$WorkPlanRollupVisitor.visit(ProjectCostUtil.java:914)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil.postOrderTraverse(ProjectCostUtil.java:261)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil.postOrderTraverse(ProjectCostUtil.java:257)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil.recalculateCost(ProjectCostUtil.java:187)
 at com.mercury.itg.core.cost.rollup.ProjectRollupService.recalculateCosts(ProjectRollupService.java:518)
 at com.mercury.itg.core.cost.rollup.ProjectRollupService.rollupSingleProject(ProjectRollupService.java:254)
 at com.mercury.itg.core.cost.rollup.ProjectRollupService.rollupSingle(ProjectRollupService.java:103)
 at com.mercury.itg.core.cost.rollup.AbstractRollupService$1.run(AbstractRollupService.java:90)
 at com.mercury.itg.util.HibernateTemplate.doRun(HibernateTemplate.java:179)
 at com.mercury.itg.core.cost.rollup.AbstractRollupService.runRollups(AbstractRollupService.java:103)
 at com.mercury.itg.core.cost.rollup.AbstractRollupService.runServiceImpl(AbstractRollupService.java:46)
 at com.mercury.itg.core.cost.CostRollupService.runServiceImpl(CostRollupService.java:82)
 at com.mercury.itg.core.server.mdServices.PluggableHibernateMDService.runService(PluggableHibernateMDService.java:39)
 at com.mercury.itg.core.jms.service.impl.GenericServiceMessageHandler.handleMessage(GenericServiceMessageHandler.java:71)
 at com.mercury.itg.core.monitor.impl.BackgroundServiceMonitorAspect.monitorService(BackgroundServiceMonitorAspect.java:104)
 at com.mercury.itg.core.jms.service.impl.ServiceMessageListenerImpl.onServiceMessage(ServiceMessageListenerImpl.java:357)
 at com.mercury.itg.core.jms.service.impl.ServiceMessageListenerImpl.onMessage(ServiceMessageListenerImpl.java:183)

 Filtered Out 33 Stack Trace Lines.
ERROR :ppmHeavyServiceListenerContainer-1:com.mercury.itg.core.cost.CostEngine:2013/01/04-18:53:20.135 EST: Cannot find a matching cost rate rule at all, please contact your ITG administrator.
ERROR :ppmHeavyServiceListenerContainer-1:com.mercury.itg.core.cost:2013/01/04-18:53:20.150 EST: cost rollup with id 3027965 failed.
ERROR server:ppmHeavyServiceListenerContainer-1:com.mercury.itg.core.cost:2013/01/04-18:53:20.150 EST:


com.mercury.itg.exceptions.InfrastructureException: Cannot find a matching cost rate rule at all, please contact your ITG administrator.
GUID=5931D949-E9BE-AB9D-27A8-B14402A066CD
 at com.mercury.itg.core.cost.CostEngine$CostRuleMatchingStrategy.getBestMatchingCostRate(CostEngine.java:716)
 at com.mercury.itg.core.cost.CostEngine.calculateCost(CostEngine.java:445)
 at com.mercury.itg.core.cost.CostEngine.calculateCostAndContour(CostEngine.java:376)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil$BaseCostRollupVisitor.updateTaskPlannedCost(ProjectCostUtil.java:554)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil$BaseCostRollupVisitor.updateTaskCosts(ProjectCostUtil.java:309)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil$WorkPlanRollupVisitor.visit(ProjectCostUtil.java:914)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil.postOrderTraverse(ProjectCostUtil.java:261)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil.postOrderTraverse(ProjectCostUtil.java:257)
 at com.mercury.itg.pm.cost.util.ProjectCostUtil.recalculateCost(ProjectCostUtil.java:187)
 at com.mercury.itg.core.cost.rollup.ProjectRollupService.recalculateCosts(ProjectRollupService.java:518)
 at com.mercury.itg.core.cost.rollup.ProjectRollupService.rollupSingleProject(ProjectRollupService.java:254)
 at com.mercury.itg.core.cost.rollup.ProjectRollupService.rollupSingle(ProjectRollupService.java:103)
 at com.mercury.itg.core.cost.rollup.AbstractRollupService$1.run(AbstractRollupService.java:90)
 at com.mercury.itg.util.HibernateTemplate.doRun(HibernateTemplate.java:179)
 at com.mercury.itg.core.cost.rollup.AbstractRollupService.runRollups(AbstractRollupService.java:103)
 at com.mercury.itg.core.cost.rollup.AbstractRollupService.runServiceImpl(AbstractRollupService.java:46)
 at com.mercury.itg.core.cost.CostRollupService.runServiceImpl(CostRollupService.java:82)
 at com.mercury.itg.core.server.mdServices.PluggableHibernateMDService.runService(PluggableHibernateMDService.java:39)
 at com.mercury.itg.core.jms.service.impl.GenericServiceMessageHandler.handleMessage(GenericServiceMessageHandler.java:71)
 at com.mercury.itg.core.monitor.impl.BackgroundServiceMonitorAspect.monitorService(BackgroundServiceMonitorAspect.java:104)
 at com.mercury.itg.core.jms.service.impl.ServiceMessageListenerImpl.onServiceMessage(ServiceMessageListenerImpl.java:357)
 at com.mercury.itg.core.jms.service.impl.ServiceMessageListenerImpl.onMessage(ServiceMessageListenerImpl.java:183)

 Filtered Out 33 Stack Trace Lines.

 

 

 

What should i do to solve this problem?

 

Thank

5 REPLIES
Erik Cole
Honored Contributor

Re: ERROR: cost rollup with id xxxxxx failed

Double-check your cost rules, and that you have a default one for cases that are not met by any other rule...?

Oscar_Pereira
Frequent Visitor

Re: ERROR: cost rollup with id xxxxxx failed

Hello,

 

The root cause for the initial exception  cost rollup with id xxxxxx failed  could be that the source and target entities for the rollup do not exist. They might have been deleted between the time the pending rollup row was inserted into itg_pending_rollups table and when the cost rollup service ran.

 

The data in itg_pending_rollups should be processed by these services.


Cost Rollup Service (TARGET_ENTITY_ID = 6, ROLLUP_TYPE_CODE = 'COST')
Task Actual Rollup Service (SOURCE_ENTITY_ID = 59, ROLLUP_TYPE_CODE = 'ACTUAL')

 

Run this query to indentify which records are stuck:

 

select distinct r.SOURCE_ENTITY_ID, r.SOURCE_ENTITY_PRIMARY_KEY, r.TARGET_ENTITY_ID, r.TARGET_ENTITY_PRIMARY_KEY
from itg_pending_rollups r
where r.ROLLUP_TYPE_CODE = 'COST';

 

And run this SQL to select invalid pending items that don't have associated tasks

 

SELECT *
FROM itg_pending_rollups ROLLUP
WHERE rollup_type_code = 'ACTUAL'
AND ( source_entity_primary_key IS NULL
OR NOT EXISTS (SELECT 1
FROM wp_tasks tasks
WHERE tasks.task_id = ROLLUP.source_entity_primary_key)
)

 

Thanks

Oscar Pereira

Juan_Luis
Acclaimed Contributor

Re: ERROR: cost rollup with id xxxxxx failed

 Hello Oscar,

 

 

 

    I ran the SQLs in your comment and I found 247 rows. but what will the solution? Any place where I can read the solution?  Please

 

from this one I have 247 rows

select distinct r.SOURCE_ENTITY_ID, r.SOURCE_ENTITY_PRIMARY_KEY, r.TARGET_ENTITY_ID, r.TARGET_ENTITY_PRIMARY_KEY
from itg_pending_rollups r
where r.ROLLUP_TYPE_CODE = 'COST';

 

 

From the other one I have Zero.

 

  What will the solution?

Pedro_X
Occasional Contributor

Re: ERROR: cost rollup with id xxxxxx failed

SIMI SIVARAJAN
Super Collector

Re: ERROR: cost rollup with id xxxxxx failed

Am not able to view the contents of the below link.

http://community.hpe.com/t5/Project-and-Portfolio-Management/cost-rollup-with-id-lt-gt-failed/m-p/6307947/thread-id/2155

could you please let me know what exactly is mentioned. I am also seeing the error related to the cost rollup in the log files.

//Add this to "OnDomLoad" event