Cube Build Failure

[David F-H]

Project Server 2007 (SP1 + IU + Aug cum hotfixes) & SQL Server 2005

Our Cube build job has been failing for the last few days with the error
message below. Prior to that it failed with a "There is not enough space on
the disk" message (but previously was building successfully every day). Last
night I freed up LOTS of space (just in case this was still the root cause),
but it continues to fail with the below message.

Can someone please help?

-----------------------------------------------------------------------------------------------------------------
Your CBSRequest job failed. Its current state is FailedNotBlocking. It was
0% complete. It entered the queue at 01/29/2009 05: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="0b6d331e-af92-4058-b45e-4e6b86c287ab" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=sgapsys022
ASDBName=ProjectServer_Analysis ASExtraNetAddress= RangeChoice=2 PastNum=1
PastUnit=0 NextNum=1 NextUnit=0 FromDate=12/21/2008 00:00:00
ToDate=12/19/2009 00:00:00 HighPriority=False" Error="Analysis Services
session failed with the following error: Failed to process the Analysis
Services database ProjectServer_Analysis on the sgapsys022 server. Error: XML
parsing failed at line 1, column 19592: '>' expected

 

[Marc Soester [MVP]]

Hi David,

I believe that is an issue with the temp DB while building your cube. there
is currently an issue that in some instances it is required to free about
30GB ( I experienced 60GB in the past ) for the Temp db. If you give your
temp DB about 30 DB and try to build the cube again, let me know if this
fixed the issue.

PS: there are several hotfixes and IU that should have fixed this issue. My
experience........it hasnt I am sure SP2 will finally resolve this jucky
issue, having said this, I believe this is also a SQL issue.
hope this helps

 

[Gary L. Chefetz]

Marc:

Good point on the SQL side. We've been able to resolve other issues for
customers by applying SP3 for SQL 2005.

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

 

[David F-H]

I increased the tempdb to 30GB, but it failed with the same error.

So the next thing to try would be applying SP3 to SQL 2005 ? (I believe we
are on SP2 currently)

 

[Marc Soester [MVP]]

Thanks Gary for the tip, I havent tried SP3 to resolve the issue. Makes a lot
of sense !!
David, I think it is worth trying out SP3 . Make sure that any other
software you are running on the SQL box is "happy" with SP3

 

[Gary L. Chefetz]

Marc:

One problem it resolves is the issue with rendering project detail views in
systems with many task-level custom fields, which was fixed in SQL CU10. I
think it may resolve the OLAP cube build taking hours and hours because of
bad execution plans.

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