Queue Failure - "User Synchronization for Project Web Access App Root Site and Project WSS Workspace"
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