PWA Cube Build Fails (Timout Occurred)

J

Jason

This is similar, but not the same as a common problem with building the OLAP
cube in PWA. I get this error message on Project Web Access:

The cube scheduled to be built on DateTime failed.
(-2147221392) Timeout occurred.

This is similar to the common message:

The cube scheduled to be built on DateTime failed.
(-2147217871) Timeout expired

I read this article (http://support.microsoft.com/kb/912259/en-us) that
resolves the more common message. It says to truncate these tables:
MSP_CUBE_ASSN_FACT
MSP_CUBE_RES_AVAIL_FACT
MSP_CUBE_TIME_BY_DAY

It then says to modify the timeout in the registry if the truncating doesn't
solve the problem.

I did both of these, but it still doesn't work. For a few weeks, it would
work if I restarted the OLAP service on the analysis services server and then
rebuilt the cube, but this no longer works.

There are no files stuck in the ViewDrop folder and no messages in the
application log on the database/analysis server.

On the Project server, there are many errors, none of which make much sense
to me.

Common ones are:

Component: PDS
Line: 0
Error Number: 0x2599
Description: <Description><![CDATA[CDataAccess.ExecuteSP; -2147217871 :
Timeout expired]]></Description>

Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 241
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2264
Error Number: 0x8c040017
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Please help!

This just started a couple of months ago, nothing has changed that I know of.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top