Resource Availability zero for all resources in Views

[Chris]

We are running Project Server 2003 sp2a. We just recently upgraded to sql
2005 running in 2000 mode.

I keep seeing the following warning messgae in the resource availability
views:
Warning: Availability data has not been published for one or more resources
in the selected date range.

I verified that the cube is building successfully every night and even tried
to update only resource availability from the admin page but still get the
warning message.

Any ideas?

 

[Nico Oosthuysen]

There are some weird issues with Project Server 2003 SP2A and earlier when
working with SQL Server 2005.

I have had mine solved by upgrading the Project Server to SP3

 

[Dale Howard [MVP]]

Chris --

If this is not a SQL Server 2005 problem, then refer to the following FAQ:

http://www.projectserverexperts.com/Shared Documents/AvailabilityDataError.htm

Hope this helps.