OLAP Cube not building and Resources table rows empty

[Kurte]

I recently installed Project Server 2003 and Analysis Services along with
View Processing on a server which has SharePoint 2003 installed. The database
is on another server. Both Project Server, Analysis Services and SQL 2000 are
on Service Pack 3.

I have also migrated the Analysis Services Repository to database server and
all the required permissions from what I can see are set on the database
included the project server database.

The Olap Administrators groups is also on both Servers and the user
configured for the OLAP cube components has administrators rights. To build
the cube I first try to update the resource availibility table but when I
check the MSP_VIEW_RES_TP_BY_DAY table the rows are blank. As I initiate this
process I did a check in the component services and see that the OLAP process
starts, VNOTIFY.exe services is also running.

The application event logs do not have any errors relating to Project 2003.
In terms of project publishing there are no problems here we can post
projects to Project Web Access without any problems.

I would really appreciate if anyone on this group have any suggestions that
I could try to resolve this problem.

Thanks

Kurte

 

[JulieS]

Hi Kurte,

You may get a more rapid response if you re-post your question to the
Project server (microsoft.public.project.server) newsgroup. This group
is focused upon the desktop version of Project.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

 

[Kurte]

Thanks will do.

Hi Kurte,

You may get a more rapid response if you re-post your question to the
Project server (microsoft.public.project.server) newsgroup. This group
is focused upon the desktop version of Project.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.