OLAP cube build interrupted. Cube inaccessible

J

Jeff

During a scheduled OLAP cube build, the Project Server was rebooted. This
has resulted in a state whereby the PWA views think the cube is being built
and yet there is no action occuring on the Analysis Services/SQL Server.

Any help on recovering from this state greatly appreciated.

[email protected]
 
G

Gary L. Chefetz \(MVP\)

Jeff:

What have you done with the cube since this happened? Have you tried
building it? It's quite certain that any process running on a server will
crash when the server does. So, the page which displays the cube is
currently being built will be left in that state as well, but what are the
consequences you've observed?

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-
 
M

Michael

I am experiencing a similar problem. My cube will no
longer refresh. I get a "refreshing cube" message but
then it just sits there forever with no error messages.
I turned full logging on and the process seems to run
through although it doesn't say it is complete in the web
interface. In my case it seems like the views aren't
getting rebuilt. I can manually refresh the cubes
through the analysis services with no problem but the
underlying data within the tables that give the views are
not being updated.
 
G

Gary L. Chefetz \(MVP\)

Bartolini:

Not without seeing the error logs and possibly hands on the system.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-
Bartolini said:
Gary-
My problem is close except....I do not see the message telling me the cube
Click to expand...
is being built. I checked the OLAP account and DCOM+ components to make sure
the correct account is being used. Some one posted earlier and denoted a DLL
registration problem.
 
Top