cube build error

[Eric_H]

Hello all... We are unable to build cubes and we could in the past (MS
Project Server 2007 SP2). I am getting this error and have tried forcing a
rebuild of the reporting DB (backup/restore of custom fields) and this has
not fixed the issue, the error reads:

Invalid call to GetJoinForCustomFieldDimension. Cannot
join "Task Non Timephased" fact with a custom field of entity Assignment

Any suggestions? we also have an error on our error logs that says:

"Node Consistancy Error: Failed to load Calendar" what is this and are they
associated with each other???Any help would be appreciated...

 

[Gary Chefetz]

Eric:

On cause might be corruption in the reporting database. Let's eliminate that
possibility by forcing a rebuild of the reporting database following these
instructions:

http://www.projectserverexperts.com...erebuildofprojectserverreportingdatabase.aspx

 

[Eric_H]

Thanks Gary!!!
Done that, didn't fix it... the issue was a bad field trapped in the cube
configuration, found the field and fixed it the cube builds ok now. Still
seeing the Node Consistancy error... I am assuming that is NOT related to the
cube issue since the cube works ok... I want to run down the Node consistancy
error so I don't have other issues later and so I am not adding to my log
files unnecessarily. Help me knock that one down?

 

[Gary Chefetz]

Eric:

Another therapy that sometimes helps is to clear all your custom fields from
the cube configuration, then run the cube build. If you don't see any
errors, then add the fields back to the cube configuration. If the error
reappears, you can start to narrow it down from there.

 

[Eric_H]

Cube build is working ok now, still have the node consistancy error... What
could this be?