Project and Portfolio Management Practitioners Forum
cancel

Estimated effort of a staffing profile

Highlighted
Mahen M
Acclaimed Contributor.

Estimated effort of a staffing profile

Hi

I am trying to pull the estimated effort of a staffing profile

I use KRSC_STAFF_PROF_PERIOD_SUM table.

However, I found that one of the staffing profile which was created a few days back does not appear in that table.

SP Details:

1.SP was attached to a project
2. It has estimated effort entered and allocations were made for it
3.SP was in 'In plannin' status

Please advise ASAP.

Regards,
Mahendran M
5 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Estimated effort of a staffing profile

How often is your Staffing Profile Period Sum Update Service set to run?
Mahen M
Acclaimed Contributor.

Re: Estimated effort of a staffing profile

Hi
Thanks. Can you please elaborate on this. I have always thought this is an internal system table and gets the value inserted automatically.

Thank you.

Regards,
Mahendran M
Nisha Kurien
Honored Contributor.

Re: Estimated effort of a staffing profile

In the Workbench, select Sys Admin->Server Tools. From the drop down select Service Controller Report.

Run this report. This report will detail when different services run. The interval can be set/changed in the server.conf parameter.

You should check the interval for the service
Effort Decompression Service and Staffing Profile Period Sum Update Service.

This report also gives information about when the service last ran. This is possibly the reason why the SP doesnt show up.

Let me know if this helps.

- Nisha Kurien
Vingerhoeds
Contributor.

Re: Estimated effort of a staffing profile

Hi,

I have similar "problems"
The Service Controller Report shows me the below data which should give me an update every 2 hours (Effort Decompression = 120min). However, the Data Export "Analyze Resource Pool" shows a time of last midnight, which is the default setting.
Any hints?

Thanks

Arjan

Staffing Profile Period Sum Update Service false 300 true Thu Sep 17 11:15:00 CEST 2009 Thu Sep 17 11:19:59 CEST 2009
Effort Decompression Service false 7200 true Thu Sep 17 10:00:00 CEST 2009 Thu Sep 17 11:59:59 CEST 2009
Sachin M
Respected Contributor.

Re: Estimated effort of a staffing profile

Hi Mahendran,


The Data is not rolling up with Staffing profiles?
Staffing profile & data from analyse resorce pools is not matching?
The observation which we have from debug in Database :
Specifically KRSC_STAFF_PROF_PERIOD_SUM data is not updated eventhough staffing profile lines are updated.

For this problem we opened a ticket with HP and they told it has been fixed in 7.5 SP4.
After applying SP4 this issue has been resolved.

Regards
Sachin