Cube Problem: Cube building process was initiated

[Aaronman]

I am having a problem with my project server not building the OLAP cube. When
I kick off the cube the status changes to "The cube building process was
initiated on .." but the status never changes and I don't get any error in
the application log.

I am running Project Server 2003 on Windows 2003. All services except SQL
are on the same server. I have rerun PSComPlus several times trying to get it
to work. I have rebooted after each try with no luck.

If I go into SQL Analysis server I have two data sources listed for the
"Enterprise Cube". OLAP DS and PC11DSN. If I right click on those sources
choose edit then and click "test" they both test successfully.

If anyone has any ideas I would appreciate it.

 

[Lars Hammarberg]

I've seen the same thing myself - the funny thing here was that the cube
actually built just fine! Apparently the server finished too quickly (!) for
the flag to be set in the database (indicating status of the build
process) - this was on a 4 processor SQLServer with lots of RAM and not too
large a load on it at the time.
Check the data in the cube for recently added data and see if this could not
be the case.

 

[MartinG]

Hi - I had a similar problem recently and found that I had XML files clogging
my viewdrop folder which seemed to result in the cube failing to build.
Taking the offending files out of the folder cleared the problem. We are now
trying to sort out why one of the XML files caused the blockage.

MartinG

 

[Oliver]

We had the same problem and wasted a lot of time to solve the problem but now
we know how to solve this problem. Try the following steps:

Stop and restart the following process on your server: MSP Views
Notificatoin Service. You can do this with Administativ Tools - Services. If
this ist not succsessful stop in your task manager the process
"VWNOTIFY.EXE". If this is also not solving your problem look at your
xml-Files like described in the other replies.

The problem is NOT solved, when you only restart your server. I hope MS will
send a hotfix for this problem. I also don´t know what is the reason for this
error.

Give me feedback, if this assistance was successful.

Oliver

 

[Doug C]

I have tried both suggestions and I still get errors in the event viewer, the
cube does not build, and the EditSite.exe tool connects and everything
passes. Any other suggestions that I might try.

 

[Max]

Hi, I was wondering if any of you was able to find a solution to this problem
since I started getting the same error message.

Thanks, Max

 

[Simon L]

Has anyone come up with another solution to this problem yet? I, too, have
this issue. I have: migrated the repository; assigned correct roles etc,
given valid names to cube but still no cube is created/shown in Analysis
Manager and PServer still informs cube building process has been initiated.

 

[Jonathan Sofer - MCP]

Do you have any special characters in the OLAP cube name. The following
characters can not be used: /";:<>|[],.'?~`!$%^&*()-+={}\

Also, make sure you have none of those characters anywhere in your
enterprise resource names, project names, outline code names or outline code
values. That can potentially hang the analyzer if it is running SQL and
hits a certain sequence of special characters, it can hiccup and hang.

If you do have those characters you might try to remove them and see if that
fixes your issue. If this is a big undertaking than I would say to try it
as a last resort.

 

[Simon L]

Thanks for your help John but no special chars being used at all.

Do you have any special characters in the OLAP cube name. The following
characters can not be used: /";:<>|[],.'?~`!$%^&*()-+={}\

Also, make sure you have none of those characters anywhere in your
enterprise resource names, project names, outline code names or outline code
values. That can potentially hang the analyzer if it is running SQL and
hits a certain sequence of special characters, it can hiccup and hang.

If you do have those characters you might try to remove them and see if that
fixes your issue. If this is a big undertaking than I would say to try it
as a last resort.

--
Jonathan Sofer - MCP
PM Consultant
PCubed - Program Planning Professionals
--

Has anyone come up with another solution to this problem yet? I, too,
have
this issue. I have: migrated the repository; assigned correct roles etc,
given valid names to cube but still no cube is created/shown in Analysis
Manager and PServer still informs cube building process has been
initiated.