Absent Member.. Absent Member..
Absent Member..
1454 views

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

0 Likes
5 Replies
Fleet Admiral
Fleet Admiral

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

0 Likes
Absent Member.. Absent Member..
Absent Member..

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

Absent Member.. Absent Member..
Absent Member..

 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?

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

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.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.