Resource availability in PWA

[Lene]

We have a global resource pool with approx. 1000 resources.

All internal resources are added to the resource pool in the same way
by integration to another LOB application.

No resources have limitations in available from available to.

Some resources have Units limited, but most of these show correct
availability

When checking the global resource pool all resources show correct
availability.

But when using PWA and checking resource availability in the "Analyze
Resources in Portfolio Analyzer", some resources show wrong
availability. E.g. The resource Ole Brok Petersen shows wrong
availability, (34,5 hours in 2005 where as several others show 1756,
which is correct) despite that his availability is unlimited.
Checking PWA is shows that Ole only has 34,4 hours availability and
only in 2005 - but that is not correct. Ant the same goes for several
other resources.

We have checked several tables in the SQL server and it seems that the
table

MSP_Ressource for some reason has a problem with the RES_ID.

This example shows that the same RES_ID is allocated to two different
resources


We have crosschecked with several other tables and there seem to be
something wrong, only I cant figure it out.
Can anyone help me???
I have several screenshots, but I can´t apply them to this site
This example is made from real values in different tables and how is it
possible to have the same RES_ID for two different ressources

Res name RES_ID RES_UID RES_EUID
A 13 752 752
B 251 251 251
C 13 13 13

 

[Mike Glen]

Hi Lene,

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

 

[Rich C]

Hi Lene

I had a similar problem with resource availability in PWA and duplicate
resource IDs in some of the DB tables.
Please see the post Double Availability - duplicate resource in the
Microsoft Project Server newsgroup - it may help.

Regards

Rich C

 

[AK]

Have you tried rebuilding the availability in the OLAP cube?

Admin-->Enterprise Features--->Olap Cube--->Availability Only


I've found data is stale until CUBE rebuilt.