WSUS Cleanup Wizard Error

Hi I tried to run the WSUS cleanup Wizard and it gave me this error. I have no idea how to solve this. Have googled with not much luck.wsus.jpg
LVL 1
Snowbella KilangitAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ganesh Kumar ASr Infrastructure SpecialistCommented:
This issue is most likely occuring as a result of the "Delete unneeded updates" step, and not while trying to delete old computer entries. Typically it occurs on long-standing systems where the SCW has not been previously used, or on systems with large database sizes with higher-than-optimal disk defragmentation issues.

Please do the following:

Run the Server Cleanup Wizard with only the option Delete computers selected. By removing dead computers from the database, it significantly reduces the work required by the update scans because approval state and installation status no longer need to be checked for those systems.
Decline ALL superseded updates reported as 100% Not Applicable.
Run the Server Cleanup Wizard with the Decline expired updates and Decline superseded updates options selected. This task only changes data in the database and is rarely impacted by fragmentation issues. It will pick up any eligible stragglers that  you may have missed in Step 2.
Run the Server Cleanup Wizard with the Delete unused files option selected. While deleting unused files will not help with the database issues while deleting updates, it will help with the disk defragmentation you will be doing in the next steps.
Stop the database service. Most likely this is the Windows Internal Database service.
Defragment the volume containing the SUSDB.MDF file. If you chose the installation defaults, this file is contained in C:\WSUS\UpdateServicesDBFiles. Most likely defragmentation will also require you to reboot the server, unless the \WSUS folder is on a different volume.
Restart the database service (unless you had to reboot to defragment drive C:, in which case the database service should already be running).
Obtain the WSUS Database Maintenance script described in the section Reindex the WSUS Database found in the WSUS Operations Guide. Run the script.
Run the Server Cleanup Wizard with the Delete unneeded updates option. This task should now complete with a defragmented and reindexed database.
Repeat steps  4 through 8 a second time to ensure optimal performance of the database after removal of these unneeded updates.
Continue to use the Server Cleanup Wizard monthly, in combination with removals of approvals from unneeded superseded updates to maintain optimal performance of your WSUS server.
Snowbella KilangitAuthor Commented:
Hi Ganesh,
I am running WSUS on a VM...I attempted the first step with only 1 option to delete computers but it returned the same error.

After that I checked C drive and it shows that 0 bytes free of 179 GB

Also there is c:\wsusdb\UpdateServicesPackages   (this is empty)
and c:\wsusdb\WsusContent (this has a few folders that have cabinet files and applications
Ganesh Kumar ASr Infrastructure SpecialistCommented:
From the All Updates view, filter on Approval=Approved and Status=Installed/NotApplicable. Enable the Superseded column and the Installed/NotApplicable Percentage column. Sort on the Superseded column, focusing on updates with the blue icon at the bottom and in the middle. Select those updates with Installed/NotApplicable Percentage = 100% that are superseded. Decline them. Performed monthly this exercise should take no more than 10 minutes.
Run the Server Cleanup Wizard.
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Snowbella KilangitAuthor Commented:
From the "All Updates" view...I did as advised...it did a refresh and came up with the same error
Ganesh Kumar ASr Infrastructure SpecialistCommented:
Have you restarted once that may clean up some locked portion of files on the memory.
Snowbella KilangitAuthor Commented:
I have restarted but still cannot run the wizard, the error is still there. Maybe time to rebuild the WSUS VM?
Ganesh Kumar ASr Infrastructure SpecialistCommented:
I did the same when i had issue, i could cleanup but it didn't help. The machine was very slow than expected even when it had enough power and memory. I rebuilded it then all came fine. Try reinstalling WSUS and check instead building another server.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.