Absent Member.. randull Absent Member..
Absent Member..
88 views

PPM Support Tip: Cost Health Indicator in Blank

 

Knowledge base article: KM00786102

 

There are two projects, both withe the same Request Type, both appear to have the same settings. Why is the Cost Health blocked on one and green on the other?

 

This is the way how the cost indicator is shown:


1.For new project, the  indicator is blank.
2.If you add some cost lines, indicator's color is green
3.You can add some tasks to trigger the running of cost service and the indicator will be blank.

Please run the following query,

select PM_PROJECT_ROLLUP.* from PM_PROJECTS,PM_PROJECT_ROLLUP

where PM_PROJECTS.ROLLUP_ID=PM_PROJECT_ROLLUP.ROLLUP_ID and PM_PROJECTS.PROJECT_ID=<real project id>

 

 

If value of COST_HEALTH_INDICATOR is none, please try to update its value to GREEN (only this record).

 

update PM_PROJECT_ROLLUP set COST_HEALTH_INDICATOR='GREEN'

Where ROLLUP_ID=(select PM_PROJECT_ROLLUP.ROLLUP_ID from PM_PROJECTS,PM_PROJECT_ROLLUP

where PM_PROJECTS.ROLLUP_ID=PM_PROJECT_ROLLUP.ROLLUP_ID and PM_PROJECTS.PROJECT_ID=<real project id>)

and COST_HEALTH_INDICATOR=''

 

NOTE:

1.Customer should backup all tables used here.

2.Customer should export production data to testing DB and try the SQL in testing DB first.

Best regards,
Randall

-- Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Labels (1)
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.