Skip to content

History / SQL Upgrade Troubleshooting

Revisions

  • Bring the wiki up to Stable 1859 Stable 1859 (main 3d1ca6d4, release PR #833) ships everything cc02376 documented as Unreleased, so each passage now reads "Since Stable 1859" with its PR (#805-#808, #810, #812-#818, #820, #821), and "released builds" / "the next release" become "builds before 1859" / "1859". Verified against origin/main. Also documents what 1859 adds beyond those passages: - #825/#835: config schema 3.6.0, StringCipher v2 secrets that installers from 1857 and earlier can't read, the <name>.v1-backup.json rollback copy and its weaker-encryption warning, the wrong-password prompt (Installer Configuration Workspace, Security Model, Updating the solution, Configuration Reference, SQL Upgrade Troubleshooting). - #828: Kudu with the installer's Entra token and Microsoft.Web/sites/publish/Action; runtime data roles on each resource, old resource-group grants kept and warned; PATCH updates; TLS only raised; configured plan name (Prerequisites, Deployment Guidance, Runtime Permissions, Security Model, Known Issues). - #825: CSRF X-Requested-With requirement and 403; report error references; credit-history token cache encrypted, reconnect after rotating the runtime secret or certificate. - #808: Known Issues row and troubleshooting entry for the root-web AITracker registration lost on site collections with sub-webs. - #815/#817: script links point at the 1859 release assets (Clean.Data.By.User.StoredProc.sql, Repair.Page.Load.Times.sql). - Release Notes callout and the 1859 row in Updating the solution. Full-wiki link and anchor check: 0 broken of 2,288. No BOMs. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: e85d2291-9456-466c-9776-278a1d9f6f3e

    @sambetts sambetts committed Nov 5, 2026
  • Document unreleased dev changes (#805-#821) as Unreleased passages Mark each passage Unreleased with a link to its PR, verified against origin/dev, and describe the released 1857 behaviour it replaces: - #821: "Add a second app" becomes "Add another app" at no more than half the breadth target; the league table's own candidate counts; past-range agent figures read for the range, or blank with a warning. - #816: weekly active users across every day, with incomplete weeks; Teams Explorer dormancy from Teams-licensed users over a fully imported window. - #808: Hybrid Worker left alone when healthy, manual repair steps when the installer runs on that VM or can't tell; a failing SharePoint site ends the run "Completed with N error(s)", not FATAL. - #820: Licence activity's weekly D7 Copilot readings, D28 fallback on working days, equal service weights; 90/180-day presets stay partial. - #815: the purge's new deletions, "not removed" list and acknowledgement; re-run CleanDataByUser's CREATE OR ALTER after upgrading. - #817: page load times fixed; new section on running "Repair Page Load Times.sql" once after upgrading. - #814: Install log without secrets; new SQL upgrade troubleshooting entry for the older-downloaded-release refusal. - #812: malformed group page makes the scope unavailable (purge refused), leadership cohort Failed, Azure cost scope failed for the cycle. - #805/#806/#818: small-group withholding where pages lacked it. - #813: Telemetry Service upload limits, annotations container, setting. - #810: AITracker 1.6.4 collects nothing on untracked site collections. Full-wiki link and anchor check: 0 broken. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: e85d2291-9456-466c-9776-278a1d9f6f3e

    @sambetts sambetts committed Nov 4, 2026
  • Split Troubleshooting into a symptom hub and four topic pages Troubleshooting was 665 lines mixing four audiences (D5-9, per X6). It is now a hub plus topic pages, each opening with who it is for: - Troubleshooting (hub): a symptom -> page index, the checks that apply to every import (finished events, problem logs, no logging, audit log data missing, enabling/disabling imports, network restrictions, Power BI). - Teams and Calls Troubleshooting: Teams crawl, deep-analytics tokens, missing calls, retries and dead-letters, webhook authentication. - Usage Reports and Email Troubleshooting: concealed identities, placeholder cleanup (sizing detail folded away, D5-24), SharePoint weekly report, sent emails, Graph pages without a value collection. - Web Tracking Troubleshooting: the App Insights importer, installer SharePoint sign-in, page properties (dangling screenshot lead-in replaced with the /items(<id>)/properties request, checked in SpoPagePropertyManager). - Web Portal Troubleshooting: portal messages, and the optional-feature symptoms table moved from User Import Troubleshooting (D5-33). Release banners and PR links are gone from the topic pages; "builds before 1856" behaviour moved to a new Fixed issues table on Known Issues, which is now split into open issues and fixed history (D5-15). Headings there are unchanged, so every existing anchor still resolves. Accuracy, checked against tags 1856/1857 (identical to dev for these files): - Calls webhook: since 1856 the subscription is kept on its own 30-minute timer from WebJob start, not per cycle; after a secret rotation the webhook keeps accepting the previous secret's clientState from the recorded subscription for up to 24 h (needs Storage), so calls are not refused. Corrected the rotation reason line, the Created-subscription line and the certificate-only line; Configuration Reference and Known Issues no longer say "next cycle". - Prompt insights shows with the audit or interaction-history import on (reportNavigation.ts); the old "Copilot Reports tab" row is updated. Links: all 38 old Troubleshooting anchors are kept on the hub as a "Moved sections" list of <a id> pointers; all 33 inbound links to moved anchors (18 pages) now point at the new page and anchor, and the CSP page links to Web Tracking Troubleshooting. Sidebar troubleshooting section, guide footers and the DLQ page breadcrumb (duplicate H1 removed) updated. No code-repo or release-note target changes: they link only to Troubleshooting, Known Issues, User Import Troubleshooting and the DLQ page, all kept. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: e85d2291-9456-466c-9776-278a1d9f6f3e

    @sambetts sambetts committed Nov 4, 2026
  • Make the upgrade and schema pages accurate for multi-release and manual upgrades - Updating the solution: add "Upgrading across several releases" (one installer run applies every pending migration; the admin actions of each skipped release, 1846-1857), the full manual-script chain 1846-1857 with each script's predecessor (checked against Migrations/*.manual.sql and the release assets), a "Verify the upgrade" pass/fail table, and "Backing up and restoring" (SQL, the AnalyticsState table, Key Vault, the saved installer configuration). Name the real Release & packages and Review & deploy options. Add release numbers, the 1833/1835 index builds and 1835's destructive table drop to the maintenance-window table. - SQL Upgrade Troubleshooting: fill in "Forcing schema updates" (File > Upgrade Database Schema, which also refreshes the SQL extensions after the .manual.sql scripts); current installer labels; AnalyticsEntitiesContext; a "database is behind this build" entry with the portal and Health texts. - Audit Events FK runbook: check the FK and index by column, not by name, so databases with the Create DB.sql names don't look failed; WebJob names. - URL shrink and Audit FK guides: say which builds they apply to; note that 1830's UniqueUrlsFullUrlIndex deletes duplicate URL rows. - Schema reference: add the copilot_cost_*, user_org_* and copilot_adoption_reclaim_exclusions tables and users.created_utc; the 25-day usage-report look-back; the dropped credit columns and Azure cost tag columns; release numbers; the other stores that hold tenant data. - Release Notes: complete 1857 PR list; GitHub keeps published stable releases from 1427; build 1604. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: e85d2291-9456-466c-9776-278a1d9f6f3e

    @sambetts sambetts committed Nov 4, 2026
  • Refresh wiki guides and screenshots for stable build 1854 Replace 49 product screenshots with current UI captures using fictional data. Split oversized guides into focused pages and refresh installation, upgrade, administration and report guidance with linked navigation. Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com> Copilot-Session: 75875569-ebac-4a0a-a963-7048d34147ad

    @sambetts sambetts committed Oct 22, 2026