#Requires -Version 5.1
<#
    JbTecWiz Support Centre -- generated fix script

    Fault : OneDrive stuck on "Processing changes" or not syncing
    Fix   : Find the file that is holding the queue
    Source: https://jbtecwiz.com/support/win-app-onedrive-stuck

    Run as     : PowerShell as the affected user
    Expect     : 25 minutes
    Risk       : low
    Reversible : yes

    WHEN THIS IS THE RIGHT FIX
    It is stuck rather than disconnected. One file blocks everything behind
    it.

    HOW TO UNDO IT
    Renamed files can be renamed back; nothing was deleted unless you chose
    to.

    This script walks the fix one step at a time and asks before each
    one. Steps with no command are things you do yourself -- it prints
    those and waits. Run with -DryRun to print without executing.

    --------------------------------------------------------------------
    NO WARRANTY - USE AT YOUR OWN RISK

    This script is provided by JbTecWiz as-is and with no warranty of any
    kind, express or implied. You run it entirely at your own risk.

    JbTecWiz accepts no liability for any loss or damage arising from its
    use, including but not limited to data loss, downtime, or configuration
    changes that turn out to be wrong for your system.

    You are responsible for reading this script before running it, for
    satisfying yourself that it suits the machine in front of you, and for
    having a working backup first. Some steps cannot be undone.
    --------------------------------------------------------------------
#>

[CmdletBinding()]
param(
    # Print every step and command without running anything.
    [switch]$DryRun,
    # Do not ask before each step. Read the script first if you use this.
    [switch]$Unattended
)

$ErrorActionPreference = 'Stop'
$script:Failed = 0

function Write-Rule { param([string]$Text)
    Write-Host ''
    Write-Host ('-' * 70) -ForegroundColor DarkGray
    if ($Text) { Write-Host $Text -ForegroundColor Cyan }
}

function Show-Prose { param([string]$Text, [string]$Colour = "Gray")
    if (-not $Text) { return }
    $words = $Text -split "\s+"; $line = "  "
    foreach ($w in $words) {
        if (($line.Length + $w.Length) -gt 74) { Write-Host $line -ForegroundColor $Colour; $line = "  " }
        $line += "$w "
    }
    if ($line.Trim()) { Write-Host $line -ForegroundColor $Colour }
}

function Invoke-Step {
    param(
        [int]$Number, [string]$Do, [string]$Why,
        [scriptblock]$Command, [switch]$Manual, [string]$Shell = "powershell"
    )
    Write-Rule "  Step $Number of 4"
    Show-Prose $Do "White"
    if ($Why) { Write-Host ""; Show-Prose $Why "DarkGray" }

    if ($Manual) {
        Write-Host ''
        Write-Host '  -> Do this yourself, then press Enter to carry on.' -ForegroundColor Yellow
        if (-not $Unattended -and -not $DryRun) { [void](Read-Host) }
        return
    }

    Write-Host ''
    foreach ($l in ($Command.ToString().Trim() -split "`n")) {
        Write-Host ("    " + $l.Trim()) -ForegroundColor Green
    }
    Write-Host ''

    if ($DryRun) { Write-Host "  (dry run -- not executed)" -ForegroundColor DarkGray; return }
    if (-not $Unattended) {
        $a = Read-Host "  Run this step? [Y]es / [S]kip / [Q]uit"
        if ($a -match "^[Qq]") { Write-Host "  Stopped at your request."; exit 0 }
        if ($a -match "^[Ss]") { Write-Host "  Skipped." -ForegroundColor DarkGray; return }
    }
    try { & $Command }
    catch {
        $script:Failed++
        Write-Host ("  Step $Number failed: " + $_.Exception.Message) -ForegroundColor Red
        Show-Prose "The rest of the fix may depend on this. Read the write-up before carrying on." "Red"
        if (-not $Unattended) {
            $c = Read-Host "  Carry on anyway? [y/N]"
            if ($c -notmatch "^[Yy]") { exit 1 }
        }
    }
}

Write-Rule
Write-Host '  OneDrive stuck on "Processing changes" or not syncing' -ForegroundColor White
Write-Host '  Find the file that is holding the queue' -ForegroundColor Cyan
Write-Host ''
Write-Host '  Risk: low   Reversible   25 minutes'
Write-Host ''
Show-Prose 'No warranty. Use at your own risk - JbTecWiz accepts no liability. Read it before you run it, and have a backup.' 'DarkYellow'
Write-Rule

if (-not $Unattended -and -not $DryRun) {
    $go = Read-Host '  Ready? [y/N]'
    if ($go -notmatch "^[Yy]") { Write-Host "  Nothing was changed."; exit 0 }
}

Invoke-Step -Number 1 -Do 'Look for paths that exceed the limit. This is the most common single cause and it is invisible in Explorer.' -Why 'OneDrive syncs a path that includes the SharePoint site prefix, so a path that is legal locally can be over the limit once uploaded. Shortening a folder name high in the tree usually fixes dozens at once.' -Command {
    Get-ChildItem "$env:OneDrive" -Recurse -Force -ErrorAction SilentlyContinue |
      Where-Object { $_.FullName.Length -gt 240 } |
      Select-Object -First 20 @{n='Len';e={$_.FullName.Length}},FullName
}

Invoke-Step -Number 2 -Do 'Look for characters that cannot be used in a SharePoint path.' -Command {
    Get-ChildItem "$env:OneDrive" -Recurse -Force -ErrorAction SilentlyContinue |
      Where-Object { $_.Name -match '["*:<>?/\\|]' -or $_.Name -match '^\s|\s$|\.$' } |
      Select-Object -First 20 FullName
}

Invoke-Step -Number 3 -Do 'Look for files still open in an application -- Office files with a ~$ prefix are lock files left behind by a crash.' -Command {
    Get-ChildItem "$env:OneDrive" -Recurse -Force -Filter '~$*' -ErrorAction SilentlyContinue | Select-Object FullName,LastWriteTime
}

Invoke-Step -Number 4 -Do 'Rename or remove what you find, then pause and resume sync from the OneDrive menu.' -Manual

Write-Rule "  Confirm it worked"
Show-Prose 'The icon settles to a green tick and the file count stops changing.' 'White'

Write-Rule
if ($script:Failed -gt 0) {
    Write-Host ("  Finished with " + $script:Failed + " failed step(s).") -ForegroundColor Yellow
    Show-Prose 'Read the full write-up at https://jbtecwiz.com/support/win-app-onedrive-stuck' 'Yellow'
} else {
    Write-Host '  Finished.' -ForegroundColor Green
}
Write-Host ''
Show-Prose 'To undo: Renamed files can be renamed back; nothing was deleted unless you chose to.' 'DarkGray'
Write-Rule