locked
New WSUS Server - Ported DB - "EventID=505" ReportingDatabaseAccess issue RRS feed

  • Question

  • Hi Folks, 

    I have the following error message appearing, and I can find nothing on Google whatsoever of use. Can anyone please help?

    2018-08-02 13:41:33.222 UTC Error w3wp.37 ReportingDatabaseAccess.PostProcessActivityEvents EventId=505,Message=Error occurred while writing events to the database. Exception: Database threshold reached.

       at Microsoft.UpdateServices.Internal.ReportingDatabaseAccess.PostProcessActivityEvents(Int32& numEventsProcessed, Boolean& wasTableFull)
       at Microsoft.UpdateServices.Internal.Reporting.HistoryEventProcessor.ProcessEvents(Object state)
       at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
       at System.Threading.TimerQueueTimer.CallCallback()
       at System.Threading.TimerQueueTimer.Fire()
       at System.Threading.TimerQueue.FireNextTimers()

    Thanks

    James

    Thursday, August 2, 2018 1:44 PM

All replies

  • Hello james,

     

    That looks like a IIS error. Can your WSUS work?

     

    Try reset IIS and check if it work. Refer to following link:

     https://technet.microsoft.com/en-us/library/bb734873.aspx?f=255&MSPPError=-2147217396

     

    Look for your feedback.

     

    Best Regards,

    Ray Jia


    Please remember to mark the replies as answers if they help.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, August 3, 2018 8:10 AM
  • Thanks for your reply.

    As is, it appears to be working. I have set up a dummy downstream server and it seems to be syncing. I am just leaving it to complete, as its stalled at 42%.

    The error immediately occurs. I restart the server, change the log file name (to create a new one) and the error is immediately logged.

    Friday, August 3, 2018 8:24 AM
  • Hello james,

     

    "Database threshold reached."

     

    I note above information and may be the size of the database is limited.

     

    Where does your SUSDB locate? May be you should check that if there are enough free space on that driver.

     

    And you should run WSUS cleanup wizard or run WSUS maintenance from following link and check if it works.

     

    Automated WSUS Maintenance Utility v1.6

    https://gallery.technet.microsoft.com/scriptcenter/WSUS-Maintenance-w-logging-d507a15a 

     

    Hope above information could help you and look forward to your feedback.

     

    Best Regards,

    Ray Jia


    Please remember to mark the replies as answers if they help.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Monday, August 6, 2018 2:43 AM
  • "Exception: Database threshold reached." is an error with relation to IIS Memory issue with requiring more Memory from a query than the application pool has allotted. To fix this, increase the IIS Application Pool Memory.


    * Adjust the private memory limit.
        - If you have WSUS Automated Maintenance (WAM), from the WAM Shell run:
            .\Clean-WSUS.ps1 -SetApplicationPoolMemory 4096
        - If you don't have WAM, edit the pool's configuration directly to change it to 4194304 (4GB)

    2 other good things to do:

    * Make the following "Advanced Settings" for WSUS Application Pool in IIS:
        - Queue Length: 25000 from 1000
        - Limit Interval (minutes): 15 from 5
        - "Service Unavailable" Response: TcpLevel from HttpLevel
    * Edit the web.config ( C:\Program Files\Update Services\WebServices\ClientWebService\web.config ) for WSUS (Stop the IIS first):
        - Replace <httpRuntime maxRequestLength="4096" /> with <httpRuntime maxRequestLength="204800" executionTimeout="7200"/>


    Adam Marshall, MCSE: Security
    https://www.ajtek.ca
    Microsoft MVP - Windows and Devices for IT


    • Edited by AJTek.caMVP Tuesday, August 7, 2018 7:39 PM
    Tuesday, August 7, 2018 7:39 PM