question

SteenJensen-8656 avatar image
0 Votes"
SteenJensen-8656 asked RitaHu-MSFT commented

WSUS(Windows Server 2019) - Cleanup - fails every time 'Unused updates and update revisions' is selected.

I'm experiencing the above - a classic. I once managed to download a SQL script that actually solved the problem. For some reason there was fields with negative values like '-1' in some table that the WSUS server cleanup wizard couldn't handle.

I simply cannot remember where I got it from last time :-)

Is there someone in here who could provide that script or a link?

Thanks in advance.

windows-server-update-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RitaHu-MSFT avatar image
0 Votes"
RitaHu-MSFT answered

anonymous userJensen-8656
Thanks for your posting on Q&A.

Here is a related link for your reference. Please follow the link to maintenance the WSUS server first.

Hope the above will be helpful.

Thanks for your time and wish you have a nice day :)

Regards,
Rita


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SteenJensen-8656 avatar image
0 Votes"
SteenJensen-8656 answered SteenJensen-8656 commented

Hi Rita :-)

Thanks for your quick reply.

I'd been through this guide allready without any success. Again what I neeed is this particular SQL that can clean up the way I mentioned.

It's a commonly known/experienced issue I believe. Except that I'm not able to findt that SQL anymore.


Best Regards
Steen Jensen

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

What is your database? WID or SQL Server?

How many metadata updates on the WSUS console? Have you ticked the useless products and classifications and synced the unnecessary updates?

Have you tried the below PowerShell Script?
95472-7.png


0 Votes 0 ·
7.png (41.6 KiB)

Hi Rita,

I'm not aware what You're asking in regards to Metadata, However I am using a standalone WSUS server. I've tried the Powershell script you re referring to as well.
It runs for a while and then it stops with a very long error message.

I even shrinked the database as well as I have done a re-indexing and of course a DBCC CHECKDB on the SUSDB. No changes at all.

That's why I remember the situation I was in a couple of Years ago where I found a SQL script that could remove fields with negative values as I wrote initially. I believe the situation is the same now. Only thing is that I'm not able to recapture it.

Best Regards
Steen Jensen


0 Votes 0 ·
AJTek-Adam-J-Marshall avatar image
1 Vote"
AJTek-Adam-J-Marshall answered

What maintenance are you currently performing? Server Cleanup Wizard (SCW), declining superseded updates, running the SQL Indexing script, etc.?

https://www.ajtek.ca/wsus/how-to-setup-manage-and-maintain-wsus-part-8-wsus-server-maintenance/

There's not one 'script' that will fix it all as each part of the maintenance requires something different.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SteenJensen-8656 avatar image
0 Votes"
SteenJensen-8656 answered RitaHu-MSFT commented

Hi Adam,

Thanks for your reply. I'm doing the SCW first step. Rest of them works just fine. Please look my last correspondance with Rita.


Best Regards,
Steen Jensen

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

anonymous userJensen-8656
It seems there is no update for a couple of days. As you maintained above, you would like to try to follow the Adam's suggestions first. Is there any updates of the status of the case?

May we know the current status of the problem? Is there any other assistance we can provide?

0 Votes 0 ·