OLAP cube generation doesn't work

[orobla]

We are trying to build an OLAP cube in PWA but we get a lot of errors in the
Event Log. We have created OLAP cube in the past (2 weeks ago) and all was
fine. We are unable to solve these errors. Our MS Project Server instance
version is 2003 with SP1, we have 3 servers: one for the database, one for
the view generator and the other one for the application.

We have installed the EditSite Tool and we have configured it but the
problem persists. Do you know how we can solve it?

Errors in event log:

File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Description: <Description><![CDATA[Cannot open project
'<PC11DSN>\resglobal']]></Description>

Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1195
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

 

[Gary L. Chefetz [MVP]]

orobla:

Check the OLAP admin account that you're using for COM+ and make sure it has
not been disabled or that its password has not expired. Try resetting the
identity using PSCOM+ tool.l

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Nitesh Mathur]

Dear Orobla

The same problem I was faced in past week and we had try some method which
published on Internet forum.

Please check as shown below. I hope this will resolve ur problem.

Ensure OLAPAdmin account is in the local administrator group, were analysis
server is been installed.
We had cross checked the permission and reassigned the required permission
on database as "db_owner" for the OLAP Cube generation.

Try rebuilding the cube by

(1) Move the scheduled cube build to a new time.
(2) Restarted VWNotify service and cube built
(3) Run PSComplus.exe, re-enter the account information for Analysis
Services Access identity

You can find the above tool in the default location were you have
installed project server and look in Bin / 1033 folder

* Uncheck for WSS administration identiy
* Clikc on Delete All COM+ Apps before doing the step 3

for further information go thru this links

- http://support.microsoft.com/default.aspx?scid=kb;en-us;324838