Failed to process the Analysis Services database XX_Cube on the se

[Amit]

Hi All,

I have issue with Project server 2007 (With SP2 & all latest updates) OLAP
cube (No customization) . Cube use to build everyday but after we loaded
almost 600+ resources (all valid NT users no Form based authentication) in
system, Cube took almost 12 hours but finally returned the error :

Error summary/areas:
CBS message processor failed
CBSOlapProcessingFailure
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17004" name="CBSOlapProcessingFailure"
uid="f5e399c5-c26c-4acd-bb97-54c4afc0c401" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=nawinclssql009
ASDBName=PS_Cube ASExtraNetAddress=nawinclssql009 RangeChoice=0 PastNum=1
PastUnit=0 NextNum=1 NextUnit=0 FromDate=03/16/2010 10:52:02
ToDate=03/16/2010 10:52:02 HighPriority=True" Error="Analysis Services
session failed with the following error: Failed to process the Analysis
Services database PS_Cube on the nawinclssql009 server. Error: The
ProjectServerViewOlapDataRole role referenced by the
ProjectServerViewOlapDataRole permission does not exist in the PS_Cube
database
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="aa717aaf-c22f-4ac0-923b-96c6631a5b14"
JobUID="55114abf-7fc9-4da8-9de0-029e1cd9f015" ComputerName="CVGWINEPMP009"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>


Please advice on error "The ProjectServerViewOlapDataRole role referenced by
the ProjectServerViewOlapDataRole permission does not exist in the PS_Cube "

Thanks for the help.

Amit K

 

[Stephen Sanderlin [MVP]]

What are the version numbers of your SQL Server and SQL Analysis Server
installations?

--
Stephen Sanderlin, Project MVP
VP of Technology
msProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com

 

[Amit]

Hello Stephen..Thanks for your response.

We have SQL server 2008 SP1 & SQL server 2008 Analysis services.

Thanks,
Amit

 

[Stephen Sanderlin [MVP]]

Hm. Does the build succeed if you change the name of the cube to
something else (i.e. creating a new cube)?

--
Stephen Sanderlin, Project MVP
VP of Technology
msProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read our blog at: http://www.projectserverhelp.com