OLAP queue job error: 'Your queue job CBSRequest failed'

[Jonathan Glaser]

Our OLAP setup with Analysis Services was running kinda fine (no errors)
until we re-imaged our Project Server with SQL - for an entirely unrelated
reason.

I now get this error and need a '101' explanation how to resolve, please!

Thanks
Jonatha
---------------------------------------------------------------------------------------
Your queue job CBSRequest failed. Please contact your administrator for
assistance

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was
0% complete. It entered the queue at 02/08/2009 23:00:00.

To get more information about the job failure, please go to Project Web
Access. Select Personal Settings from the left menu. Then select My Queued
Jobs.

The errors returned from the queue are as follows:
Error ID: 17004
Error ID: 26000

Detailed error below - send it to the administrator for more detailed
troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17004" name="CBSOlapProcessingFailure"
uid="5df8d9ca-2dff-43bf-88c1-0436ea6cc091" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=MSPROJECT2
ASDBName=Analysis Services Repository ASExtraNetAddress= RangeChoice=0
PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=01/16/2009 13:53:27
ToDate=01/16/2009 13:53:27 HighPriority=False" Error="Analysis Services
session failed with the following error: Failed to process the Analysis
Services database Analysis Services Repository on the MSPROJECT2 server.
Error: Errors in the OLAP storage engine: The linked measure group with the
ID of 'EPM Timesheet', Name of 'EPM Timesheet' cannot be processed because it
contains MG dimension with the ID of 'Task Is Overallocated', Name of 'Task
Is Overallocated' with different granularity attribute than its source
object
Server: The operation has been cancelled
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="0077affa-4963-461b-84d2-1e72ac71fdee"
JobUID="020af5f8-b0ab-44e3-919c-3981b0a1f91f" ComputerName="MSPROJECT2"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

You can do the following:
1. Try troubleshooting using the error IDs, error XML.
2. Contact administrator with your jobID
(020af5f8-b0ab-44e3-919c-3981b0a1f91f) and error XML.
--------------------------------------------------------------------

 

[Mike Glen]

Hi Jonathan,

Try posting on the microsoft.public.project.server newsgroup (forum).
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