WSUS API console keeps crashing

Question

question

EavenHuang asked Apr 8, '22 RitaHu-MSFT commented Apr 19, '22

WSUS API console keeps crashing

Dear Experts,

Please help to check following errors and also screenshot where our WSUS server always crashes and I can't check the console by any chance.

Our IIS has no ram limit to WSUS application pool.

 The WSUS administration console was unable to connect to the WSUS Server via the remote API. 
    
 Verify that the Update Services service, IIS and SQL are running on the server. If the problem persists, try restarting IIS, SQL, and the Update Services Service.
    
 System.Net.WebException -- The operation has timed out
    
 Source
 System.Web.Services
    
 Stack Trace:
    at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
    at Microsoft.UpdateServices.Internal.DatabaseAccess.ApiRemotingCompressionProxy.GetWebResponse(WebRequest webRequest)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at Microsoft.UpdateServices.Internal.ApiRemoting.ExecuteSPSearchUpdates(String updateScopeXml, String preferredCulture, Int32 publicationState)
    at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPSearchUpdates(String updateScopeXml, String preferredCulture, ExtendedPublicationState publicationState)
    at Microsoft.UpdateServices.Internal.BaseApi.Update.SearchUpdates(UpdateScope searchScope, ExtendedPublicationState publicationState, UpdateServer updateServer)
    at Microsoft.UpdateServices.UI.AdminApiAccess.UpdateManager.GetUpdates(ExtendedUpdateScope filter)
    at Microsoft.UpdateServices.UI.AdminApiAccess.BulkUpdatePropertiesCache.GetAndCacheUpdates(ExtendedUpdateScope updateScope, ComputerTargetScope computerTargetScope)
    at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesListPage.GetListRows()

windows-server-update-services

wsus-connection-error.png (17.9 KiB)

5 |1600 characters needed characters left characters exceeded

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

Answer 1 · 2022-04-08T09:12:54.113Z

RitaHu-MSFT answered Apr 8, '22 RitaHu-MSFT edited Apr 8, '22

@EavenHuang
We could check the following registry value in the WSUS Server to confirm the type of the database we used.
HKLM\Software\Microsoft\Update Services\Server\SetupSqlServerName
SQL Server database:

WID database:

Reference link:
https://docs.microsoft.com/de-de/security-updates/windowsupdateservices/18127574

In addition, please try to follow the below link to maintenance if you haven't tried for a long time.
https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/wsus-maintenance-guide#help-my-wsus-has-been-running-for-years-without-ever-having-maintenance-done-and-the-cleanup-wizard-keeps-timing-out

Hope the above will be helpful.

Have a great weekend.

Regards,
Rita

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

13.png (47.7 KiB)

14.png (74.3 KiB)

5 |1600 characters needed characters left characters exceeded

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

Answer 2 · 2022-04-08T05:44:15.51Z

RitaHu-MSFT answered Apr 8, '22 RitaHu-MSFT commented Apr 19, '22

@EavenHuang
Thanks for your getting support on this forum.

Have you done any operations before the WSUS console crash? What is the type of your database? WID or SQL Server? Please try to open the SSMS as an administrator and check whether we could connect to the database.

Best regards,
Rita

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

· 2

5 |1600 characters needed characters left characters exceeded

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

EavenHuang · Apr 08 at 06:07 AM

Dear @RitaHu-MSFT,

Good question - I'm new to WSUS and just taken over this task, but how can I know if we are using WID or SQL server?
I simply expanded WSUS >> Updates >> All Updates, it didn't load anything but ended up crashing all the time.
Please kindly advise.

Thanks a lot!

0 ·

wsus-crashing.png (24.6 KiB)

RitaHu-MSFT EavenHuang · Apr 19 at 01:56 AM

@EavenHuang
Is there any updates of the case? What is the status of the case? May I know the below answers are helpful or not?

Please let me know if there are any updates or questions.

Have a great day.

Rita

0 ·

Answer 3 · 2022-04-08T12:25:22.823Z

AJTek-Adam-J-Marshall answered Apr 8, '22

Are you performing the proper WSUS maintenance including but not limited to running the 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/

If you don't do the maintenance, you WILL experience issues like what you're talking about. WSUS, like any application that uses a database, does need maintenance.

You LIKELY have the WID, as that is the most common installation of WSUS (defaults).

https://www.ajtek.ca/wsus/how-do-i-connect-to-the-windows-internal-database-wid/

I'd recommend spending some time reading all of my guides relating to WSUS

https://www.ajtek.ca/category/guides/wsus/

5 |1600 characters needed characters left characters exceeded

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

question