Month: September 2011

If you have to mirror SQL Project Server database, You will find 2 things among a lot:

• Set-SPProjectWebInstance providing PrimaryDBMirrorServer and ReportingDBMirrorServer
  
• AddFailoverServiceInstance
  

$work=Get-SPServiceApplication | ?{$_.DisplayName -match"Project"} | Get-SPProjectWebInstance 
foreach ($item in $work) 
{ 
Write-Output"doing $($item.url)" 
$mirror=$item.PrimaryServer -replace ("sqlone","sqltwo") 
Set-SPProjectWebInstance -Url ($item.Url).ToString().TrimEnd('/') ` 
-AdminAccount $item.AdminAccount ` 
-PrimaryDbserver $item.PrimaryServer ` 
-ArchiveDbname $item.ArchiveDatabase ` 
-DraftDbname $item.DraftDatabase ` 
-PublishedDbname $item.PublishedDatabase ` 
-ReportingDbServer $item.ReportingServer ` 
-ReportingDbname $item.ReportingDatabase ` 
-PrimaryDBMirrorServer $mirror` 
-ReportingDBMirrorServer $mirror } 

Context:

• Project Server 2010 SP1
• Fail to generate OLAP

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.

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

I am currently working on really interesting project !

This is about providing access to MS Project Server and client in the cloud…Only using https ! Many way to reach the solution:

• You already have MS Project client : connect it to the server directly
• You just want to have a look on the server side: use Internet Explorer
• You want to try the whole without installing anything: connect to our portal to get a remote MS Project Client connected to the server

https://www.pmside.net/try/