OLAP Cube Build fails

T

TheWall

Hi,

Our OLAP cubes are failing to build.

Error:
Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to delete the Olap database: DBName. Error: Query
timeout expired

Please help!
 
T

TheWall

When it fails i get a email with the following msg:

The errors returned from the queue are as follows:

Your CBSRequest job failed. Its current state is FailedNotBlocking. It was
0% complete. It entered the queue at 05/14/2009 13:32:04.

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: 17007
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="17007" name="CBSOlapDatabaseSetupFailure"
uid="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" QueueMessageBody="Setting
UID=0xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxASServerName=Server.domain.local
ASDBName=DB_II ASExtraNetAddress=Server.domain.local RangeChoice=0 PastNum=1
PastUnit=0 NextNum=1 NextUnit=0 FromDate=05/14/2009 10:43:39
ToDate=05/14/2009 10:43:39 HighPriority=True" Error="Analysis Services
session failed with the following error: Failed to delete the Olap database:
DB_II. Error: Query timeout expired" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="xxxxxxxx-4cf9-414e-b67a-9848d0cfc08e"
JobUID="xxxxxxxx-c0a3-4bfd-9235-ec26755f2d18" ComputerName="Computer"
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
(xxxxxxxx-c0a3-4bfd-9235-ec26755f2d18) and error XML.

To turn off these notifications, go to Project Web Access, click Personal
Settings on the left menu, and then click Manage My Alerts and Reminders.

From this page, you can clear the check box for those notifications you no
longer want to receive.

EPO (Microsoft Office Project Server)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top