Project 2002 Resource Usage View not showing all assignments/tasks.

[brian.rickard]

We recently moved our Project Server 2002 installation from one server
to a newer more powerful machine. The Project Server 2002 database was
restored to the local sql server 2000 installation and Project Server
was then installed. After the installation I applied Service Pack 1 to
the server and all clients accessing the system.

Everything seemed to be fine, but I now have users complaining that the

Resource Usage view is showing only the tasks assigned to the user for
the current project whereas before it would show the task assignments
for all projects.


I have the filters set to All Resources and I have no grouping. The
assignment information isn't completely lost; I can still look up
resource availability by going to the Resources tab (in PWA) and
clicking the "View Availability..." button after selecting the user.


Also, I have restored database backups (to a seperate database, of
course) as far back as 06/24/06 and nothing has changed (leading me to
believe that some recent change to Project Professional 2002 is causing

this bit of selective blindness), but my restore/upgrade of the same
database to Project Server 2003 from a while back has a Resource Usage
view showing exactly what the users are expecting.


I'm stumped for the moment so any input will be appreciated.



Update:

When I open two projects at once, if the same user is in both projects,
I can see all assignments for that resource in the Resource Usage view.
If I close one of the projects, the other project changes and shows
only the Project name instead of all the assignments that resource has
for that project. I assume all the assignments are being rolled up
under the project name for the resource. Then if I close the project
(or save it or publish it, it doesn't seem to matter) the information
goes away and I wont be able to see that information again unless I
open both projects at once.

I'm still stumped, but I think that rules out a problem with the way
the view or filters/groups are set up for the view.

 

[Mike Glen]

Hi Brian,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Brian Rickard]

I can't seem to hit the right newsgroup. Anyway, I've found the
solution. Apparently there is a hotfix that addresses this problem that
Microsoft doesn't make available to the public unless they are
contacted directly. This is, from what I've been told, supposed to be
only used as a last resort and Microsoft would prefer if you waited
until the next service pack is released. As this is MSP 2002 I doubt
there will be another Service Pack.

Here is the related knowledgebase article:
http://support.microsoft.com/kb/867802/en-us

Good luck finding the hotfix :-\