OLAP Cube fails to build -timeout occurred

J

Jason

I have posted this multiple times, but never get a response, so forgive me
for posting it again, I'm hoping that someone has seen this issue:

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.
 
M

Marc S.

Jason,

the good ol' cube making problems again... ;)

Have you tried deleting the entire cube in Analysis Services, truncate the
tables and letting the cube build from scratch again?

Maybe it would be helpful if you could give a brief overview on what your
architecture looks like.

Hope this helps...

Marc
 

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