Resource View Availability

[meld]

In the Resource Center, when I select a resource and select View
Availability, the total hours for a resource do not match the what I see in
View assignments. The View Assignments data in PWA matches what I see when I
open the projects in Project Professional and look at Resource Usage. Where
is PWA View Availability getting the data from? Is it from a different
database? The projects have been published. Thanks!

 

[Reid McTaggart]

Can you describe an example of the difference?
Do you use Timesheets?
In View Availability, is Proposed Bookings checked in the view options?

 

[meld]

Reid,

We do not use timesheets. All progress on the schedules is updated by the
project manager in Project Professional. Proposed Bookings is not checked.
If I check it, it does not change the information displayed in View
Availability. I am using one resource to troubleshoot the issue. I have the
date range set to 9/1 - 9/30. The resource is on several projects. For one
of the projects, he has a single task set to be performed 9/21 - 9/29. In
VIew availability it shows that he has zero hours for that project. In
another project, I do not have any scheduled tasks for him from 9/1 - 9/30,
but View availability shows 20 hrs.

Does View Availability get it's data from the same database View Assignments
uses?

Thanks for your help!

 

[Reid McTaggart]

Some (all?) of the data in View Availability comes from the Reporting
database. I think I would look at the queue, and then the event logs, to see
if there are any anomalies.

I'd like to invite the other experts to weigh in on this.

Oh, and what SP / CU levels are you on?

 

[meld]

Reid,

Here is our current CU and SP status:

Version ID Timestamp
12.0.4518.1016 2 2009-03-16 20:33:04.747
12.0.6218.1000 3 2009-03-16 20:33:31.433
12.0.6341.5002 4 2009-04-16 22:03:29.137
12.1.163.0 1 2009-04-16 22:03:16.747

The SP is Service Pack 12.0.6219.1000

Thanks.

 

[Ray McCoppin]

I have seen a number of problems with the queue causing this type of problem.
You must check to see that all project publishes job are sucessful.
Sometimes this requires looking a the ULS logs as well to try and solve why a
publish fails.

Hope this helps
--
Ray McCoppin

http://www.randsmanagement.com
Project Server 2007 ULS Log Reporting Tool
SRS gantt charts