Cube failed to build due to 'Assignment Timephased'

[Sanny]

Hi everyone,

The Cube build failed and gave us the following 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="ba9da4e1-8675-4455-a980-be4adebc278b" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=nlsqlcl1v02:2383
ASDBName=EPM2007 ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0
NextNum=1 NextUnit=0 FromDate=02/06/2009 11:56:08 ToDate=02/06/2009 11:56:08
HighPriority=True" Error="Analysis Services session failed with the following
error: Failed to process the Analysis Services database EPM2007 on the
nlsqlcl1v02:2383 server. Error: OLE DB error: OLE DB or ODBC error:
Unspecified error
Errors in the OLAP storage engine: An error occurred while
processing the 'Assignment Timephased' partition of the 'Assignment
Timephased' measure group for the 'Assignment Timephased' cube from the
EPM2007 database
Internal error: The operation terminated
unsuccessfully
Internal error: The operation terminated unsuccessfully
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="5b5c017e-9d25-4eb1-b0d3-e4f67c99e069"
JobUID="7c83a0d7-2bd1-4453-89d1-0993e1594533" ComputerName="NLEPM01"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

It also looks as if EPM times out after trying to build the cue for 1 hour.
We use the 2007 version. Can anyone help me how to fix this?

Sanny Naber

 

[Dale Howard [MVP]]

Sanny --

This is just a "shot in the dark" but do you have an MDX formula in the
Assignment Timephased cube? If so, an improperly written formula can break
the OLAP cube process. Hope this helps.