Prev: MS Project crashes
Next: Microsoft project
From: Jason on 18 Sep 2006 13:08
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.

From: Mike Glen on 18 Sep 2006 16:42
Hi Jason,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP


Jason wrote:
> 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.



 | 
Pages: 1
Prev: MS Project crashes
Next: Microsoft project