Project Server technical bits

Event You see a queue failure - "User Synchronization for Project Web Access App Root Site and Project WSS Workspace" You may see a ULS entry that looks something like this:- 10/06/2008 17:11:37.16 Microsoft.Office.Project.Server (0x07D8) 0x0CF0 Windows SharePoint Services Database 6f8g Unexpected Unexpected query execution failure, error code 1205. Additional error information from SQL Server is included below. "Transaction (Process ID 98) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction." Query text (if available): "{?=call proc_SecAddPrincipalToRole(?,?,?,?,?,?)}" What this means Some element of PWA or Project Workspace permissions synchronisation has partially or completely failed due to a deadlock. Users may not be able to access the PWA site and/or WSS Workspaces associated to Project files Triggers The User Synchronisation of Project Workspaces and PWA

Details on Office Servers 2007 SP2 including Project Server and April Cumulative Update Hotfix Release - SP2 includes SP, IU and all patches thru to and including FEB 09 Cumulative Update - April CU then includes specific fixes between Feb CU and now - therefore you need both. So how do i get a fully patched system:- - Install WSS3.0 SP2 - Install Office Servers 2007 SP2 - Install WSS3.0 April CU package - Install MOSS Uber Package - Or - Project Server 2007 April 2009 CU package clients:- - Install Project 2007 SP2 then April 2009 CU package create one slipstream package for all the installations / patches required and do that (including all SP2 and April CU packages) Note on Portfolio Server 2007 SP2 - this is not in the same release cycle - no news on release date yet but it is coming...

Office Project Server 2007 Sp2 has now been released.  see the details here - http://blogs.msdn.com/chrisfie/archive/2009/04/28/announcing-service-pack-2-sp2-for-microsoft-project-2007-and-microsoft-project-server-2007.aspx .  see teh webcast here http://blogs.msdn.com/brismith/archive/2009/04/28/project-server-2007-service-pack-2-sp2-is-now-available.aspx Blogged with the Flock Browser