OLAP Cube not getting built

[Anbu]

Hi,

We have a Project Server 2003 installed for the past 1 year. The MSP cubes
were getting built without any problem. However since last week, the MSP
cubes are not getting built. In PWA, the status of cubes is shown as,

"The cube is currently being built."

This status is shown in PWA for days together and in Viewdrop folder i can
see the xml file relate to cube building staged. I had a look at the CPU
utilization and SQL Server process is working hard but viewnotify.exe process
seems to sit idle after a couple of hours of initial processing of the xml
file.

In Analysis Server, the MSP_ASSN_FACT and MSP_RES_AVAIL_FACT cubes are shown
as processed but the MSP_PORTFOLIO_ANALYZER is shown as Not Processed.

Other things tried:
1. Restarted the viewnotify.exe and tried processing the xml file. Result is
the same.
2. Restart the server and tried processing. Result is the same.
3. Delete the OLAP cube database and restored the same from backup. tried
processing. Result is the same.

Please share your thoughts.

 

[Marc Soester]

Anbu, try to delte the OLAP cube database ( as you have done already) but
dont restore a backup, let PWA rebuild the connection instead. That could
solve the problem.

If not check if you have any log files on the server. Let me know how you
went.
thanks

 

[Gary L. Chefetz [MVP]]

Anbu:

Also check the status of the OLAPAdmin account your system uses in COM+. If
the account became disabled or password expired, it would produce the
behavior you report.

 

[Marc Schoeni]

Anbu,

If the steps that Marc and Gary have suggested are not working for you,
please share more information with us regarding your Project Server
environment.

- Are Project Server and SQL Analysis Services running on the same machine?
- How many projects does your Project Server contain?
- What Service Pack version of Project Server is installed?

Hope you get it to work again...

Marc S.
MCP for EPM
www.diventis.ch
www.msepm.blogspot.com

 

[Gary L. Chefetz [MVP]]

Anbu:

Yes, the use of special characters can cause the cube to fail, however the
symptoms are different. The persistence of the "The cube is currently being
built" message usually indicates that the cube build never "really" got
started.

 

[Don]

Have you tried truncating the tables:

TRUNCATE TABLE MSP_CUBE_ASSN_FACT
TRUNCATE TABLE MSP_CUBE_RES_AVAIL_FACT
TRUNCATE TABLE MSP_CUBE_TIME_BY_DAY

 

[Anbu]

Thanks guys. It worked. The MSP cubes were build automatically after deleting
the OLAP cube databse.

Now i'm getting into someother issue. The OLAP cube database had MSP cubes
and some customized cubes. When i deleted the DB, all the cubes were deleted.

The MSP cubes were built successfully. When i tried to build the customized
cubes, it failed giving the following error message in DTS.

Step Error Source: DTSOlapProcess
Step Error Description:Object variable or With block variable not set
Step Error code: 800A005B
Step Error Help File:
Step Error Help Context ID:1000091

Wont the customized cubes build automatically like the MSP cube? Please let
me know your thoughts.

 

[Anbu]

Hi,

I tried deleting the OLAP Cube database and restoring the same from our
backup. I removed the MSP Cubes from the database and left behind the
customized cubes. I initiated cube build process. And this time around all
the cubes were built successfully.

Thanks guys for all your help in getting this sorted out.