4us2use Blog

Problem Description:

Error: “Timeout Expired. The timeout period elapsed prior to completion of the operation or the
server is not responding.​”

This can be caused due too many rows in the SharePoint_Config DB in table dbo.TimerJobHistory

You can check on SQL with the following code:

SELECT CONVERT(bigint, rows)
FROM sysindexes
WHERE id = OBJECT_ID(‘dbo.TimerJobHistory’)
AND indid < 2

The root problem is a general SP 2013 “beature”.
The job “Delete Job History” is scheduled weekly but has a timeout. That causes, that ususally a lower number of entries is purged after a week than new entries created during the week on a large farm.

Resolution:

​Set the job schedule to 1 minute until you reached a lower and stable number of rows.
After that change the job to run daily.

(No Ratings Yet)
Loading...

Problem Description:

if you need to remove all permissions and broken inheritances from a complete site collection, you may run this script​

Resolution:

Add-PSSnapin Microsoft.SharePoint.PowerShell
$site = Get-SPSite https://URL
$webs = $site.AllWebs
foreach ($web in $webs){
if ( ($web.HasUniqueRoleAssignments) -and ($web.IsRootWeb -eq $false ) ){
$web.ResetRoleInheritance()}
Write-Host “Removed broken inheritance on web: ” $web.Url -ForegroundColor Red
}

$lists=$web.Lists
foreach ($list in $lists){
if (($list -ne $null) -and ($list.HasUniqueRoleAssignments)){
$list.ResetRoleInheritance()
Write-Host “Removed broken inheritance on list: ” $list.Title -ForegroundColor Blue
Clear-Variable list
}

Write-Host “Entering list to remove single item permission: ” $list.Title
$items = $list.items | Where {$_.HasUniqueRoleAssignments}
foreach ($item in $items){
$item.ResetRoleInheritance()
Write-Host “Removed broken inheritance on item: ” $item.Name -ForegroundColor Green
Clear-Variable item
}}
$web.Dispose()
}

Remove all permissions
$groups = $web.SiteGroups
for ($i=0;$i -le $groups.Count;$i++){
$web.SiteGroups.Remove($groups[$i])
}
$users = Get-SPUser -Web $web -Limit all
for ($i=0;$i -le $users.Count;$i++){
Remove-SPUser -Web $web -Identity $users[$i] -Confirm:$false
}

(No Ratings Yet)
Loading...

Problem Description:

SharePoint Designer Workflows in version 2013 couldn’t be terminated on the GUI because they were in an undefined state​

Resolution:

​$web=get-spweb https://URL
$list=$web.lists[“ListName”]
$wfm=New-Object Microsoft.SharePoint.WorkflowServices.WorkflowServicesManager($list.ParenWeb)
$wfm.GetWorkflowInstanceService()
$wfs=$wfi.EnumerateInstancesForListItem($list.ID,”$itemID”)
$wfi.TerminateWorkflow($wfs[0])

(No Ratings Yet)
Loading...