Accepting Hours

[Stacey]

Hi,

I must be losing it. This used to be so easy...Using the PWA, I went to
Approvals--> Task Updates and accepted hours. Then I went into Project
desktop and hit publish. I can't see the changes. What am I forgetting?

I really appreciate all of the help I have gotten from this discussion
group. Those people answering are quick and insightful. Thank you!

Stacey

 

[Sean Hanson]

Did you check the Queue to make sure the updates had completed processing?
--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting
SRS Report Packs

 

[Stacey]

Hi Sean,

Thanks for getting back to me so quickly! I am not sure how to check the
queue, but I did publish again and it still didn't change. In the PWA, when
I look at My Tasks, it is updated, but not in Project.

Thx.
S.

 

[Sean Hanson]

You see them in My Tasks, did you select them by checking the box and submit
them to PM for approval on the Tasks Updates page using Submit Selected at
the bottom right of the My Tasks page? With SP1 and Cumulative Updates
applied you can also now Submit All

As far as queue, two places Admin and Individual User, for the Admin it is
Server Settings, Manage Queue and for the Individual it is Personal Settings,
My Queued Jobs.

--
Sean Hanson

http://www.randsmanagement.com
Mass Resource Tool for 2007
Project Server 2007 Archive Tool
2007 ULS Log Reporting
SRS Report Packs

 

[B Weed]

Once you verify from the queue that the "Status Update" step did
complete successfully, here is an SQL query you can run to make sure
their wasn't a failure with the update. Substitute your exact project
name in the last line and run this against your Published DB. Make
sure you have the Project Name entered correctly. Or, remove the "and
pr.proj_name" line and it will return all projects in your instance
with a detected failure.

SELECT
pr.Proj_Name,
Count (*) Updates_To_Reprocess
FROM dbo.msp_assignment_transactions AS tr
INNER JOIN dbo.msp_projects AS pr ON
tr.proj_uid=pr.proj_uid
WHERE tr.ASSN_TRANS_ERROR_ENUM > 0
AND tr.ASSN_TRANS_STATE_ENUM = 4
AND tr.ASSN_TRANS_TYPE_ENUM = 0
and pr.proj_name = 'PROJECT NAME'

If the update failed to apply the hours, this query will identify at
least one of the failure scenarios. If it does not return anything,
then it's not the failure we have experienced.

If this returns a count for your project, I would recommend requesting
from Microsoft their "ApplyMissedWork.exe" utility and instructions
for it's use.

I am unaware if the Oct or Dec cumulative updates resolves the issue
that the .exe was created for.

If anyone has utilized the ApplyMissedWork exe, I would be interested
in your results with it. I'm receiving fairly good results but am
very dissappointed that I have to use it in the first place. Also,
there is a "ReApplyActualWork.exe" that we utilize, but I'm not sure
of what all it is fixing versus what it makes worse.

 

[Gary L. Chefetz]

In my experience, the Apply missed work tool works as expected, however it
doesn't cure the problem where work is not getting applied correctly. In
systems that experience this and other actual work issues, using the Reapply
Actual Work tool can make things worse, as it stumbles over the same bugs
that are causing the actual work to be incorrect to begin with.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[Stacey]

Hi Sean,

I did see them in My Tasks and used Submit All.

For the queue, there is one line. It has a Job Type of Status Update. Job
State is "skipped for optimization". It wn't let me retry the job. I then
went to task updates under approvals and updated them. But my project
doesn't show them as updated.

Thanks!
Stacey