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

[Jonathan]

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.
--------------------------------------------------------------------

 

[Gary L. Chefetz]

Jonathan

Unfortunately, the errors are very general and are not enought to lead
anyone to a specific problem, let alone a solution. You say that you
"reimaged" your Project Server, but you don't provide any additonal
information on your setup. An action such as this could have caused any of
dozens of possible problems if the new image didn't contain all the correct
components required. Unless you are very well versed with the technology and
a very good troubleshooter and reporter, this may not be an effiecient
troubleshooting forum, so you might consider a support call with Microsoft
or a Project partner.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[Mark Everett | PMP]

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
Jonathan
---------------------------------------------------------------------------­------------
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.
--------------------------------------------------------------------

When you reimaged Project Server, did you by any chance change the
names of the databases or Analysis Services datastore? Are you using
the same SQL Server? I just helped a client troubleshoot this issue.
They installed a training instance of Project Server to the same SSP
as the Test instance. They pointed the training instance to the test
intance's AS database. Once we discovered that, they created a new AS
db for the training instance and all worked well. Except that now the
Test instance wouldn't work because it contained data from the
training instance.

So i think this is related, but i also think that the restored
version's settings are different from the previous versions' - that's
where the My Timesheet part of the error message comes in. Have you
verified all the settings?

Hope this helps,
Mark Everett PMP MCITP
www.catapultsystems.com