Cube problem

E

Earl Forrence

Hi all,

I have a situation where the same cube has been
reportedly been being built since the 16th of July.

I have changed the Update frequency to be "Update only
when specified" on the 22nd hoping to see the process end;
but it hasn't.

My IS department also rebooted the system today and on
the 23rd to no avail. Cube is still reportedly "being
built".

Questions are then:
1. What might be wrong?
2. What (and how of course) would be the proper way to
shut down the build of a cube so that it can be started
afresh?

We are running Enterprise 2002. Cube (and rest of system)
has been running smoothly for months on end now. We only
have about 36 projects of 200 tasks in the system.

Thanks for any help you can be . Earl
 
G

Gary L. Chefetz \(MVP\)

Earl:

At the very least, we need to know what errors you're seeing in the server
application event log to begin to guess. Do you have more than one instance
of Project Server on the machine? If so, does the cube build on the other
site? If not, consider using the Edit Site utility to create a separate
instance and try building a cube on the empty database. This will at least
tell you if it's related to the setup or the database. I'd post the error
messages first, though.

--

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

-
 
E

Earl Forrence

Gary,

Thanks for answering so quickly. Conceerning your
questions ...

1. Only one instance of Project Server.

(But Transaction file getting very large,
the IS department to clean it up today.)

2. No errors reported ... cube creation just seems to be
in an infinite loop.

From your answer, I take it that you recommend that I
simply create a new cube and see how that goes.

Presumably I can blow away the old when done; yes?

Thanks ... Earl
 
G

Gary L. Chefetz \(MVP\)

Earl:

If there are no errors in the server application event log, then it's more
like shooting blanks or firing into a black hole. That, of course, makes a
difficult diagnosis even more difficult. I doubt that changing the name of
the cube will make a big difference, but there's not harm in trying.

--

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

-
 
Top