Cube build error: Cannot join Task Non Timephased...

[PatLac]

Hi,

I am constantly getting this error when I try to build the cube on my
Project 2007 installation. (sorry for the french...)

Type de l'événement : Erreur
Source de l'événement : Office SharePoint Server
Catégorie de l'événement : (1670)
ID de l'événement : 7689
Date : 24/10/2007
Heure : 11:00:28 PM
Utilisateur : N/A
Ordinateur : SPQCMSP01
Description :
PSI Entry Point:
Project User: SPQCMSP01\WSSAdmin
Correlation Id: ac8673bc-7e87-4bdb-ba22-74062a9a32ea
PWA Site URL: http://project.exfo.com/PWA
SSP Name: SSP Prod
PSError: CBSMetadataProcessingFailure (17005), Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=SPQCMSP01
ASDBName=PS_EXFO ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0
NextNum=1 NextUnit=0 FromDate=10/24/2007 14:14:14 ToDate=10/24/2007 14:14:14
HighPriority=False, Invalid call to GetJoinForCustomFieldDimension. Cannot
join "Task Non Timephased" fact with a custom field of entity Assignment.


I tried everything I could think of:
- Removed custom configuration elements from the cube
- Forced the synchronisation of all enterprise custom fields (by changing
their name for example)
- Forced the synchronisation of all my enterprise resources
- Saved and re-published ALL of the projects

The queue seems to be fine (well, as much as can be...) it needs to be
restarded every once in a while.

What else can I try ?? Can I delete everything in the reporting DB ?

Thanks !

Patrice

 

[Mike Mahoney]

Hi,

I am constantly getting this error when I try to build the cube on my
Project 2007 installation. (sorry for the french...)

Type de l'événement : Erreur
Source de l'événement : Office SharePoint Server
Catégorie de l'événement : (1670)
ID de l'événement : 7689
Date : 24/10/2007
Heure : 11:00:28 PM
Utilisateur : N/A
Ordinateur : SPQCMSP01
Description :
PSI Entry Point:
Project User: SPQCMSP01\WSSAdmin
Correlation Id: ac8673bc-7e87-4bdb-ba22-74062a9a32ea
PWA Site URL:http://project.exfo.com/PWA
SSP Name: SSP Prod
PSError: CBSMetadataProcessingFailure (17005), Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=SPQCMSP01
ASDBName=PS_EXFO ASExtraNetAddress= RangeChoice=0 PastNum=1 PastUnit=0
NextNum=1 NextUnit=0 FromDate=10/24/2007 14:14:14 ToDate=10/24/2007 14:14:14
HighPriority=False, Invalid call to GetJoinForCustomFieldDimension. Cannot
join "Task Non Timephased" fact with a custom field of entity Assignment.

I tried everything I could think of:
- Removed custom configuration elements from the cube
- Forced the synchronisation of all enterprise custom fields (by changing
their name for example)
- Forced the synchronisation of all my enterprise resources
- Saved and re-published ALL of the projects

The queue seems to be fine (well, as much as can be...) it needs to be
restarded every once in a while.

What else can I try ?? Can I delete everything in the reporting DB ?

Thanks !

Patrice

Patrice

I suspect you have a corrupt assignment in one of your plans. If you
don't have too many plans try deleting a block of published plans (you
can always republish) then build the cube. If it builds successfully
you know that block contains the problem plan.

regards

Mike

 

[PatLac]

Here is the solution for my problem:

1) Backup all enterprise fields
2) Restore all enterprise fields
3) Build the cube
4) Enjoy !

Isn't it wonderfull !