Cube Build Error

[ziwez0]

getting the follwoing messages from project server,
cube build status:
===== Initiating cube build process =====
[06/08/2009 09:54] Cube build request message has been added to the
Project Server queue
===== Verifying and running pre-build server event handler =====
[06/08/2009 09:54] Verifying and running pre-build server event
handler
===== Determining database and cube structure =====
[06/08/2009 09:54] Cube build initialization started
[06/08/2009 09:54] OLAP database and cube structure was determined
successfully
[06/08/2009 09:54] Failed to create the internal OLAP database
structure. Error: Invalid call to GetJoinForCustomFieldDimension.
Cannot join "Task Non Timephased" fact with a custom field of entity
Assignment
===== Process Completed =====
[06/08/2009 09:54] Failed to build the OLAP cubes. Error: Invalid call
to GetJoinForCustomFieldDimension. Cannot join "Task Non Timephased"
fact with a custom field of entity Assignment

any ideas>

 

[ziwez0]

Solved this, right pain!

The reason why I was getting it was because I did a Administrative
Backup on CustomFields, then restored (the reason I did this was
becasue my Reporting database was not capturing all the data).
This has then messed up the cube building.
I finally found this article
http://blogs.msdn.com/brismith/arch...analysis-timeouts-plan-guides-and-tempdb.aspx

then if you open the MSP_EpmAssignment_OlapView and look for custom
filed entries, go into you cube configuration remove all custom fields
(if any in there) form the assignment and build your cube then re-add
them and build
and all should work.