Prev: Workgroup
Next: Scheduling Agile software development
From: Amit on 17 Mar 2010 10:08
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


From: Dale Howard [MVP] on 17 Mar 2010 11:14
Amit --

Please do not cross-post your Project Server questions in this newsgroup.
Someone already answered your question in the Project Server newsgroup.

--
Dale A. Howard [MVP]
VP of Educational Services
msProjectExperts
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"


"Amit" <Amit(a)discussions.microsoft.com> wrote in message
news:ADC93E74-7CBE-4BD9-ABD5-9BB7848C7033(a)microsoft.com...
> 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
>
>
 | 
Pages: 1
Prev: Workgroup
Next: Scheduling Agile software development