PS2007. Cube Build Failure. Failed to connect to the Analysis Serv

[PedroJose]

Hi All,

We just noticed that the cube build fails. Can someone please help???

We have PS2007 on SQL2005 SP3. As background:

Everything was fine up to last week. We upgraded SQL 2005 unpatched to SP3.
It looks like this is when the problem started. The error we get from PWA
Cube Build Status Page is:
"Failed to build the OLAP cubes. Error: Analysis Services session failed
with the following error: Failed to connect to the Analysis Services server
Lincoln. 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. Errors in the metadata manager. An error occurred when loading
the EPM Timesheet measure group, from the file, '\\?\C:\Program
Files\Microsoft SQL
Server\MSSQL.3\OLAP\Data\PPLLCcube.0.db\MSP_Project_Timesheet.0.cub\EPM
Timesheet.1.det.xml'. Errors in the metadata manager. An error occurred when
loading the MSP_Project_Timesheet cube, from the file, '\\?\C:\Program
Files\Microsoft SQL
Server\MSSQL.3\OLAP\Data\PPLLCcube.0.db\MSP_Project_Timesheet.1.cub.xml'."

The error from the queue is:
"Error summary/areas:
CBS message processor failed
CBSASConnectionFailure
Queue
GeneralQueueJobFailed
Error details:

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17003" name="CBSASConnectionFailure"
uid="287cbe02-837c-4707-b90d-9f2fc3b80718" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=Lincoln ASDBName=TEST1
ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0
FromDate=01/21/2009 17:20:15 ToDate=01/21/2009 17:20:15 HighPriority=True"
Error="Analysis Services session failed with the following error: Failed to
connect to the Analysis Services server Lincoln. 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.
Errors in the
metadata manager. An error occurred when loading the EPM Timesheet measure
group, from the file, '\\?\C:\Program Files\Microsoft SQL
Server\MSSQL.3\OLAP\Data\PPLLCcube.0.db\MSP_Project_Timesheet.0.cub\EPM
Timesheet.1.det.xml'.
Errors in the metadata manager. An error occurred when
loading the MSP_Project_Timesheet cube, from the file, '\\?\C:\Program
Files\Microsoft SQL
Server\MSSQL.3\OLAP\Data\PPLLCcube.0.db\MSP_Project_Timesheet.1.cub.xml'.
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="ec9d9ee9-487d-4bcc-90b4-89b8b7d8cd41"
JobUID="c3cad23a-ba51-4ea4-b4e6-d3b887d11f53" ComputerName="LINCOLN"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>"

 

[Shademan]

We are experiencing the same issue. We have a three server scenario: one for
project server/wss, one for sql server, one for analysis services. Any ideas?

 

[Muthukkumaran]

Hi All,

We are also hving same kind of issue whild building the cube.

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to process the Analysis Services database
EPMS_Analysis on the EPMS 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 'Resource Is Active', Name of 'Resource Is Active' with different
granularity attribute than its source object.

Any help would be appriciated.

Thanks,
Muthukkumaran