One of my customer contacted me and stated that Project server stopped responding and resources were experiencing
extremely slow response. When the resource opens Project / resource center, it
takes enormous amount of time to load the data.
When I started digging, observed that the issue
started after they performed a small tweak in the Project Server permission
settings. I.e. Since stake holders wanted everybody in the system should be
able to access all the Project sites in the PWA instance, modified the security
settings to meet the business goal.
Since then on every project publish, project application service started
consuming most of the CPU and memory from the server and stopped responding to
the resource queries.
To meet the goal, scheduled a PowerShell script in the task scheduler to
add the required resources into the Project Sites
Issue
Description:
Project server responds slowly when the following jobs
are stuck in Queue.
“Prepare
Project Web App Permission Synchronization”
“Prepare Project Web App Permission Synchronization for
Projects”
Workaround:
Action 1: Open
Project Web App, Server Settings and Manage User Sync Settings
Disable the following settings
Enable
Project Web App Sync
Enable
Project Site Sync
Action 2: Add
a task in the Task scheduler and schedule the action as below.
Program/Script: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
Add arguments:
c:\path\addperm.ps1
Add
the following content and create the PS1 file in the above path.
Sample PowerShell Script: (modify based on your requirements)
add-pssnapin
microsoft.sharepoint.powershell
Write-host
"adding Authenticated Users to"
foreach
( $web in $site.allwebs )
{
if ( $web.HasUniquePerm )
{
Write-host `t`t`t $web.url
New-SPUser -UserAlias "NT
AUTHORITY\Authenticated Users" -Web $web.url -PermissionLevel
Contribute | Out-Null
}
}
More Info:
Register to get free online tour:
Contact us: