Project Server 2010 SP1: OLAP generation fails

Context:

  • Project Server 2010 SP1
  • Fail to generate OLAP
Problem:
Cube generation doesn’t work anymore.
Cause:
Eventlog
Source:Project Server   Event ID:7704
Error PS : GeneralQueueJobFailed (26000)

A queue job has failed. This is a general error logged by the Project Server Queue everytime a job fails – for effective troubleshooting use this error message with other more specific error messages (if any), the Operations guide (which documents more details about queued jobs) and the trace log (which could provide more detailed context). More information about the failed job follows. GUID of the failed job: . Name of the computer that processed this job: MyServer (to debug further, you need to look at the trace log from this computer). Failed job type: CBSRequest. Failed sub-job type: CBSQueueMessage. Failed sub-job ID: 2. Stage where sub-job failed: (this is useful when one sub-job has more than one logical processing stages).

SharePoint logs (ULS):

ConvertWindowsClaimToWindowsPrincipalName() encountered error: Some or all identity references could not be translated.

 

Workaround:

Some of the users have been removed from AD but are still active in Project.
This is automatically handed if:

  • “user profile Synchronization” works,
  • Project group are synced with windows groups
  • sync has occured since deletion.
These errors only occurs when you are in claim mode and SP1.
To solve it, you must remove deleted users from project group.
Here is a powershell script to find out the guilties:
import-module"ActiveDirectory" 
$pwaUrl="http://mysite/pwa" 
$svcProjectUrl=$pwaUrl+"/_vti_bin/PSI/Resource.asmx?wsdl" 
$c=Get-Credential 
$svcProjectProxy=New-WebServiceProxy -uri $svcProjectUrl -credential $c 
$users=$svcProjectProxy.ReadUserList("Active").Resources 
foreach ($u in $users) 
{ 
$temp= [regex]::Replace($u.WRES_ACCOUNT, "^.*\", ""); 
if ((get-aduser $temp) -eq $false{ "missing ad user "+($u.RES_NAME) } } 

Leave a Comment