- Context
I’ve a WSUS server in Core mode and there’s only a PowerShell console to manage it.
- Problem
When I get a synchronisation that failed, I’ve got the following where…
..the error text is empty. 😦 You only know that it failed.
- Solution
You can get the UpdateId using this command:
(Get-WsusServer).GetSubscription().GetLastSynchronizationInfo().UpdateErrors.UpdateId
You can get the ErrorText like this:
(Get-WsusServer).GetSubscription().GetLastSynchronizationInfo().UpdateErrors.ErrorText
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column ‘RevisionID’, table ‘@AtLeastOneBundle’; column does not allow nulls. INSERT fails.
Error loading information from upd:BundledUpdates/upd:AtLeastOne/upd:UpdateIdentity for updateEA512030-9E26-42FD-B83C-84ED5F9C2364\200. Some update revisions in bundle information are not already present in the database.
The statement has been terminated.
In the above case, running a new synchronisation solved the issue.
the question is : where is the next major update for WSUS services ? (a long time ago …. WSUS v3)
I’ve noticed (in the shell screen shot) that you use Administrator builtin account. Shame on you guy, it’s a bad practice :-). You should use a dedicated and nominative admin account.
Indeed, shame on me. It’s a standalone server.
Do you have any reference about the bad practice?
Pingback: Dew Drop – August 9, 2023 (#4000) – Morning Dew by Alvin Ashcraft