OLAP Cube Builds--Most of the time

[ProjectAnalyst]

Our OLAP cubes builds in the middle of the night, takes about two hours.

On rare occasions, apparently random, it simpy never finishes.

Does anyone have suggestions on what might be causing this behavior? If
necessary I can provide event log details.

Thanks!

 

[ad9aggie]

ProjectAnalyst,

We have that problem occasionally as well, in fact we found this very
situation this morning when we came in.

In our experience, this is caused by one of three things:

1. The OLAP service on your SQL Server has stopped
2. The Project Views Notify service on your app server has stopped
3. There is an error in COM+ on your app server

Solutions:

1. Restart the OLAP service - you will usually have to restart the cube
because it will report failure after this service is restarted.

2. Restart the Project Views Notification service - this may cause a second
OLAP cube to build after the first one competes.

3. Run PSCom+ and return the OLAP application into COM+ - this invariably
causes a second cube to start processing once the first one finishes

In our case this morning, I checked Analysis Manager and was able to check
the cube, to that wasn't the issue. Project Views Notification service was
started, so that wasn't the issue. I reset COM+, and about an hour later,
the cube finished, and another one started. When it was time for that second
to finish, it hung also. So I checked Analysis Manager and was unable to
connect. I checked with our DBA, and, sure enough, the OLAP service was
stopped. He restarted it, and I received the error that the cube was unable
to complete.

Hope this helps,

ad9aggie

 

[ProjectAnalyst]

Thanks, that's a lot to take in.

Any idea what causes the problem?