none
WSUS Cleanup

    Question

  • Hello,

    The servers are Windows Server 2016...

    it is already 2 hours and 30 minutes I have the same screen … how long should it take to delete only the unused software updates?

    RAM: 16 GB

    Dual 2.20 GHz Intel Xeon

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    Monday, December 3, 2018 9:18 PM

All replies

  • Hi Dom,

    You could have a look at the post below to see whether the solution provided there could be helpful.

    WSUS Server Cleanup Wizard Hangs on “Deleting unused updates…”

    Here's also a TechNet forum thread about this issues:

    WSUS hangs on Cleanup wizard for Unused Updates, then disconnects from console

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Monday, December 3, 2018 9:28 PM
  • Hello,

    I have only 6 GB and 743 files...!

    I did a reindex before starting the cleanup...

    It is on F: drive with 600GB space and 492 GB free space...

    Also I checked only the box for the cleanup of the unused updates all other boxes have been cleared.

    I noticed it seems SQL is using full RAM …

    After 4 hours

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL





    • Edited by Felyjos Monday, December 3, 2018 10:13 PM
    Monday, December 3, 2018 9:38 PM
  • Now I am getting


    Security / System Center Configuration Manager Current Branch / SQL

    Monday, December 3, 2018 11:07 PM
  • You could try the workaround provided in this post:

    1. Open a Command Prompt (Admin) and run the following command:

    "C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing 


    2. Restart the WSUS server.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Tuesday, December 4, 2018 12:31 AM
  • You could try the workaround provided in this post:

    1. Open a Command Prompt (Admin) and run the following command:

    "C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing 


    2. Restart the WSUS server.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Hello,

    What is it suppose to do? the run is 1 second and nothing is purged... If after the reboot I try the cleanup of the unused software updates again it is failing with the same error. As this task is supposedly automatically done monthly the issue is still here.

    Still checking... 

    from the log when running this command:

    2018-12-03 17:00:01  Postinstall started
    2018-12-03 17:00:01  Detected role services: Api, Database, UI, Services
    2018-12-03 17:00:01  Start: LoadSettingsForServicing
    2018-12-03 17:00:01  Fetching SqlServerName from registry store
    2018-12-03 17:00:01  Value is VRPSCCMSQL01.AD\ConfigMgr
    2018-12-03 17:00:01  Instance name: VRPSCCMSQL01.AD\ConfigMgr
    2018-12-03 17:00:01  End: LoadSettingsForServicing
    2018-12-03 17:00:01  Stopping service WSUSService
    2018-12-03 17:00:01  Stopping service W3SVC
    2018-12-03 17:00:11  Servicing database...
    2018-12-03 17:00:12  Servicing the database...
    2018-12-03 17:00:12  Establishing DB connection...
    2018-12-03 17:00:12  Checking to see if database exists...
    2018-12-03 17:00:12  Database exists
    2018-12-03 17:00:12  Switching database to single user mode...
    2018-12-03 17:00:15  Loading install type query...
    2018-12-03 17:00:15  DECLARE @currentDBVersion       int
    DECLARE @scriptMajorVersion     int = (14393)
    DECLARE @scriptMinorVersion     int = (0)
    DECLARE @databaseMajorVersion   int 
    DECLARE @databaseMinorVersion   int 
    DECLARE @databaseBuildNumber    nvarchar(10)
    IF NOT EXISTS(SELECT * FROM sys.databases WHERE name='SUSDB')
    BEGIN
        SELECT 1
    END
    ELSE
    BEGIN
        SET @currentDBVersion = (SELECT SchemaVersion FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
        SET @databaseBuildNumber = (SELECT BuildNumber FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
        DECLARE @delimiterPosition INT = CHARINDEX('.', @databaseBuildNumber)
        IF (@delimiterPosition = 0)
        BEGIN
            RAISERROR('Invalid schema version number', 16, 1) with nowait
            return 
        END 
        SET @databaseMajorVersion = SUBSTRING(@databaseBuildNumber, 1, @delimiterPosition - 1)
        SET @databaseMinorVersion = SUBSTRING(@databaseBuildNumber, (@delimiterPosition + 1), (10 - @delimiterPosition))
        IF @currentDBVersion < 926
        BEGIN
            SELECT 3
        END
        ELSE
        BEGIN
            IF (@scriptMajorVersion > @databaseMajorVersion OR
               (@scriptMajorVersion = @databaseMajorVersion AND @scriptMinorVersion > @databaseMinorVersion))
            BEGIN
                SELECT 2
            END
            ELSE IF (@scriptMajorVersion = @databaseMajorVersion AND
                     @scriptMinorVersion = @databaseMinorVersion)
            BEGIN
                SELECT 0
            END
            ELSE
            BEGIN
                SELECT 4
            END
        END
    END
    
    2018-12-03 17:00:15  Install type is: Reinstall
    2018-12-03 17:00:15  Install type is Reinstall, but should be Upgrade.  Cannot service the database
    2018-12-03 17:00:15  Swtching DB to multi-user mode......
    2018-12-03 17:00:15  Finished setting multi-user mode
    2018-12-03 17:00:15  Disposing Connection
    2018-12-03 17:00:15  Clearing Connection Pools
    2018-12-03 17:00:15  Starting service W3SVC
    2018-12-03 17:00:15  Starting service WSUSService
    2018-12-03 17:00:16  Postinstall completed
    

    it seems there an issue with the message: " 2018-12-03 17:00:15  Install type is Reinstall, but should be Upgrade.  Cannot service the database"

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL


    • Edited by Felyjos Tuesday, December 4, 2018 1:40 AM
    Tuesday, December 4, 2018 1:36 AM
  • There was an issue with an update in Windows Server 2012/2012R2, the interesting part is that you have Windows Server 2016 and this issue still occurs...

    Ensure first of all that your WSUS server has all the latest updates & rollups installed.

    The post below describes this issue, but as mentioned earlier it was for 2012/2012R2..

    https://www.urtech.ca/2016/08/solved-wsus-server-will-not-launch-after-august-patch-cycle-including-kb3159706/

    You could also check the following steps mentioned in the post:

    After running the command: "C:\Program Files\Update Services\Tools\wsusutil.exe postinstall /servicing"

    Add the following roles from Server Manager:

    1. Select HTTP Activation under .NET Framework 4.5 Features
    2. Restart the WSUS service.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Tuesday, December 4, 2018 8:04 AM
  • Hello Dom,
     
    How many updates and clients are there in your WSUS? And when was the last time you clean up the server? It does take lot's of time to complete the maintenance if there are too many updates and clients and you have not run the SCW periodically.
     
    There are really two different options you can take here:
     
    1. Reinstall WSUS with a fresh database.
     
    2. Ensure you have a backup of the SUSDB then run a re-index. When that completes, run the following stored procedure in SQL Server Management Studio or SQL Server Management Studio Express. After this finishes, follow all of the above instructions for running maintenance. This last step is necessary because the stored procedure here only removes unused updates and update revisions.
     
    DECLARE @var1 INT
    
    DECLARE @msg nvarchar(100)
    
     
    
    CREATE TABLE #results (Col1 INT)
    
    INSERT INTO #results(Col1) EXEC spGetObsoleteUpdatesToCleanup
    
     
    
    DECLARE WC Cursor
    
    FOR
    
    SELECT Col1 FROM #results
    
     
    
    OPEN WC
    
    FETCH NEXT FROM WC
    
    INTO @var1
    
    WHILE (@@FETCH_STATUS > -1)
    
    BEGIN SET @msg = 'Deleting' + CONVERT(varchar(10), @var1)
    
    RAISERROR(@msg,0,1) WITH NOWAIT EXEC spDeleteUpdate @localUpdateID=@var1
    
    FETCH NEXT FROM WC INTO @var1 END
    
     
    
    CLOSE WC
    
     DEALLOCATE WC
    
     
    
    DROP TABLE #results
     
    Refer to the following article to get more detailed information.
     
    The complete guide to Microsoft WSUS and Configuration Manager SUP maintenance
    https://blogs.technet.microsoft.com/configurationmgr/2016/01/26/the-complete-guide-to-microsoft-wsus-and-configuration-manager-sup-maintenance/
     
    And I also find another post for you, review the replies and I think it would be helpful.
     
    https://social.technet.microsoft.com/Forums/ie/en-US/7b12f8b2-d0e6-4f63-a98a-019356183c29/getting-past-wsus-cleanup-wizard-time-out-removing-unnecessary-updates?forum=winserverwsus
     
    Hope my answer could help you.
     
    Best Regards,
    Ray
     


     

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

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

    Tuesday, December 4, 2018 10:02 AM
  • Hello Ray,

    9,000+ updates and 25,000+ clients are there in our WSUS

    There was no cleanup done since the installation in September 2017 (14 months)

    What is the "normal" size / number of updates which should remain in the database?

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL


    • Edited by Felyjos Tuesday, December 4, 2018 6:42 PM
    Tuesday, December 4, 2018 11:55 AM
  • There was an issue with an update in Windows Server 2012/2012R2, the interesting part is that you have Windows Server 2016 and this issue still occurs...

    Ensure first of all that your WSUS server has all the latest updates & rollups installed.

    The post below describes this issue, but as mentioned earlier it was for 2012/2012R2..

    https://www.urtech.ca/2016/08/solved-wsus-server-will-not-launch-after-august-patch-cycle-including-kb3159706/

    You could also check the following steps mentioned in the post:

    After running the command: "C:\Program Files\Update Services\Tools\wsusutil.exe postinstall /servicing"

    Add the following roles from Server Manager:

    1. Select HTTP Activation under .NET Framework 4.5 Features
    2. Restart the WSUS service.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Hello,

    The patches are up-to-date with the November cycle 11/13/2018

     the command: "C:\Program Files\Update Services\Tools\wsusutil.exe postinstall /servicing" has already been run.

    HTTP Activation under .NET Framework 4.6 Features is already set on 4.6 NOT 4.5

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL


    • Edited by Felyjos Tuesday, December 4, 2018 2:53 PM
    Tuesday, December 4, 2018 2:53 PM
  • Hello Dom,
     
    How many updates and clients are there in your WSUS? And when was the last time you clean up the server? It does take lot's of time to complete the maintenance if there are too many updates and clients and you have not run the SCW periodically.
     
    There are really two different options you can take here:
     
    1. Reinstall WSUS with a fresh database.
     
    2. Ensure you have a backup of the SUSDB then run a re-index. When that completes, run the following stored procedure in SQL Server Management Studio or SQL Server Management Studio Express. After this finishes, follow all of the above instructions for running maintenance. This last step is necessary because the stored procedure here only removes unused updates and update revisions.
     
    DECLARE @var1 INT
    
    DECLARE @msg nvarchar(100)
    
     
    
    CREATE TABLE #results (Col1 INT)
    
    INSERT INTO #results(Col1) EXEC spGetObsoleteUpdatesToCleanup
    
     
    
    DECLARE WC Cursor
    
    FOR
    
    SELECT Col1 FROM #results
    
     
    
    OPEN WC
    
    FETCH NEXT FROM WC
    
    INTO @var1
    
    WHILE (@@FETCH_STATUS > -1)
    
    BEGIN SET @msg = 'Deleting' + CONVERT(varchar(10), @var1)
    
    RAISERROR(@msg,0,1) WITH NOWAIT EXEC spDeleteUpdate @localUpdateID=@var1
    
    FETCH NEXT FROM WC INTO @var1 END
    
     
    
    CLOSE WC
    
     DEALLOCATE WC
    
     
    
    DROP TABLE #results
     
    Refer to the following article to get more detailed information.
     
    The complete guide to Microsoft WSUS and Configuration Manager SUP maintenance
    https://blogs.technet.microsoft.com/configurationmgr/2016/01/26/the-complete-guide-to-microsoft-wsus-and-configuration-manager-sup-maintenance/
     
    And I also find another post for you, review the replies and I think it would be helpful.
     
    https://social.technet.microsoft.com/Forums/ie/en-US/7b12f8b2-d0e6-4f63-a98a-019356183c29/getting-past-wsus-cleanup-wizard-time-out-removing-unnecessary-updates?forum=winserverwsus
     
    Hope my answer could help you.
     
    Best Regards,
    Ray
     


     

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

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

    Hello,

    this is the URL I am following:

    The complete guide to Microsoft WSUS and Configuration Manager SUP maintenance
    https://blogs.technet.microsoft.com/configurationmgr/2016/01/26/the-complete-guide-to-microsoft-wsus-and-configuration-manager-sup-maintenance/

    the SQL Query statement is running for the last two hours

    Thanks,
    Dom


    Security / System Center Configuration Manager Current Branch / SQL


    • Edited by Felyjos Tuesday, December 4, 2018 5:45 PM
    Tuesday, December 4, 2018 5:42 PM
  • Hello,

    the SQL Query statement is running for the last five (5) hours now... still deleting... anything to check to see if it is going well.. 

     

    six (6) hours now... still deleting...

    seven (7) hours now... still deleting...

    eight (8) hours now ... still deleting ...

    What will be the next step(s) after the database is cleaned up. Any task(s) to run again on the WSUS?SUP servers?

    Thanks,
    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    • Edited by Felyjos Wednesday, December 5, 2018 12:20 AM
    Tuesday, December 4, 2018 8:26 PM
  • Hello,
     
    At this moment, I think we should wait until the deletion is complete. This script is used to remove unused updates and update revisions and when it is done check if you could run server cleanup wizard successfully. I think it should be OK then.
     
    Then you could perform other WSUS maintenance job, such as backup the WSUS database, re-index the WSUS database, decline superseded updates, etc.
     
    And don't forget to run WSUS maintenance regularly from now on.
     
    Hope my answer could help you.
     
    Best Regards,
    Ray

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

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

    Wednesday, December 5, 2018 5:08 AM
  • Hello,

    It ids done after 14 hours

    Deleting64739

    Deleting64615

    Deleting64613

    Deleting64460

    Deleting64333

    Deleting64331

    Deleting64221

    Deleting64213

    Deleting64091

    Deleting64089

    Deleting64087

    Deleting59077

    Deleting40322

    Deleting40316

    Deleting29258

    these were the last ones...

    Starting the WSUS Clean up tasks...

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL


    • Edited by Felyjos Wednesday, December 5, 2018 2:45 PM
    Wednesday, December 5, 2018 2:39 PM
  • Hello,

    1. connection failure again...

    I did the cleanup option by option and only one is failing with the above error: unneeded update files.

    2. why I have 5 connections to the same server in the console?

    Thank,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL



    • Edited by Felyjos Wednesday, December 5, 2018 8:40 PM
    Wednesday, December 5, 2018 7:52 PM
  • There's more to WSUS maintenance than just the SCW. What about sync logs, what about the SQL indexing scripts, what about drivers, what about compressing update revisions, the obsolete update removals that you're currently doing (super slowly). Here's part 8 of my blog series that deals with WSUS maintenance.

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

    The spGetObsoleteUpdatesToCleanup that you're running can take a very long time... be patient with it. Don't worry about the MMC console while it's happening.


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

    Wednesday, December 5, 2018 9:27 PM
  • And to answer your question about the 5 servers - remove all of them but 1. How they got there, we don't know. Probably added manually for SSL/port changes or something along the lines of that.

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


    • Edited by AJTek.caMVP Wednesday, December 5, 2018 9:30 PM
    Wednesday, December 5, 2018 9:29 PM
  • I removed all of them but 1

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    Thursday, December 6, 2018 8:03 PM
  • After the cleanup on the downstream servers (2) it was okay I could reconnect the WSUS local server but on the upstream I have an error:

    Nothing different done on the three servers but this one is having issue to reconnect...

    The port is correct 8531

    SSL is correct.

    in ISS the port 8531 is configured

    but I am getting an error when click on it to browse it...

    Service Unavailable


    HTTP Error 503. The service is unavailable.

    Checking the logs now

    Thanks,

    Dom

     

    Security / System Center Configuration Manager Current Branch / SQL



    • Edited by Felyjos Thursday, December 6, 2018 8:41 PM
    Thursday, December 6, 2018 8:07 PM
  • I restarted the WSUS Pool and the connection is working now...

    for few seconds and then again

    Service is running

    I did all of them one by one three went through and two remains, the ones which are checked.

    The top one will go half way green during its steps then failed

    The third one will failed after sometime but never show any green ...

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL





    • Edited by Felyjos Thursday, December 6, 2018 9:27 PM
    Thursday, December 6, 2018 8:48 PM
  • only one remaining after multiple retries


    Security / System Center Configuration Manager Current Branch / SQL

    Thursday, December 6, 2018 11:46 PM
  • Hello,
     
    Thanks for your feedback.
     
    Considering it has not been maintained for such a long time, it makes sense that it needs to run several times and it takes a long time to complete.
     
    If there is any update, feel free to feedback.
     
    Best Regards,
    Ray

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

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

    Friday, December 7, 2018 9:03 AM
  • Hello Ray,

    After several attempts (15) it seems I am in a loop...

    Application Logs:

    Log Name:      Application
    Source:        Windows Server Update Services
    Date:          12/7/2018 7:43:16 AM
    Event ID:      501
    Task Category: 1
    Level:         Information
    Keywords:      Classic
    User:          N/A
    Computer:      VRPSCCMSU01.ad.medctr.ucla.edu
    Description:
    Update Services Service Started
    ============================================================================================================================================================================
    Log Name:      Application
    Source:        Windows Server Update Services
    Date:          12/7/2018 7:43:17 AM
    Event ID:      7032
    Task Category: None
    Level:         Warning
    Keywords:      Classic
    User:          N/A
    Computer:      VRPSCCMSU01.ad.medctr.ucla.edu
    Description:
    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.Sockets.SocketException -- An existing connection was forcibly closed by the remote host
    
    Source
    System.Windows.Forms
    
    Stack Trace:
       at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
       at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
       at Microsoft.UpdateServices.UI.SnapIn.Wizards.ServerCleanup.ServerCleanupWizard.OnCleanupComplete(Object sender, PerformCleanupCompletedEventArgs e)
    ============================================================================================================================================================================
    Log Name:      Application
    Source:        Windows Server Update Services
    Date:          12/7/2018 7:43:27 AM
    Event ID:      10021
    Task Category: 7
    Level:         Warning
    Keywords:      Classic
    User:          N/A
    Computer:      VRPSCCMSU01.ad.medctr.ucla.edu
    Description:
    The catalog was last synchronized successfully 1 or more days ago.
    ============================================================================================================================================================================
    Log Name:      Application
    Source:        Windows Server Update Services
    Date:          12/7/2018 7:43:27 AM
    Event ID:      10032
    Task Category: 7
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      VRPSCCMSU01.ad.medctr.ucla.edu
    Description:
    The server is failing to download some updates.
    ============================================================================================================================================================================
    Log Name:      Application
    Source:        Windows Server Update Services
    Date:          12/7/2018 7:44:35 AM
    Event ID:      502
    Task Category: 1
    Level:         Information
    Keywords:      Classic
    User:          N/A
    Computer:      VRPSCCMSU01.ad.medctr.ucla.edu
    Description:
    Update Services Service Has Stopped
    ============================================================================================================================================================================
    
    

    All this series of errors are showing in the event log, if I restart the Update Services , then I Start the WSUSPool , then I start the "Delete Unneeded Update Files" then after 3 minutes

    it is happening again and again... anything else to check, to do?

    Thanks,
    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    Friday, December 7, 2018 3:56 PM
  • from this article...

    https://www.dell.com/support/article/mk/en/mkdhs1/sln286548/windows-server-wsus-administration-console-is-unable-to-connect-to-wsus-server-via-remote-api?lang=en

    I noticed "The Update Orchestrator Service for Windows Update service stopped ... " almost immediately after I start it ... within 60 seconds, is it expected?

    I checked the ISAPI Filters


    They look good... but still failing

    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.Sockets.SocketException -- An existing connection was forcibly closed by the remote host

    Source
    System.Windows.Forms

    Stack Trace:
       at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
       at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
       at Microsoft.UpdateServices.UI.SnapIn.Wizards.ServerCleanup.ServerCleanupWizard.OnCleanupComplete(Object sender, PerformCleanupCompletedEventArgs e)

    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.Sockets.SocketException -- An existing connection was forcibly closed by the remote host

    Source
    System.Windows.Forms

    Stack Trace:
       at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
       at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
       at Microsoft.UpdateServices.UI.SnapIn.Wizards.ServerCleanup.ServerCleanupWizard.OnCleanupComplete(Object sender, PerformCleanupCompletedEventArgs e)

    So the steps which worked for other options were:

    Start Update Orchestrator for Windows Update service

    Start WSUSPool

    Start the WSUS Console

    Start the WSUS Cleanup wizard

    but for this last option it did not work after 20 attempts!!

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL



    • Edited by Felyjos Friday, December 7, 2018 11:56 PM
    Friday, December 7, 2018 11:06 PM
  • Hello Dom,
     
    It seems that this database issue is bigger than we thought before.

    Well, at this moment, we could recreate the SUSDB and WSUS Content folder. With that, we could start over in WSUS with a fresh database. Refer to the following article.
     
    Recreating the SUSDB and WSUS Content folder for a Windows Server 2012 based WSUS computer
    https://blogs.technet.microsoft.com/sus/2016/10/18/recreating-the-susdb-and-wsus-content-folder-for-a-windows-server-2012-based-wsus-computer/
     
    This is almost the same as re-install the WSUS. However, re-installing the WSUS is also worth considering. This won't take too much time and effort, except for the first sync that would take some time. If all goes well, the clients will not be affected much.
     
    Best Regards,
    Ray

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

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

    13 hours 6 minutes ago
  • Hello Dom,
     
    It seems that this database issue is bigger than we thought before.

    Well, at this moment, we could recreate the SUSDB and WSUS Content folder. With that, we could start over in WSUS with a fresh database. Refer to the following article.
     
    Recreating the SUSDB and WSUS Content folder for a Windows Server 2012 based WSUS computer
    https://blogs.technet.microsoft.com/sus/2016/10/18/recreating-the-susdb-and-wsus-content-folder-for-a-windows-server-2012-based-wsus-computer/
     
    This is almost the same as re-install the WSUS. However, re-installing the WSUS is also worth considering. This won't take too much time and effort, except for the first sync that would take some time. If all goes well, the clients will not be affected much.
     
    Best Regards,
    Ray

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

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

    Hello Ray,

    1. let me try a recreation of SUSDB. As I have three Software Update Points I have to repeat the tasks at least when common on the three servers, isn't it?

    (Stop the WSUS service and IIS Service)

    2. Should I have a unique WSUSUpdates folder? or should I have three WSUSUpdates folders one per SUP server?

    \\ServerName\WSUSUpdates?

    3. when reinstalling SUSDB using the command

    .\Wsusutil.exe postinstall SQL_INSTANCE_NAME=”VRPSCCMSQL01\ConfigMgr” CONTENT_DIR=”F:\WSUS”

    on the VRPSCMSU01 I do not see the port allocation which should be 8531 not 8530 or 80...?

    Apparently I need also to uninstall the SUP from SCCM?

    Thanks,
    Dom


    Security / System Center Configuration Manager Current Branch / SQL





    • Edited by Felyjos 4 hours 55 minutes ago
    8 hours 3 minutes ago
  • Hello,

    I am getting an error on IIS:

    2018-12-10 10:12:51  Postinstall started
    2018-12-10 10:12:51  Detected role services: Api, Database, UI, Services
    2018-12-10 10:12:51  Start: LoadSettingsFromParameters
    2018-12-10 10:12:51  Content local is: True
    2018-12-10 10:12:51  Content directory is: F:\WSUSUpdates
    2018-12-10 10:12:51  SQL instname is: VRPSCCMSQL01\ConfigMgr
    2018-12-10 10:12:51  End: LoadSettingsFromParameters
    2018-12-10 10:12:51  Start: Run
    2018-12-10 10:12:51  Fetching WsusAdministratorsSid from registry store
    2018-12-10 10:12:51  Value is S-1-5-21-3958249549-1187530241-1261074650-1006
    2018-12-10 10:12:51  Fetching WsusReportersSid from registry store
    2018-12-10 10:12:51  Value is S-1-5-21-3958249549-1187530241-1261074650-1007
    2018-12-10 10:13:01  Configuring content directory...
    2018-12-10 10:13:01  Configuring groups...
    2018-12-10 10:13:01  Starting group configuration for WSUS Administrators...
    2018-12-10 10:13:01  Found group in regsitry, attempting to use it...
    2018-12-10 10:13:03  Writing group to registry...
    2018-12-10 10:13:03  Finished group creation
    2018-12-10 10:13:03  Starting group configuration for WSUS Reporters...
    2018-12-10 10:13:03  Found group in regsitry, attempting to use it...
    2018-12-10 10:13:03  Writing group to registry...
    2018-12-10 10:13:03  Finished group creation
    2018-12-10 10:13:03  Configuring permissions...
    2018-12-10 10:13:03  Fetching content directory...
    2018-12-10 10:13:03  Fetching ContentDir from registry store
    2018-12-10 10:13:03  Value is F:\WSUSUpdates
    2018-12-10 10:13:03  Fetching group SIDs...
    2018-12-10 10:13:03  Fetching WsusAdministratorsSid from registry store
    2018-12-10 10:13:03  Value is S-1-5-21-3958249549-1187530241-1261074650-1006
    2018-12-10 10:13:03  Fetching WsusReportersSid from registry store
    2018-12-10 10:13:03  Value is S-1-5-21-3958249549-1187530241-1261074650-1007
    2018-12-10 10:13:03  Creating group principals...
    2018-12-10 10:13:03  Granting directory permissions...
    2018-12-10 10:13:03  Granting permissions on content directory...
    2018-12-10 10:13:03  Granting registry permissions...
    2018-12-10 10:13:03  Granting registry permissions...
    2018-12-10 10:13:03  Granting registry permissions...
    2018-12-10 10:13:03  Configuring shares...
    2018-12-10 10:13:03  Configuring network shares...
    2018-12-10 10:13:03  Fetching content directory...
    2018-12-10 10:13:03  Fetching ContentDir from registry store
    2018-12-10 10:13:03  Value is F:\WSUSUpdates
    2018-12-10 10:13:03  Fetching WSUS admin SID...
    2018-12-10 10:13:03  Fetching WsusAdministratorsSid from registry store
    2018-12-10 10:13:03  Value is S-1-5-21-3958249549-1187530241-1261074650-1006
    2018-12-10 10:13:03  Content directory is local, creating content shares...
    2018-12-10 10:13:03  Creating share "UpdateServicesPackages" with path "F:\WSUSUpdates\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
    2018-12-10 10:13:03  Deleting existing share...
    2018-12-10 10:13:03  Creating share...
    2018-12-10 10:13:03  Share successfully created
    2018-12-10 10:13:03  Creating share "WsusContent" with path "F:\WSUSUpdates\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2018-12-10 10:13:03  Deleting existing share...
    2018-12-10 10:13:03  Creating share...
    2018-12-10 10:13:03  Share successfully created
    2018-12-10 10:13:03  Creating share "WSUSTemp" with path "C:\Program Files\Update Services\LogFiles\WSUSTemp" and description "A network share used by Local Publishing from a Remote WSUS Console Instance."
    2018-12-10 10:13:03  Deleting existing share...
    2018-12-10 10:13:03  Creating share...
    2018-12-10 10:13:04  Share successfully created
    2018-12-10 10:13:04  Finished creating content shares
    2018-12-10 10:13:04  Stopping service WSUSService
    2018-12-10 10:13:04  Stopping service W3SVC
    2018-12-10 10:13:04  Configuring database...
    2018-12-10 10:13:04  Configuring the database...
    2018-12-10 10:13:04  Establishing DB connection...
    2018-12-10 10:13:04  Checking to see if database exists...
    2018-12-10 10:13:04  Database does not exist
    2018-12-10 10:13:04  Loading install type query...
    2018-12-10 10:13:04  DECLARE @currentDBVersion       int
    DECLARE @scriptMajorVersion     int = (14393)
    DECLARE @scriptMinorVersion     int = (0)
    DECLARE @databaseMajorVersion   int 
    DECLARE @databaseMinorVersion   int 
    DECLARE @databaseBuildNumber    nvarchar(10)
    IF NOT EXISTS(SELECT * FROM sys.databases WHERE name='SUSDB')
    BEGIN
        SELECT 1
    END
    ELSE
    BEGIN
        SET @currentDBVersion = (SELECT SchemaVersion FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
        SET @databaseBuildNumber = (SELECT BuildNumber FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
        DECLARE @delimiterPosition INT = CHARINDEX('.', @databaseBuildNumber)
        IF (@delimiterPosition = 0)
        BEGIN
            RAISERROR('Invalid schema version number', 16, 1) with nowait
            return 
        END 
        SET @databaseMajorVersion = SUBSTRING(@databaseBuildNumber, 1, @delimiterPosition - 1)
        SET @databaseMinorVersion = SUBSTRING(@databaseBuildNumber, (@delimiterPosition + 1), (10 - @delimiterPosition))
        IF @currentDBVersion < 926
        BEGIN
            SELECT 3
        END
        ELSE
        BEGIN
            IF (@scriptMajorVersion > @databaseMajorVersion OR
               (@scriptMajorVersion = @databaseMajorVersion AND @scriptMinorVersion > @databaseMinorVersion))
            BEGIN
                SELECT 2
            END
            ELSE IF (@scriptMajorVersion = @databaseMajorVersion AND
                     @scriptMinorVersion = @databaseMinorVersion)
            BEGIN
                SELECT 0
            END
            ELSE
            BEGIN
                SELECT 4
            END
        END
    END
    
    2018-12-10 10:13:04  Install type is: Fresh
    2018-12-10 10:13:04  Creating database...
    2018-12-10 10:13:04  Disposing Connection
    2018-12-10 10:13:04  Clearing Connection Pools
    2018-12-10 10:13:07  Nonqualified transactions are being rolled back. Estimated rollback completion: 0%.
    2018-12-10 10:13:07  Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.
    2018-12-10 10:13:07  Changed database context to 'SUSDB'.
    2018-12-10 10:13:08  Changed database context to 'SUSDB'.
    2018-12-10 10:13:08  Creating Procedures spDropForeignKeyConstraint
    2018-12-10 10:13:08  Adding function spDropTableColumnIfExists
    2018-12-10 10:13:08  Adding function spAddTableColumnIfNotExists
    2018-12-10 10:13:08  Adding function spDropPrimaryKeyConstraint
    2018-12-10 10:13:08  Creating table dbo.tbPrerequisiteDependency
    2018-12-10 10:13:08  Creating table dbo.tbBundleDependency
    2018-12-10 10:13:08  Creating table tbUpdateStatusPerComputer
    2018-12-10 10:13:08  Creating table tbUpdateSummaryForAllComputers
    2018-12-10 10:13:08  Creating table tbComputerSummaryForMicrosoftUpdates
    2018-12-10 10:13:08  Creating table dbo.tbRequestedTargetGroup
    2018-12-10 10:13:08  Creating table dbo.tbRequestedTargetGroupsForTarget
    2018-12-10 10:13:08  Creating table tbDeletedComputer
    2018-12-10 10:13:08  Creating table dbo.tbComputerTargetDetail
    2018-12-10 10:13:08  Creating table dbo.tbComputerTarget
    2018-12-10 10:13:08  Creating table dbo.tbClientWithRecentNameChange
    2018-12-10 10:13:08  Creating table dbo.tbDownstreamServerTarget
    2018-12-10 10:13:08  Creating table dbo.tbDownstreamServerSummaryRollup
    2018-12-10 10:13:08  Creating table dbo.tbDownstreamServerClientSummaryRollup
    2018-12-10 10:13:08  Creating table dbo.tbDownstreamServerClientActivityRollup
    2018-12-10 10:13:08  Creating table dbo.tbTarget
    2018-12-10 10:13:08  Creating table dbo.tbTargetType
    2018-12-10 10:13:08  Creating table dbo.tbDeployment
    2018-12-10 10:13:08  tbDeployment does not exist, creating it now
    2018-12-10 10:13:08  Creating table dbo.tbDeadDeployment
    2018-12-10 10:13:08  Creating table dbo.tbRevisionLanguage
    2018-12-10 10:13:08  Creating table dbo.tbProperty
    2018-12-10 10:13:08  Creating table dbo.tbRevisionExtendedProperty
    2018-12-10 10:13:08  Creating table dbo.tbKBArticleForRevision
    2018-12-10 10:13:08  Creating table dbo.tbMoreInfoURLForRevision
    2018-12-10 10:13:08  Creating table dbo.tbSecurityBulletinForRevision
    2018-12-10 10:13:08  Creating table dbo.tbLocalizedPropertyForRevision
    2018-12-10 10:13:08  Creating table dbo.tbFileForRevision
    2018-12-10 10:13:08  Creating table dbo.tbFileHash
    2018-12-10 10:13:08  Creating table dbo.tbRevisionSupersedesUpdate
    2018-12-10 10:13:08  Creating table dbo.tbInstalledUpdateSufficientForPrerequisite
    2018-12-10 10:13:08  Creating table dbo.tbBundleAtLeastOne
    2018-12-10 10:13:08  Creating table dbo.tbBundleAll
    2018-12-10 10:13:08  Creating table dbo.tbPrerequisite
    2018-12-10 10:13:08  Creating table dbo.tbDriver
    2018-12-10 10:13:08  Creating table dbo.tbCompatiblePrinterProvider
    2018-12-10 10:13:08  Creating table dbo.tbDriverClass
    2018-12-10 10:13:09  Creating table dbo.tbTargetGroup
    2018-12-10 10:13:09  Creating table dbo.tbFlattenedTargetGroup
    2018-12-10 10:13:10  Creating table dbo.tbTargetGroupType
    2018-12-10 10:13:10  Creating table dbo.tbExpandedTargetInTargetGroup
    2018-12-10 10:13:11  Creating table dbo.tbTargetInTargetGroup
    2018-12-10 10:13:11  Creating table dbo.tbEulaProperty
    2018-12-10 10:13:11  Creating table dbo.tbEulaAcceptance
    2018-12-10 10:13:11  Creating table dbo.tbLocalizedProperty
    2018-12-10 10:13:11  Creating table dbo.tbFile
    2018-12-10 10:13:11  Creating table dbo.tbXml
    2018-12-10 10:13:11  Creating table dbo.tbGroupAuthorization
    2018-12-10 10:13:11  Creating table dbo.tbAuthorization
    2018-12-10 10:13:11  Creating table dbo.tbFileOnServer
    2018-12-10 10:13:11  Creating table dbo.tbFileDownloadProgress
    2018-12-10 10:13:11  Creating table dbo.tbSingletonData
    2018-12-10 10:13:11  Creating table dbo.tbReference
    2018-12-10 10:13:11  Creating table dbo.tbFrontEndServersHealth
    2018-12-10 10:13:11  Creating table dbo.tbConfigurationC
    2018-12-10 10:13:11  Creating table dbo.tbConfigurationB
    2018-12-10 10:13:11  Creating table dbo.tbConfigurationA
    2018-12-10 10:13:11  Creating table dbo.tbConfiguration
    2018-12-10 10:13:11  Creating table dbo.tbImplicitCategory
    2018-12-10 10:13:11  Creating table dbo.tbCategoryInSubscription
    2018-12-10 10:13:11  Creating table dbo.tbLanguageInSubscription
    2018-12-10 10:13:11  Creating table dbo.tbSchedule
    2018-12-10 10:13:11  Creating table dbo.tbEmailNotificationRecipient
    2018-12-10 10:13:11  Creating table dbo.tbRevisionInCategory
    2018-12-10 10:13:11  Creating table dbo.tbCategory
    2018-12-10 10:13:11  Creating table dbo.tbRevision
    2018-12-10 10:13:11  Creating table dbo.tbRevisionExtendedLanguageMask
    2018-12-10 10:13:11  Creating table dbo.tbUpdate
    2018-12-10 10:13:11  Creating table dbo.tbUpdateType
    2018-12-10 10:13:11  Creating table dbo.tbUpdateFlag
    2018-12-10 10:13:11  Creating table dbo.tbHandler
    2018-12-10 10:13:11  Creating table dbo.tbLanguage
    2018-12-10 10:13:11  Creating table dbo.tbCategoryType
    2018-12-10 10:13:11  Creating table dbo.tbStateMachine
    2018-12-10 10:13:11  Creating table dbo.tbStateMachineState
    2018-12-10 10:13:11  Creating table dbo.tbStateMachineEvent
    2018-12-10 10:13:11  Creating table dbo.tbStateMachineTransition
    2018-12-10 10:13:11  Creating table dbo.tbStateMachineEventTransitionLog
    2018-12-10 10:13:11  Adding View vwStateMachineEventTransitionLog
    2018-12-10 10:13:11  Creating table dbo.tbNotificationEvent
    2018-12-10 10:13:11  Creating table dbo.tbChangeTracking
    2018-12-10 10:13:11  Creating table dbo.tbFlattenedRevisionInCategory
    2018-12-10 10:13:11  Creating table dbo.tbServerSyncResult
    2018-12-10 10:13:11  Creating table dbo.tbAutoDeploymentRule
    2018-12-10 10:13:11  Creating table dbo.tbUpdateClassificationInAutoDeploymentRule
    2018-12-10 10:13:11  Creating table dbo.tbCategoryInAutoDeploymentRule
    2018-12-10 10:13:11  Creating table dbo.tbTargetGroupInAutoDeploymentRule
    2018-12-10 10:13:11  Creating table dbo.tbSchemaVersion
    2018-12-10 10:13:11  Creating table dbo.tbSchemaVersionHistory
    2018-12-10 10:13:12  Creating table dbo.tbServerHealth
    2018-12-10 10:13:12  Creating table dbo.tbProgramKeys
    2018-12-10 10:13:12  Creating table tbComputersThatNeedDetailedRollup
    2018-12-10 10:13:12  Creating table dbo.tbDriverTargetingGroup
    2018-12-10 10:13:12  Creating table dbo.tbDriverTargetingGroupPrerequisite
    2018-12-10 10:13:12  Creating table dbo.tbTargetedDriverHwid
    2018-12-10 10:13:12  Creating table dbo.tbDriverFeatureScore
    2018-12-10 10:13:12  Creating table dbo.tbDistributionComputerHardwareId
    2018-12-10 10:13:12  Creating table dbo.tbTargetComputerHardwareId
    2018-12-10 10:13:12  Creating type GuidListType
    2018-12-10 10:13:12  Adding indexed view ivwApiUpdateRevision
    2018-12-10 10:13:12  Creating Procedure spAddConstraint
    2018-12-10 10:13:12  executing stored PROCEDURE spAddConstraint
    2018-12-10 10:13:12  Adding FUNCTION fn_GetGrade 
    2018-12-10 10:13:12  Adding FUNCTION fnGetOnlineSummaryFlags
    2018-12-10 10:13:12  Adding PROCEDURE spUpdateChangeTrackingNumber
    2018-12-10 10:13:12  Creating PROCEDURE spUpdateChangeTrackingNumber
    2018-12-10 10:13:12  Adding Trigger trOnUpdatingConfiguration
    2018-12-10 10:13:12  Adding Trigger trOnInsertingUpdateStatus
    2018-12-10 10:13:12  Adding Trigger trOnDeletingUpdateStatus
    2018-12-10 10:13:12  Adding Trigger trOnUpdatingUpdateStatus
    2018-12-10 10:13:12  Adding FUNCTION fn_GetBestRevisionForEvaluateDeployment
    2018-12-10 10:13:13  Adding PROCEDURE spMoveEvaluateDeploymentsAsNeeded
    2018-12-10 10:13:13  Adding PROCEDURE spDeleteUneededPrerequisiteDeployments
    2018-12-10 10:13:13  Adding PROCEDURE spDeleteUneededBundleDeployments
    2018-12-10 10:13:13  Adding PROCEDURE spProcessPrerequisitesForRevision
    2018-12-10 10:13:13  Adding PROCEDURE spRefreshDriverTargetingDeployments
    2018-12-10 10:13:13  Adding TRIGGER trOnUpdatingRevision
    2018-12-10 10:13:13  Adding TRIGGER trOnUpdatingDeployment
    2018-12-10 10:13:13  Adding TRIGGER trOnAddingDeployment
    2018-12-10 10:13:13  The module 'trOnAddingDeployment' depends on the missing object 'dbo.spGetUpdateThrottlingSettings'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  The module 'trOnAddingDeployment' depends on the missing object 'dbo.spFireStateMachineEventEx'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  Adding PROCEDURE spGetUpdateThrottlingSettings
    2018-12-10 10:13:13  Creating PROCEDURE spGetUpdateThrottlingSettings
    2018-12-10 10:13:13  Adding Trigger trOnDeletingDeployment
    2018-12-10 10:13:13  The module 'trOnDeletingDeployment' depends on the missing object 'dbo.spGetStringFromContextInfo'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  Adding trigger trAdjustIsLeaf_reduce 
    2018-12-10 10:13:13  Adding trigger trAdjustPrerequisite 
    2018-12-10 10:13:13  Adding triggers trExpandRevisionInCategory 
    2018-12-10 10:13:13  Adding triggers trExpandFlattenedRevisionInCategory 
    2018-12-10 10:13:13  Adding triggers trExpandRevisionLanguage 
    2018-12-10 10:13:13  Adding triggers trAdjustIsLeaf_increase 
    2018-12-10 10:13:13  Adding trigger trOnAddingUpdatingGroupAuthorization
    2018-12-10 10:13:13  Adding trigger trOnDeletingGroupAuthorization
    2018-12-10 10:13:13  Adding trigger trOnAddingUpdatingAuthorization
    2018-12-10 10:13:13  Adding trigger trOnDeletingAuthorization
    2018-12-10 10:13:13  Adding trigger trOnAddingLanguage
    2018-12-10 10:13:13  Adding trigger trOnChangingLanguage
    2018-12-10 10:13:13  Adding trigger trOnDeletingLanguage
    2018-12-10 10:13:13  Adding trigger trOnAddingDriver
    2018-12-10 10:13:13  Adding trigger trOnDeletingDriver
    2018-12-10 10:13:13  Adding trigger tr_insert_ExpandedTargetInTargetGroup
    2018-12-10 10:13:13  Adding trigger tr_delete_ExpandedTargetInTargetGroup
    2018-12-10 10:13:13  Adding FUNCTION fn_later_date 
    2018-12-10 10:13:13  Adding PROCEDURE spSaveXmlFragment 
    2018-12-10 10:13:13  Creating Procedure spSaveXmlFragment
    2018-12-10 10:13:13  Adding PROCEDURE spGetChildCategories 
    2018-12-10 10:13:13  Creating Procedure spGetChildCategories
    2018-12-10 10:13:13  Adding PROCEDURE spGetUssDeployments 
    2018-12-10 10:13:13  Creating Procedure spGetUssDeployments
    2018-12-10 10:13:13  Adding PROCEDURE spUpdateSubTimestamp 
    2018-12-10 10:13:13  Creating Procedure spUpdateSubTimestamp
    2018-12-10 10:13:13  Adding PROCEDURE spPopulateLanguageInSubscription 
    2018-12-10 10:13:13  Creating Procedure spPopulateLanguageInSubscription
    2018-12-10 10:13:13  Adding PROCEDURE spAddNewLanguage 
    2018-12-10 10:13:13  Creating Procedure spAddNewLanguage
    2018-12-10 10:13:13  Adding PROCEDURE spCheckRevisionExists 
    2018-12-10 10:13:13  Creating Procedure spCheckRevisionExists
    2018-12-10 10:13:13  Adding PROCEDURE spCheckUpdateExists 
    2018-12-10 10:13:13  Creating Procedure spCheckUpdateExists
    2018-12-10 10:13:13  Adding PROCEDURE spGetFilter 
    2018-12-10 10:13:13  Creating procedure spUpdateOnlineSummaryTablesForUpdateVisible
    2018-12-10 10:13:13  Creating procedure spUpdateOnlineSummaryTablesForUpdateNotVisible
    2018-12-10 10:13:13  Creating Procedure spImportUpdate
    2018-12-10 10:13:13  The module 'spImportUpdate' depends on the missing object 'dbo.spFireStateMachineEventEx'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  The module 'spImportUpdate' depends on the missing object 'dbo.spPopulateMissingExpandedUpdateContentThrottlingInfo'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  Creating Procedure spDeploymentAutomation
    2018-12-10 10:13:13  The module 'spDeploymentAutomation' depends on the missing object 'spDeployUpdate'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  The module 'spDeploymentAutomation' depends on the missing object 'dbo.spAddReportingEventInternal'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  The module 'spDeploymentAutomation' depends on the missing object 'spDeployUpdate'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  The module 'spDeploymentAutomation' depends on the missing object 'dbo.spAddReportingEventInternal'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  The module 'spDeploymentAutomation' depends on the missing object 'dbo.spDeclineUpdate'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  The module 'spDeploymentAutomation' depends on the missing object 'dbo.spRefreshDeployments'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  Creating Procedure spSetInitialDeploymentStatus
    2018-12-10 10:13:13  Creating Procedure spImportUpdateForServerSync
    2018-12-10 10:13:13  Adding FUNCTION fn_FormatError 
    2018-12-10 10:13:13  Adding FUNCTION fn_FormatLog 
    2018-12-10 10:13:13  Adding FUNCTION fn_BuildDeploymentMessage
    2018-12-10 10:13:13  Creating Procedure spSelectProcFortbNotificationEvent
    2018-12-10 10:13:13  Creating Procedure spUpdateProcFortbNotificationEvent
    2018-12-10 10:13:13  Creating Procedure spSelectProcFortbSubscription
    2018-12-10 10:13:13  Creating Procedure spUpdateProcFortbSubscription
    2018-12-10 10:13:13  Creating Procedure spSelectProcFortbRevision
    2018-12-10 10:13:13  Creating Procedure spUpdateProcFortbRevision
    2018-12-10 10:13:13  Creating Procedure spSelectProcFortbFileOnServerDesired
    2018-12-10 10:13:13  Creating Procedure spUpdateProcFortbFileOnServerDesired
    2018-12-10 10:13:13  Creating Procedure spSelectProcFortbFileOnServerActual
    2018-12-10 10:13:13  Creating Procedure spUpdateProcFortbFileOnServerActual
    2018-12-10 10:13:13  Creating Procedure spFireStateMachineEventEx
    2018-12-10 10:13:13  Creating Procedure spFireStateMachineEvent
    2018-12-10 10:13:13  Adding PROCEDURE spGetNotificationEventItem
    2018-12-10 10:13:13  Creating Procedure spGetNotificationEventItem
    2018-12-10 10:13:13  Adding PROCEDURE spGetNotificationEventNamesToWakeUp
    2018-12-10 10:13:13  Creating PROCEDURE spGetNotificationEventNamesToWakeUp
    2018-12-10 10:13:13  The module 'spGetNotificationEventNamesToWakeUp' depends on the missing object 'dbo.spStartCatalogSync'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  The module 'spGetNotificationEventNamesToWakeUp' depends on the missing object 'dbo.spWakeUpEmailNotificationAgent'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:13  Adding PROCEDURE spGetNotificationEventNamesToWakeUpOnStartup
    2018-12-10 10:13:13  Creating PROCEDURE spGetNotificationEventNamesToWakeUpOnStartup
    2018-12-10 10:13:13  Adding PROCEDURE spCleanupIntermediateFileStatesOnStartup
    2018-12-10 10:13:13  Creating PROCEDURE spCleanupIntermediateFileStatesOnStartup
    2018-12-10 10:13:13  Adding PROCEDURE spStartCatalogSync
    2018-12-10 10:13:13  Creating Procedure spStartCatalogSync
    2018-12-10 10:13:13  Adding PROCEDURE spCancelCatalogSync
    2018-12-10 10:13:13  Creating Procedure spCancelCatalogSync
    2018-12-10 10:13:13  Adding PROCEDURE spSetHandshakeAnchor
    2018-12-10 10:13:13  Creating Procedure spSetHandshakeAnchor
    2018-12-10 10:13:14  Adding PROCEDURE spResetNotificationState
    2018-12-10 10:13:14  Creating Procedure spResetNotificationState
    2018-12-10 10:13:14  Adding PROCEDURE spGetLocalIdList 
    2018-12-10 10:13:14  Creating Procedure spGetLocalIdList
    2018-12-10 10:13:14  Adding PROCEDURE spQueueCatalogSyncRequest
    2018-12-10 10:13:14  Creating Procedure spQueueCatalogSyncRequest
    2018-12-10 10:13:14  The module 'spQueueCatalogSyncRequest' depends on the missing object 'dbo.spSetSubscriptionProgress'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:14  Adding PROCEDURE spGetSubscriptionProgress
    2018-12-10 10:13:14  Creating Procedure spGetSubscriptionProgress
    2018-12-10 10:13:14  Adding PROCEDURE spSetSubscriptionProgress
    2018-12-10 10:13:14  Creating Procedure spSetSubscriptionProgress
    2018-12-10 10:13:14  Adding PROCEDURE spSetCatalogSyncFail
    2018-12-10 10:13:14  Creating Procedure spSetCatalogSyncFail
    2018-12-10 10:13:14  Adding PROCEDURE spNotifySyncCancel
    2018-12-10 10:13:14  Creating Procedure spNotifySyncCancel
    2018-12-10 10:13:14  Adding PROCEDURE spSyncWorkDone
    2018-12-10 10:13:14  Creating Procedure spSyncWorkDone
    2018-12-10 10:13:14  Adding PROCEDURE spGetNextQueuedSubscription
    2018-12-10 10:13:14  Creating Procedure spGetNextQueuedSubscription
    2018-12-10 10:13:14  Adding PROCEDURE spGetSubscriptionState
    2018-12-10 10:13:14  Creating Procedure spGetSubscriptionState
    2018-12-10 10:13:14  Adding PROCEDURE spFixCatalogSyncStates
    2018-12-10 10:13:14  Creating Procedure spFixCatalogSyncStates
    2018-12-10 10:13:14  Creating Procedure spCancelFilesAndRelatedRevisions
    2018-12-10 10:13:14  Creating Procedure spDeactivateDeploymentsAndNotifyParentRevisionsChildNotReady
    2018-12-10 10:13:14  Creating Procedure spCheckRevisionsNeedingFile
    2018-12-10 10:13:14  The module 'spCheckRevisionsNeedingFile' depends on the missing object 'dbo.spNotifyFileActualStateImportNeeded'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:14  Creating Procedure spNotifyFileActualStateMUUrlNeeded
    2018-12-10 10:13:14  Creating Procedure spNotifyFileActualStateDownloadNeeded
    2018-12-10 10:13:14  Creating Procedure spNotifyFileActualStateImportNeeded
    2018-12-10 10:13:14  Creating Procedure spNotifyFileActualStateNotNeeded
    2018-12-10 10:13:14  Creating Procedure spNotifyActualStateAndRevisionsFileCancelled
    2018-12-10 10:13:14  Creating Procedure spWakeUpContentAgent
    2018-12-10 10:13:14  Creating Procedure spRemoveFileFromProgress
    2018-12-10 10:13:14  Creating Procedure spRemoveFileFromProgressAndWakeUpContentAgent
    2018-12-10 10:13:14  Creating Procedure spNotifyRevisionsFileReady
    2018-12-10 10:13:14  Creating Procedure spNotifyRevisionsFileFailed
    2018-12-10 10:13:14  Creating Procedure spCheckFileDesiredState
    2018-12-10 10:13:14  Creating Procedure spCheckFileDownloadQueue
    2018-12-10 10:13:14  Creating Procedure spCheckDesiredStateAndNotifyRevisionsFileReady
    2018-12-10 10:13:14  Creating Procedure spCheckFileDownloadQueueAndNotifyRevisionsFileFailed
    2018-12-10 10:13:14  Creating Procedure spCheckDesiredStateAndNotifyRevisionsFileFailed
    2018-12-10 10:13:14  Creating Procedure spNotifyRevisionsFileNotReadyAndCheckDesiredState
    2018-12-10 10:13:14  Creating Procedure spCheckFileDownloadQueueAndRemoveFileFromProgress
    2018-12-10 10:13:14  Creating Procedure spCheckFileDownloadQueueAndDesiredState
    2018-12-10 10:13:14  Creating Procedure spUpdateQueueEntryTimeAndCheckFileDownloadQueue
    2018-12-10 10:13:14  Creating Procedure spNotifyContentSyncNotificationEventWorking
    2018-12-10 10:13:14  Creating Procedure spGetNextContentSyncWorkItem
    2018-12-10 10:13:14  Creating Procedure spGetNextContentSyncWorkItemOnStartup
    2018-12-10 10:13:14  Creating PROCEDURE spUpdateFileDownloadProgress
    2018-12-10 10:13:16  Creating Procedure spSetFileMUUrl
    2018-12-10 10:13:16  Creating Procedure spGetUpdatesForFile
    2018-12-10 10:13:16  Creating Procedure spRetrieveFileDigestFromRowID
    2018-12-10 10:13:16  Creating Procedure spNotifyEulaFilesNeeded
    2018-12-10 10:13:16  The module 'spNotifyEulaFilesNeeded' depends on the missing object 'dbo.spCheckEulasAndChildRevisionsReady'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  Creating Procedure spCheckRevisionInstallationPossibility
    2018-12-10 10:13:16  Creating Procedure spNotifyParentsEulasReadyAndCheckRevisionInstallationPossibility
    2018-12-10 10:13:16  Creating Procedure spCheckRevisionNeededAndNotifyParentsChildInstallationPossible
    2018-12-10 10:13:16  Adding procedure spAddDownstreamServerToTargetGroup
    2018-12-10 10:13:16  The module 'spAddDownstreamServerToTargetGroup' depends on the missing object 'dbo.spDeployRevisionToDss'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  The module 'spAddDownstreamServerToTargetGroup' depends on the missing object 'dbo.spAddTargetToTargetGroup'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  Adding procedure spPreregisterDownstreamServer
    2018-12-10 10:13:16  The module 'spPreregisterDownstreamServer' depends on the missing object 'dbo.spCreateTargetEntry'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  Adding PROCEDURE spGetDssTargetGroup 
    2018-12-10 10:13:16  Adding PROCEDURE spUpdateDownstreamServerID 
    2018-12-10 10:13:16  Adding PROCEDURE spReturnStateMachineTransitionEventLogEntriesFromError
    2018-12-10 10:13:16  Creating Procedure spReturnStateMachineTransitionEventLogEntriesFromError
    2018-12-10 10:13:16  Creating Procedure spCheckFilesAndChildRevisionsReady
    2018-12-10 10:13:16  Creating Procedure spNotifyFilesAndChildRevisionsNeeded
    2018-12-10 10:13:16  Creating Procedure spActivateDeploymentsAndNotifyParentRevisionsChildReady
    2018-12-10 10:13:16  Creating Procedure spFailParentRevisions
    2018-12-10 10:13:16  Creating Procedure spCheckEulasAndChildRevisionsReady
    2018-12-10 10:13:16  Creating Procedure spDeactivateDeploymentsNotifyFilesNotNeeded
    2018-12-10 10:13:16  Creating Procedure spResetStateMachineAndReEvaluate
    2018-12-10 10:13:16  Creating Procedures spCancelAllNotReadyRevisions
    2018-12-10 10:13:16  Creating Procedures spDownloadAllNotNeededRevisions
    2018-12-10 10:13:16  Creating Procedures spWakeUpResetAgent
    2018-12-10 10:13:16  Creating Procedures spWakeUpEmailNotificationAgent
    2018-12-10 10:13:16  Creating Procedures spNotifyResetAgentNotificationEventWorking
    2018-12-10 10:13:16  Creating Procedures spNotifyResetAgentNotificationEventDone
    2018-12-10 10:13:16  Creating Procedures spWakeUpRollupAgent
    2018-12-10 10:13:16  Creating Procedures spNotifyRollupAgentNotificationEventWorking
    2018-12-10 10:13:16  Creating Procedures spNotifyRollupAgentNotificationEventDone
    2018-12-10 10:13:16  Creating Procedures spNotifyEmailNotificationAgentNotificationEventWorking
    2018-12-10 10:13:16  Creating Procedures spNotifyEmailNotificationAgentNotificationEventDone
    2018-12-10 10:13:16  Creating Procedure spSaveUssHostOnMU
    2018-12-10 10:13:16  Creating Procedure spRetrieveUssHostOnMU
    2018-12-10 10:13:16  Creating Procedure spGetLastServerSyncCookie 
    2018-12-10 10:13:16  Creating Procedure spSetLastServerSyncCookie 
    2018-12-10 10:13:16  Creating Procedure spResetServer 
    2018-12-10 10:13:16  Creating Procedure spGetLastSyncTime 
    2018-12-10 10:13:16  Creating Procedure spSetLastSyncTime 
    2018-12-10 10:13:16  The module 'spSetLastSyncTime' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  The module 'spSetLastSyncTime' depends on the missing object 'spIsRegistrationRequired'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  Creating Procedure spIsRegistrationRequired 
    2018-12-10 10:13:16  Creating Procedure spGetComputerTargetGroup 
    2018-12-10 10:13:16  The module 'spGetComputerTargetGroup' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  The module 'spGetComputerTargetGroup' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  Creating Procedure spCheckForClientNameChange 
    2018-12-10 10:13:16  Creating Procedure spGetFrontEndServers 
    2018-12-10 10:13:16  Creating Procedure spRemoveFrontEndServer 
    2018-12-10 10:13:16  Creating Procedure spGetClientsWithRecentNameChange 
    2018-12-10 10:13:16  Creating Procedure spGetComputerTargetGroupEx 
    2018-12-10 10:13:16  The module 'spGetComputerTargetGroupEx' depends on the missing object 'dbo.spDeleteComputer'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  The module 'spGetComputerTargetGroupEx' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  The module 'spGetComputerTargetGroupEx' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  Adding PROCEDURE spRegisterComputer 
    2018-12-10 10:13:16  The module 'spRegisterComputer' depends on the missing object 'dbo.spMarkComputerAsNeedingDetailedRollup'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:16  Creating Procedure spSetBatchURL
    2018-12-10 10:13:16  Creating Procedure spUpdateServerHealthStatus
    2018-12-10 10:13:16  Creating PROCEDURE spGetExportData
    2018-12-10 10:13:16  Creating Procedure spGetExportUpdateData
    2018-12-10 10:13:16  Adding PROCEDURE spGetDataForSyncPackage
    2018-12-10 10:13:16  Creating Procedure spGetDataForSyncPackage
    2018-12-10 10:13:16  Creating Procedure spGetBundedByDataForSyncPackage
    2018-12-10 10:13:16  Creating Procedure spGetUpdateDataForSyncPackage
    2018-12-10 10:13:16  Creating Procedure spGetUpdateTypeByRevisionID
    2018-12-10 10:13:16  Creating Procedure spEnableReplica
    2018-12-10 10:13:17  Creating Procedure spGetAllExplicitComputerDeployments
    2018-12-10 10:13:17  Adding procedure spGetUpdatesForBulkHideInReplicaSync
    2018-12-10 10:13:17  Adding Procedure spDeleteRevision
    2018-12-10 10:13:17  Creating Procedure spGetCompressionThesholds
    2018-12-10 10:13:17  Adding Procedure spGetUpdatesWithPermanantlyInactiveDeployments
    2018-12-10 10:13:17  Adding Procedure spDeleteDeploymentsForUpdatesWithPermanantlyInactiveDeployments
    2018-12-10 10:13:17  The module 'spDeleteDeploymentsForUpdatesWithPermanantlyInactiveDeployments' depends on the missing object 'dbo.spSetStringInContextInfo'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:17  Adding Procedure spSetUpdateFlagCatalogSite
    2018-12-10 10:13:17  Adding Procedure spGetUpdatesWithCatalogSiteFlag
    2018-12-10 10:13:17  Adding Procedure spMarkComputerAsNeedingDetailedRollup
    2018-12-10 10:13:17  Adding Procedure spMarkComputerAsDeletedForDss
    2018-12-10 10:13:17  Adding Procedure spUpdateDownstreamServerTarget
    2018-12-10 10:13:17  The module 'spUpdateDownstreamServerTarget' depends on the missing object 'dbo.spCreateTargetEntry'. The module will still be created; however, it cannot run successfully until the object exists.
    2018-12-10 10:13:17  Adding Procedure spUpdateDownstreamServerSummaryRollup
    2018-12-10 10:13:17  Adding Procedure spUpdateDownstreamServerClientSummaryRollup
    2018-12-10 10:13:17  Adding Procedure spUpdateDownstreamServerClientActivityRollup
    2018-12-10 10:13:17  Adding Procedure spGetDownstreamServerClientSummaries
    2018-12-10 10:13:17  Adding Procedure spClearAllClientActivityCounts
    2018-12-10 10:13:17  Adding Procedure spGetClientSummaryForAllServers
    2018-12-10 10:13:17  Adding Procedure spGetClientActivityForAllServers
    2018-12-10 10:13:17  Adding Procedure spSetLastTimeReportToMU
    2018-12-10 10:13:17  Adding Procedure spGetLastTimeReportToMU
    2018-12-10 10:13:17  Adding PROCEDURE spGetTempContentCache
    2018-12-10 10:13:17  Creating PROCEDURE spGetTempContentCache
    2018-12-10 10:13:17  Creating PROCEDURE spPopulateMissingExpandedUpdateContentThrottlingInfo
    2018-12-10 10:13:17  Creating PROCEDURE spSetStringInContextInfo
    2018-12-10 10:13:17  Creating PROCEDURE spGetStringFromContextInfo
    2018-12-10 10:13:17  Creating PROCEDURE spSetOfflineSyncExclusionList
    2018-12-10 10:13:17  Creating PROCEDURE spGetEncryptedProxyPasswordFromDatabaseForUpgrade
    2018-12-10 10:13:17  Creating PROCEDURE spResetDssRequestedStateForFiles
    2018-12-10 10:13:17  Creating PROCEDURE spAllowComputersWithDuplicateNames
    2018-12-10 10:13:17  Creating PROCEDURE spGetAllUpdateUrls
    2018-12-10 10:13:17  Creating PROCEDURE spGetStartServerInitializationStatus
    2018-12-10 10:13:17  Creating PROCEDURE spSetStartServerInitializationStatus
    2018-12-10 10:13:17  Changed database context to 'SUSDB'.
    2018-12-10 10:13:17  Adding function fnGetConfigurationValue
    2018-12-10 10:13:17  Adding view vwConfiguration 
    2018-12-10 10:13:17  Adding PROCEDURE spConfiguration 
    2018-12-10 10:13:17  Creating Procedure spConfiguration
    2018-12-10 10:13:17  Creating Procedure spGetUpstreamServerInfo
    2018-12-10 10:13:17  Adding PROCEDURE spGetUpdateXmlFromRevision 
    2018-12-10 10:13:17  Creating Procedure spGetUpdateXmlFromRevision
    2018-12-10 10:13:17  Adding PROCEDURE spGetChangeTrackingInformation
    2018-12-10 10:13:17  Creating PROCEDURE spGetChangeTrackingInformation
    2018-12-10 10:13:17  Adding PROCEDURE spGetChangeTrackingNumber
    2018-12-10 10:13:17  Creating PROCEDURE spGetChangeTrackingNumber
    2018-12-10 10:13:17  Adding procedure spGetAllLanguagesWithEnabledState
    2018-12-10 10:13:17  Adding procedure spCheckConnection
    2018-12-10 10:13:17  Adding procedure spGetChangeTrackingNumbersForCache
    2018-12-10 10:13:17  Adding procedure spGetLanguageListForCache
    2018-12-10 10:13:17  Adding procedure spGetRevisionIdListForCache
    2018-12-10 10:13:17  Adding Procedure spGetRelatedRevisionsForUpdateID
    2018-12-10 10:13:17  Adding Procedure spGetAllUpdateIDs
    2018-12-10 10:13:17  Adding procedure spGetProgramKeys
    2018-12-10 10:13:17  Creating type UpdateIdentityListType
    2018-12-10 10:13:17  Adding procedure spGetMissingDrivers
    2018-12-10 10:13:17  Adding procedure spGetMissingDriverSets
    2018-12-10 10:13:17  Adding procedure spGetPublishedXmlForUpdate
    2018-12-10 10:13:17  Creating Procedure spGetUpdateDecryptionData
    2018-12-10 10:13:17  Creating Procedure spSetUpdateDecryptionData
    2018-12-10 10:13:17  Changed database context to 'SUSDB'.
    2018-12-10 10:13:17  Creating Function fnCsvToInt
    2018-12-10 10:13:17  Creating Function fnCsvToUniqueID
    2018-12-10 10:13:17  Creating Procedure spGetCoreUpdateXml
    2018-12-10 10:13:17  Creating Procedure spGetLocalizedUpdateXml
    2018-12-10 10:13:17  Creating Procedure spGetLocaleNames
    2018-12-10 10:13:17  Creating Procedure spGetGlobalUpdates
    2018-12-10 10:13:17  Creating Procedure spGetHardwareDrivers
    2018-12-10 10:13:17  Creating Procedure spGetMonitorableStatus
    2018-12-10 10:13:17  Creating Procedure spGetFileLocations
    2018-12-10 10:13:17  Adding procedure spGetAllTargetGroups
    2018-12-10 10:13:17  Creating Procedure spGetFrontEndServerInfo
    2018-12-10 10:13:17  Creating Procedure spSetFrontEndServerInfo
    2018-12-10 10:13:17  Creating Procedure spSetFileLocationChange
    2018-12-10 10:13:17  Creating Procedure spGetRevisionInfo
    2018-12-10 10:13:17  Creating Procedure spGetDeltaRevisionInfo
    2018-12-10 10:13:17  Adding procedure spGetConfigurationValue
    2018-12-10 10:13:17  Adding procedure spSetConfigurationValue
    2018-12-10 10:13:17  Changed database context to 'SUSDB'.
    2018-12-10 10:13:17  Adding procedure spAdduser
    2018-12-10 10:13:17  Adding procedure spGrantAsp 
    2018-12-10 10:13:17  Adding procedure spSetupLogin
    2018-12-10 10:13:17  Adding procedure spSetContentCacheLocation
    2018-12-10 10:13:17  Adding procedure spSetDefaults
    2018-12-10 10:13:17  Adding database version 
    2018-12-10 10:13:17  Changed database context to 'SUSDB'.
    2018-12-10 10:13:17  Creating table tbEventMessageTemplate
    2018-12-10 10:13:17  Creating table tbEventInstance
    2018-12-10 10:13:17  Creating table tbEvent
    2018-12-10 10:13:18  Creating table tbEventSource
    2018-12-10 10:13:18  Creating table tbEventNamespace
    2018-12-10 10:13:18  Alter table tbEvent with foreign key
    2018-12-10 10:13:18  Alter table tbEventSource with foreign key
    2018-12-10 10:13:18  Alter table tbEventMessageTemplate with foreign key
    2018-12-10 10:13:18  Alter table tbEventInstance with foreign keys
    2018-12-10 10:13:18  Adding procedure spImportEventNamespaceDescriptor
    2018-12-10 10:13:18  Adding procedure spAutoPurgeReportingEvents 
    2018-12-10 10:13:18  Adding procedure spLoadReportingEventAttributes
    2018-12-10 10:13:18  Changed database context to 'SUSDB'.
    2018-12-10 10:13:18  Creating table tbLocaleMap
    2018-12-10 10:13:18  Creating table tbOSMap
    2018-12-10 10:13:18  Creating table tbDownstreamServerRollupConfiguration
    2018-12-10 10:13:18  Creating table tbEventRollupCounters
    2018-12-10 10:13:18  Adding function fnFindOsID 
    2018-12-10 10:13:18  Adding function fnGetSummarizationState 
    2018-12-10 10:13:18  Adding function fnGetEffectiveDeployment 
    2018-12-10 10:13:18  Adding function fnGetTargetGroupIDForComputer
    2018-12-10 10:13:18  Adding procedure spAddReportingEventBatch 
    2018-12-10 10:13:20  Adding procedure spProcessActivityEvents 
    2018-12-10 10:13:20  Adding procedure spAddReportingEventInternal 
    2018-12-10 10:13:20  Adding procedure spAddUpdateStatusEventBatch 
    2018-12-10 10:13:20  Adding procedure spHandleClientRebootedEvent 
    2018-12-10 10:13:20  Adding procedure spUpdateLatestRollupEventTime
    2018-12-10 10:13:20  Adding procedure spGetCurrentSqlServerTime
    2018-12-10 10:13:20  Adding procedure spGetLatestRollupEventTime
    2018-12-10 10:13:20  Adding procedure spUpdateCurrentRollupState
    2018-12-10 10:13:20  Adding procedure spGetCurrentRollupState
    2018-12-10 10:13:20  Adding procedure spGetRollupCounter
    2018-12-10 10:13:20  Adding procedure spUpdateRollupCounter
    2018-12-10 10:13:20  Adding procedure spSetLastRollupInfo
    2018-12-10 10:13:20  Adding procedure spGetLastRollupInfo
    2018-12-10 10:13:20  Adding procedure spResetOnlineSummaryTables
    2018-12-10 10:13:20  Changed database context to 'SUSDB'.
    2018-12-10 10:13:20  Adding procedure spGetComputersToRollup
    2018-12-10 10:13:20  Adding procedure spMarkComputersAsNeedingFullComputerRollup
    2018-12-10 10:13:20  Adding procedure spUpdateComputersAfterRollup
    2018-12-10 10:13:20  Adding procedure spAddRollupComputers
    2018-12-10 10:13:20  Adding procedure spGetComputerLastRollupNumbers
    2018-12-10 10:13:20  Adding procedure spGetOutOfSyncComputers
    2018-12-10 10:13:20  Adding procedure spMarkComputersAsNeedingFullStatusRollup
    2018-12-10 10:13:20  Adding procedure spGetComputerStatusToRollup
    2018-12-10 10:13:20  Adding procedure spUpdateComputerStatusAfterRollup
    2018-12-10 10:13:20  Adding procedure spAddRollupStatus
    2018-12-10 10:13:20  Adding procedure spAddRollupStatusNoStatus
    2018-12-10 10:13:20  Adding procedure spMarkDataForFullRollup
    2018-12-10 10:13:20  Changed database context to 'SUSDB'.
    2018-12-10 10:13:20  Adding function fnMapLocalUpdateIDToGlobal 
    2018-12-10 10:13:20  Adding function fnMapGlobalToLocalUpdateID 
    2018-12-10 10:13:20  Adding function fnHasStaleDeployments
    2018-12-10 10:13:20  Adding function fnHasSupersededUpdates
    2018-12-10 10:13:20  Adding function fnIsEulaAcceptanceRequired
    2018-12-10 10:13:20  Adding function fnGetTargetGroupTypeID
    2018-12-10 10:13:20  Adding function fnGetComputerTargetID 
    2018-12-10 10:13:20  Adding function fnGetLatestRevisionNumber
    2018-12-10 10:13:20  Adding function fnIsInReplicaMode
    2018-12-10 10:13:20  Adding function fnComputeAutoApprovalDeadline
    2018-12-10 10:13:20  Adding view vwUpdatesToReport
    2018-12-10 10:13:20  Adding view vwUpdateInCategory
    2018-12-10 10:13:20  Adding view vwApiUpdateType
    2018-12-10 10:13:20  Adding view vwMinimalUpdate 
    2018-12-10 10:13:20  Adding view vwUpdateLanguage 
    2018-12-10 10:13:20  Adding view vwDefaultLocalizedProperty 
    2018-12-10 10:13:20  Adding view vwUpdateLocalizedProperties 
    2018-12-10 10:13:20  Adding view vwCategoryProperties 
    2018-12-10 10:13:20  Adding view vwEventHistory 
    2018-12-10 10:13:20  Adding function fnTbUpdateTypeNamesToGet
    2018-12-10 10:13:20  Adding function fnTbComputersInTargetGroup
    2018-12-10 10:13:20  Adding procedure spFilterUpdatesByScopeInternal
    2018-12-10 10:13:20  Adding procedure spGetCategories
    2018-12-10 10:13:20  Adding procedure spGetTopLevelCategories
    2018-12-10 10:13:20  Adding procedure spGetCategoryPropertiesByID
    2018-12-10 10:13:20  Adding procedure spGetSubCategoriesByUpdateID
    2018-12-10 10:13:20  Adding procedure spGetUpdatesUnderACategory
    2018-12-10 10:13:20  Adding procedure spGetTotalSummary
    2018-12-10 10:13:21  Adding procedure spGetSummariesPerComputer
    2018-12-10 10:13:21  Adding procedure spGetSummariesPerUpdate
    2018-12-10 10:13:21  Adding procedure spGetTotalUpdateSummaryForTargetGroup
    2018-12-10 10:13:21  Adding procedure spGetUpdateSummariesForTargetGroup
    2018-12-10 10:13:21  Adding procedure spGetTotalSummaryForComputer
    2018-12-10 10:13:21  Adding procedure spGetComputerSummariesForTargetGroup
    2018-12-10 10:13:21  Adding procedure spGetTargetGroupSummariesForUpdate
    2018-12-10 10:13:21  Adding procedure spGetUpdateSummaryForSingleTargetGroup
    2018-12-10 10:13:21  Adding procedure spGetTotalSummaryForCategory
    2018-12-10 10:13:21  Adding procedure spGetUpdateSummariesForCategory
    2018-12-10 10:13:21  Adding procedure spGetComputerSummariesForCategory
    2018-12-10 10:13:21  Adding procedure spGetUpdateInstallationInfoForUpdate
    2018-12-10 10:13:21  Adding procedure spGetUpdateInstallationInfoForComputer 
    2018-12-10 10:13:21  Adding procedure spGetUpdateInstallationInfoForTargetGroup
    2018-12-10 10:13:21  Adding procedure spDeployRevisionToDss
    2018-12-10 10:13:21  Adding procedure spGetAutoDeploymentRuleByID
    2018-12-10 10:13:21  Adding procedure spSaveParsedExtendedProperties
    2018-12-10 10:13:21  Adding procedure spGetUpdatesAndDeployments
    2018-12-10 10:13:21  Adding procedure spSetAutoDeploymentRule
    2018-12-10 10:13:21  Adding procedure spGetAutoDeploymentRuleIDs
    2018-12-10 10:13:21  Adding procedure spCreateAutoDeploymentRule
    2018-12-10 10:13:21  Adding procedure spDeleteAutoDeploymentRuleByID
    2018-12-10 10:13:21  Adding procedure spGetUpdateListToApproveForAutoDeploymentRule
    2018-12-10 10:13:21  Adding procedure spGetComputersNotContactedSinceCount
    2018-12-10 10:13:21  Adding procedure spDeclineUpdate
    2018-12-10 10:13:21  Adding procedure spGetParentCategories
    2018-12-10 10:13:21  Adding procedure spSearchUpdates 
    2018-12-10 10:13:21  Adding procedure spGetAllUpdates 
    2018-12-10 10:13:21  Adding procedure spGetUpdateCount
    2018-12-10 10:13:21  Adding procedure spGetRevisions
    2018-12-10 10:13:21  Adding procedure spGetComputerTargetByName
    2018-12-10 10:13:21  Adding procedure spSimpleSearchComputers
    2018-12-10 10:13:21  Adding procedure spSimpleSearchUpdates 
    2018-12-10 10:13:21  Adding procedure spGetEulaFiles
    2018-12-10 10:13:21  Adding procedure spGetShortLanguage
    2018-12-10 10:13:21  Adding procedure spGetEulaAcceptances
    2018-12-10 10:13:21  Adding procedure spAcceptEula
    2018-12-10 10:13:21  Adding procedure spAcceptEulaForReplicaDSS
    2018-12-10 10:13:21  Adding procedure spRecurseInsertCategoriesIntoFlatTable
    2018-12-10 10:13:21  Adding procedure spInsertCategoriesIntoFlatTable
    2018-12-10 10:13:21  Adding procedure spRepairPrecomputedTables
    2018-12-10 10:13:21  Adding procedure spGetInstallableItems
    2018-12-10 10:13:21  Adding PROCEDURE spGetApprovedUpdateMetadata 
    2018-12-10 10:13:21  Creating Procedure spGetApprovedUpdateMetadata
    2018-12-10 10:13:21  Adding procedure spHasApprovalsChanged
    2018-12-10 10:13:21  Adding procedure spGetUpdateByID
    2018-12-10 10:13:21  Adding procedure spGetUpdatesBundledByUpdate
    2018-12-10 10:13:21  Adding procedure spGetUpdatesThatBundleUpdate
    2018-12-10 10:13:21  Adding procedure spGetUpdatesSupersededByUpdate
    2018-12-10 10:13:21  Adding procedure spGetUpdatesThatSupersedeUpdate
    2018-12-10 10:13:22  Adding procedure spGetUpdatesRequiredByUpdate
    2018-12-10 10:13:22  Adding procedure spGetUpdatesThatRequireUpdate
    2018-12-10 10:13:22  Adding procedure spGetLanguagesForUpdate
    2018-12-10 10:13:22  Adding procedure spGetContentDownloadProgress
    2018-12-10 10:13:22  Adding procedure spCancelDownload
    2018-12-10 10:13:22  Adding procedure spCancelAllDownloads
    2018-12-10 10:13:22  Adding procedure spResumeDownload
    2018-12-10 10:13:22  Adding procedure spResumeAllDownloads
    2018-12-10 10:13:22  Adding procedure spSetConfiguration 
    2018-12-10 10:13:22  Adding Procedure spSetRollupConfiguration
    2018-12-10 10:13:22  Adding procedure spGetResetStateMachineNeededFlag
    2018-12-10 10:13:22  Adding procedure spDeleteDeployment
    2018-12-10 10:13:22  Adding procedure spCreateImplicitDeployment
    2018-12-10 10:13:22  Adding procedure spCreateDriverTargetingDeployments
    2018-12-10 10:13:22  Adding procedure spUndeclineUpdate
    2018-12-10 10:13:22  Adding procedure spDeployUpdate
    2018-12-10 10:13:22  Adding procedure spGetDeploymentByID 
    2018-12-10 10:13:22  Adding procedure spGetDeploymentsForAnUpdate
    2018-12-10 10:13:22  Adding procedure spGetDeployments
    2018-12-10 10:13:22  Adding procedure spRefreshDeployments
    2018-12-10 10:13:22  Adding procedure spGetSubscription
    2018-12-10 10:13:22  Adding procedure spGetSubscriptionCategories
    2018-12-10 10:13:22  Adding procedure spGetSubscriptionNextSynchronizationTime
    2018-12-10 10:13:22  Adding procedure spSetSubscription
    2018-12-10 10:13:22  Adding procedure spSetSubscriptionLastRunTime
    2018-12-10 10:13:23  Adding procedure spSetScheduleFrequency
    2018-12-10 10:13:23  Adding procedure spSetSubscriptionDeploymentAnchor
    2018-12-10 10:13:23  Adding procedure spSetSubscriptionAnchor
    2018-12-10 10:13:23  Adding procedure spGetTargetGroupByID
    2018-12-10 10:13:23  Adding procedure spGetTargetGroupForComputer
    2018-12-10 10:13:23  Adding procedure spGetTargetGroupsForComputer
    2018-12-10 10:13:23  Adding procedure spGetChildTargetGroups
    2018-12-10 10:13:23  Adding procedure spGetParentTargetGroup
    2018-12-10 10:13:23  Adding procedure spCreateTargetGroup
    2018-12-10 10:13:23  Adding procedure spDeleteTargetGroup
    2018-12-10 10:13:23  Adding procedure spAddTargetToTargetGroup
    2018-12-10 10:13:23  Adding procedure spRemoveTargetFromTargetGroup
    2018-12-10 10:13:23  Adding procedure spGetAllComputers
    2018-12-10 10:13:23  Adding procedure spSearchComputers
    2018-12-10 10:13:23  Adding procedure spGetComputerCount
    2018-12-10 10:13:23  Adding procedure spGetAllDownstreamServers
    2018-12-10 10:13:23  Adding procedure spGetInventoryItemsForComputer
    2018-12-10 10:13:23  Adding procedure spGetInventorySummary
    2018-12-10 10:13:23  Adding procedure spGetComputersHavingInventoryItem
    2018-12-10 10:13:23  Adding procedure spGetComputersInTargetGroup
    2018-12-10 10:13:23  Adding procedure spAddComputerToTargetGroup
    2018-12-10 10:13:23  Adding procedure spAddComputerToTargetGroupAllowMultipleGroups
    2018-12-10 10:13:23  Adding procedure spRemoveComputerFromTargetGroup
    2018-12-10 10:13:23  Adding procedure spGetDownstreamServersInTargetGroup
    2018-12-10 10:13:23  Adding procedure spCreateTargetEntry
    2018-12-10 10:13:23  Adding procedure spPreregisterComputer
    2018-12-10 10:13:23  Adding procedure spGetComputerByID
    2018-12-10 10:13:23  Adding procedure spGetDownstreamServer
    2018-12-10 10:13:23  Adding procedure spDeleteComputer
    2018-12-10 10:13:23  Adding procedure spDeleteDownstreamServer
    2018-12-10 10:13:23  Adding procedure spSearchEventHistory  
    2018-12-10 10:13:23  Adding procedure spPurgeReportingEvents 
    2018-12-10 10:13:23  Adding procedure spGetComponentsWithErrors
    2018-12-10 10:13:23  Adding procedure spGetUpdateServerStatus
    2018-12-10 10:13:23  Adding Procedure spGetDownstreamServerRollupSummary
    2018-12-10 10:13:23  Creating Procedure spGetXmlForUpdate
    2018-12-10 10:13:23  Creating Procedure spGetPreviousRevision
    2018-12-10 10:13:23  Adding Procedure spGetLatestRevisionNumberForUpdate
    2018-12-10 10:13:23  Adding Procedure spGetSdpXmlForUpdate
    2018-12-10 10:13:23  Adding PROCEDURE spGetEmailNotificationConfiguration
    2018-12-10 10:13:23  Adding PROCEDURE spSetEmailNotificationConfiguration
    2018-12-10 10:13:23  Adding procedure spGetEmailNotificationStatus
    2018-12-10 10:13:23  Adding procedure spSetEmailNotificationStatus
    2018-12-10 10:13:23  Adding PROCEDURE spScheduleEmailNotification
    2018-12-10 10:13:23  Adding PROCEDURE spGetEmailsToNotify
    2018-12-10 10:13:23  Adding PROCEDURE spGetEmailNotificationRecipients
    2018-12-10 10:13:23  Adding PROCEDURE spAddEmailNotificationRecipient
    2018-12-10 10:13:23  Adding PROCEDURE spDeclineSupersededUpdates
    2018-12-10 10:13:23  Adding PROCEDURE spDeclineExpiredUpdates
    2018-12-10 10:13:23  Adding PROCEDURE spCountObsoleteUpdatesToCleanup
    2018-12-10 10:13:23  Adding PROCEDURE spGetObsoleteUpdatesToCleanup
    2018-12-10 10:13:23  Adding PROCEDURE spDeleteUpdate
    2018-12-10 10:13:23  Adding PROCEDURE spDeleteUpdateByUpdateID
    2018-12-10 10:13:23  Adding PROCEDURE spCountUpdatesToCompress
    2018-12-10 10:13:23  Adding PROCEDURE spGetUpdatesToCompress
    2018-12-10 10:13:23  Adding PROCEDURE spCompressUpdate
    2018-12-10 10:13:23  Adding PROCEDURE spCleanupObsoleteComputers
    2018-12-10 10:13:23  Adding PROCEDURE spCleanupUnneededContentFiles
    2018-12-10 10:13:23  Adding procedure spGetFailedToDownloadUpdatesCount
    2018-12-10 10:13:23  Changed database context to 'SUSDB'.
    2018-12-10 10:13:24  Populating the database with basic configuration information
    2018-12-10 10:13:24  Creating the pre-defined target groups 
    2018-12-10 10:13:24  Populating Auto Deployment Rules
    2018-12-10 10:13:24  Populating System Subscription
    2018-12-10 10:13:24  Populating Email Notification Configuration
    2018-12-10 10:13:24  Populating Email Notification Status
    2018-12-10 10:13:24  Populating Languages
    2018-12-10 10:13:24  Populating tbLanguageInSubscription for default subscription
    2018-12-10 10:13:24  Populating Categories
    2018-12-10 10:13:24  Populating Driver classes
    2018-12-10 10:13:24  Adding Firmware Driver Class
    2018-12-10 10:13:24  Populating handlers
    2018-12-10 10:13:24  Populating driver types
    2018-12-10 10:13:24  Populating state machine
    2018-12-10 10:13:24  Changed database context to 'SUSDB'.
    2018-12-10 10:13:25  Changed database context to 'SUSDB'.
    2018-12-10 10:13:25  Creating PROCEDURE spUpdateInventoryRulesXml
    2018-12-10 10:13:25  Creating PROCEDURE spAddDetailedInventoryRules
    2018-12-10 10:13:25  Creating PROCEDURE spGetInventoryVersion
    2018-12-10 10:13:25  Creating PROCEDURE spAddInventoryXml
    2018-12-10 10:13:25  Creating PROCEDURE spAddDetailedInventoryInformation
    2018-12-10 10:13:25  Changed database context to 'SUSDB'.
    2018-12-10 10:13:25  Creating PublicViewAccess Database role
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vUpdate
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vCategory
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vClassification
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vUpdateInCategory
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vLanguage
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vUpdateText
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vUpdateAdditionalInfoUrl
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vCategoryText
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vClassificationText
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vDownstreamServer
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vComputerTarget
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vComputerTargetGroup
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vComputerGroupMembership
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vUpdateApproval
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vUpdateInstallationInfoBasic
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vUpdateInstallationInfo
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vUpdateEffectiveApprovalPerComputer
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vSupportedInventory
    2018-12-10 10:13:25  Creating view PUBLIC_VIEWS.vComputerInventory
    2018-12-10 10:13:25  Creating TVF PUBLIC_VIEWS.fnUpdateInstallationStateMap
    2018-12-10 10:13:25  Changed database context to 'SUSDB'.
    2018-12-10 10:13:25  Adding table tbDynamicCategory
    2018-12-10 10:13:25  Adding trigger trDynamicCategoryDeleted
    2018-12-10 10:13:25  Adding trigger trDynamicCategoryCreated
    2018-12-10 10:13:25  Adding table tbMapping_Target_DynamicCategory
    2018-12-10 10:13:25  Adding trigger trDynamicCategoryCleanup
    2018-12-10 10:13:25  Adding table tbDcRollupStatus
    2018-12-10 10:13:25  Adding table tbDeletedDynamicCategory
    2018-12-10 10:13:25  Creating type DynamicCategoryTableType
    2018-12-10 10:13:25  Adding procedure spDcAddCategory
    2018-12-10 10:13:25  Adding procedure spDcAddCategories
    2018-12-10 10:13:25  Adding procedure spDcGetCategoryById
    2018-12-10 10:13:25  Adding procedure spDcGetCategoryByName
    2018-12-10 10:13:25  Adding procedure spDcGetCategories
    2018-12-10 10:13:25  Adding procedure spDcSetSyncStatus
    2018-12-10 10:13:25  Adding procedure spDcDeleteCategory
    2018-12-10 10:13:25  Adding procedure spDcGetTargetIdForComputer
    2018-12-10 10:13:25  Reestablishing database connection...
    2018-12-10 10:13:25  Configuring database...
    2018-12-10 10:13:25  Writing settings...
    2018-12-10 10:13:25  Settings set
    2018-12-10 10:13:25  Creating logins...
    2018-12-10 10:13:25  Fetching machine account info
    2018-12-10 10:13:26  Found principal
    2018-12-10 10:13:26  Found account
    2018-12-10 10:13:26  Got binary SID
    2018-12-10 10:13:26  Setting content location...
    2018-12-10 10:13:26  Fetching ContentDir from registry store
    2018-12-10 10:13:26  Value is F:\WSUSUpdates
    2018-12-10 10:13:26  Swtching DB to multi-user mode......
    2018-12-10 10:13:27  Finished setting multi-user mode
    2018-12-10 10:13:27  Writing DB settings to registry...
    2018-12-10 10:13:27  Disposing Connection
    2018-12-10 10:13:27  Clearing Connection Pools
    2018-12-10 10:13:27  Marking PostInstall done for UpdateServices-Database in the registry...
    2018-12-10 10:13:27  Starting service W3SVC
    2018-12-10 10:13:28  Configuring IIS...
    2018-12-10 10:13:28  Start: ConfigureWebsite
    2018-12-10 10:13:28  Configuring website on port 8530
    2018-12-10 10:14:03  System.Runtime.InteropServices.COMException (0x800710D8): The object identifier does not represent a valid object. (Exception from HRESULT: 0x800710D8)
       at Microsoft.Web.Administration.Interop.IAppHostMethodInstance.Execute()
       at Microsoft.Web.Administration.ConfigurationElement.ExecuteMethod(String methodName)
       at Microsoft.Web.Administration.ApplicationPool.Recycle()
       at Microsoft.UpdateServices.Administration.UseCustomWebSite.CreateWebsite(Int32 newPortNumber)
       at Microsoft.UpdateServices.Administration.PostInstall.ConfigureWebsite(Int32 portNumber)
       at Microsoft.UpdateServices.Administration.PostInstall.Run()
       at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)
    

    in progress, any idea?

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    4 hours 51 minutes ago
  • Hello,

    I started manually the WsusPool in IIS Manager then rerun the PostInstall..

    PS C:\Program Files\Update Services\Tools> .\Wsusutil.exe postinstall SQL_INSTANCE_NAME=”VRPSCCMSQL01\ConfigMgr” CONTENT_DIR=”F:\WSUSUpdates”
    Log file is located at C:\Users\rmppqx\AppData\Local\Temp\tmp78DE.tmp
    Post install is starting
    Post install has successfully completed
    

    2018-12-10 10:32:52  Postinstall started
    2018-12-10 10:32:52  Detected role services: Api, Database, UI, Services
    2018-12-10 10:32:52  Start: LoadSettingsFromParameters
    2018-12-10 10:32:52  Content local is: True
    2018-12-10 10:32:52  Content directory is: F:\WSUSUpdates
    2018-12-10 10:32:52  SQL instname is: VRPSCCMSQL01\ConfigMgr
    2018-12-10 10:32:52  End: LoadSettingsFromParameters
    2018-12-10 10:32:52  Start: Run
    2018-12-10 10:32:52  Fetching WsusAdministratorsSid from registry store
    2018-12-10 10:32:52  Value is S-1-5-21-3958249549-1187530241-1261074650-1006
    2018-12-10 10:32:52  Fetching WsusReportersSid from registry store
    2018-12-10 10:32:52  Value is S-1-5-21-3958249549-1187530241-1261074650-1007
    2018-12-10 10:32:52  Configuring content directory...
    2018-12-10 10:32:52  Configuring groups...
    2018-12-10 10:32:52  Starting group configuration for WSUS Administrators...
    2018-12-10 10:32:52  Found group in regsitry, attempting to use it...
    2018-12-10 10:32:55  Writing group to registry...
    2018-12-10 10:32:55  Finished group creation
    2018-12-10 10:32:55  Starting group configuration for WSUS Reporters...
    2018-12-10 10:32:55  Found group in regsitry, attempting to use it...
    2018-12-10 10:32:55  Writing group to registry...
    2018-12-10 10:32:55  Finished group creation
    2018-12-10 10:32:55  Configuring permissions...
    2018-12-10 10:32:55  Fetching content directory...
    2018-12-10 10:32:55  Fetching ContentDir from registry store
    2018-12-10 10:32:55  Value is F:\WSUSUpdates
    2018-12-10 10:32:55  Fetching group SIDs...
    2018-12-10 10:32:55  Fetching WsusAdministratorsSid from registry store
    2018-12-10 10:32:55  Value is S-1-5-21-3958249549-1187530241-1261074650-1006
    2018-12-10 10:32:55  Fetching WsusReportersSid from registry store
    2018-12-10 10:32:55  Value is S-1-5-21-3958249549-1187530241-1261074650-1007
    2018-12-10 10:32:55  Creating group principals...
    2018-12-10 10:32:55  Granting directory permissions...
    2018-12-10 10:32:55  Granting permissions on content directory...
    2018-12-10 10:32:55  Granting registry permissions...
    2018-12-10 10:32:55  Granting registry permissions...
    2018-12-10 10:32:55  Granting registry permissions...
    2018-12-10 10:32:55  Configuring shares...
    2018-12-10 10:32:55  Configuring network shares...
    2018-12-10 10:32:55  Fetching content directory...
    2018-12-10 10:32:55  Fetching ContentDir from registry store
    2018-12-10 10:32:55  Value is F:\WSUSUpdates
    2018-12-10 10:32:55  Fetching WSUS admin SID...
    2018-12-10 10:32:55  Fetching WsusAdministratorsSid from registry store
    2018-12-10 10:32:55  Value is S-1-5-21-3958249549-1187530241-1261074650-1006
    2018-12-10 10:32:55  Content directory is local, creating content shares...
    2018-12-10 10:32:55  Creating share "UpdateServicesPackages" with path "F:\WSUSUpdates\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
    2018-12-10 10:32:55  Deleting existing share...
    2018-12-10 10:32:55  Creating share...
    2018-12-10 10:32:55  Share successfully created
    2018-12-10 10:32:55  Creating share "WsusContent" with path "F:\WSUSUpdates\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2018-12-10 10:32:55  Deleting existing share...
    2018-12-10 10:32:55  Creating share...
    2018-12-10 10:32:55  Share successfully created
    2018-12-10 10:32:55  Creating share "WSUSTemp" with path "C:\Program Files\Update Services\LogFiles\WSUSTemp" and description "A network share used by Local Publishing from a Remote WSUS Console Instance."
    2018-12-10 10:32:55  Deleting existing share...
    2018-12-10 10:32:55  Creating share...
    2018-12-10 10:32:55  Share successfully created
    2018-12-10 10:32:55  Finished creating content shares
    2018-12-10 10:32:55  Stopping service WSUSService
    2018-12-10 10:32:55  Stopping service W3SVC
    2018-12-10 10:34:27  Configuring database...
    2018-12-10 10:34:27  Configuring the database...
    2018-12-10 10:34:27  Establishing DB connection...
    2018-12-10 10:34:27  Checking to see if database exists...
    2018-12-10 10:34:27  Database exists
    2018-12-10 10:34:27  Switching database to single user mode...
    2018-12-10 10:34:30  Loading install type query...
    2018-12-10 10:34:30  DECLARE @currentDBVersion       int
    DECLARE @scriptMajorVersion     int = (14393)
    DECLARE @scriptMinorVersion     int = (0)
    DECLARE @databaseMajorVersion   int 
    DECLARE @databaseMinorVersion   int 
    DECLARE @databaseBuildNumber    nvarchar(10)
    IF NOT EXISTS(SELECT * FROM sys.databases WHERE name='SUSDB')
    BEGIN
        SELECT 1
    END
    ELSE
    BEGIN
        SET @currentDBVersion = (SELECT SchemaVersion FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
        SET @databaseBuildNumber = (SELECT BuildNumber FROM SUSDB.dbo.tbSchemaVersion WHERE ComponentName = 'CoreDB')
        DECLARE @delimiterPosition INT = CHARINDEX('.', @databaseBuildNumber)
        IF (@delimiterPosition = 0)
        BEGIN
            RAISERROR('Invalid schema version number', 16, 1) with nowait
            return 
        END 
        SET @databaseMajorVersion = SUBSTRING(@databaseBuildNumber, 1, @delimiterPosition - 1)
        SET @databaseMinorVersion = SUBSTRING(@databaseBuildNumber, (@delimiterPosition + 1), (10 - @delimiterPosition))
        IF @currentDBVersion < 926
        BEGIN
            SELECT 3
        END
        ELSE
        BEGIN
            IF (@scriptMajorVersion > @databaseMajorVersion OR
               (@scriptMajorVersion = @databaseMajorVersion AND @scriptMinorVersion > @databaseMinorVersion))
            BEGIN
                SELECT 2
            END
            ELSE IF (@scriptMajorVersion = @databaseMajorVersion AND
                     @scriptMinorVersion = @databaseMinorVersion)
            BEGIN
                SELECT 0
            END
            ELSE
            BEGIN
                SELECT 4
            END
        END
    END
    
    2018-12-10 10:34:30  Install type is: Reinstall
    2018-12-10 10:34:30  Creating logins...
    2018-12-10 10:34:30  Fetching machine account info
    2018-12-10 10:34:30  Found principal
    2018-12-10 10:34:30  Found account
    2018-12-10 10:34:30  Got binary SID
    2018-12-10 10:34:30  Setting content location...
    2018-12-10 10:34:30  Fetching ContentDir from registry store
    2018-12-10 10:34:30  Value is F:\WSUSUpdates
    2018-12-10 10:34:30  Swtching DB to multi-user mode......
    2018-12-10 10:34:30  Finished setting multi-user mode
    2018-12-10 10:34:30  Writing DB settings to registry...
    2018-12-10 10:34:30  Disposing Connection
    2018-12-10 10:34:30  Clearing Connection Pools
    2018-12-10 10:34:30  Marking PostInstall done for UpdateServices-Database in the registry...
    2018-12-10 10:34:30  Starting service W3SVC
    2018-12-10 10:34:30  Configuring IIS...
    2018-12-10 10:34:30  Start: ConfigureWebsite
    2018-12-10 10:34:31  Configuring website on port 8530
    2018-12-10 10:35:05  2018-12-10 10:13:39  Info      IISCustomAction    Performing Setup Action, Command /Install 
    2018-12-10 10:14:02  Info      IISCustomAction    Command /Install Succeeded
    2018-12-10 10:34:41  Info      IISCustomAction    Performing Setup Action, Command /Install 
    2018-12-10 10:35:04  Info      IISCustomAction    Command /Install Succeeded
    
    2018-12-10 10:35:05  End: ConfigureWebsite
    2018-12-10 10:35:05  Configuring performance counters...
    2018-12-10 10:35:05  Configuring Stats.NET perf counter...
    2018-12-10 10:35:05  Configuring reporting perf counter...
    2018-12-10 10:35:05  Configuring client webservice perf counter...
    2018-12-10 10:35:05  Configuring server sync webservice perf counter...
    2018-12-10 10:35:05  Configuring API remoting perf counter...
    2018-12-10 10:35:05  Bringing services online...
    2018-12-10 10:35:05  Checking initialization status... 
    2018-12-10 10:35:05  Database needs initialization.
    2018-12-10 10:35:05  StartServer starting...
    2018-12-10 10:35:05  Generating encryption key to write to the registry...
    2018-12-10 10:35:05  Generating encryption key to write to the database...
    2018-12-10 10:35:05  Generating encryption key succeeded...
    2018-12-10 10:35:05  Setting WSUSService to autostart...
    2018-12-10 10:35:05  WSUSService is set to autostart.
    2018-12-10 10:35:05  Starting WSUSService...
    2018-12-10 10:35:05  WSUSService is now started.
    2018-12-10 10:35:05  Importing default detectoids.
    2018-12-10 10:35:05  Importing CriticalUpdates.xml...
    2018-12-10 10:35:06  Importing Drivers.xml...
    2018-12-10 10:35:06  Importing DriverSets.xml...
    2018-12-10 10:35:06  Importing FeaturePacks.xml...
    2018-12-10 10:35:06  Importing MicrosoftCorporation.xml...
    2018-12-10 10:35:06  Importing SecurityUpdates.xml...
    2018-12-10 10:35:06  Importing ServicePacks.xml...
    2018-12-10 10:35:07  Importing Tools.xml...
    2018-12-10 10:35:07  Importing UpdateRollups.xml...
    2018-12-10 10:35:07  Importing Updates.xml...
    2018-12-10 10:35:07  Importing Windows.xml...
    2018-12-10 10:35:07  Importing Windows2000family.xml...
    2018-12-10 10:35:07  Importing WindowsServer2003DatacenterEdition.xml...
    2018-12-10 10:35:07  Importing WindowsServer2003Family.xml...
    2018-12-10 10:35:07  Importing WindowsXPfamily.xml...
    2018-12-10 10:35:07  Importing LocalPublisher.xml...
    2018-12-10 10:35:07  Importing LocallyPublishedPackages.xml...
    2018-12-10 10:35:07  Importing Applications.xml...
    2018-12-10 10:35:07  Importing Exchange.xml...
    2018-12-10 10:35:07  Importing Office.xml...
    2018-12-10 10:35:07  Importing SQL.xml...
    2018-12-10 10:35:07  Importing Exchange2000Server.xml...
    2018-12-10 10:35:07  Importing ExchangeServer2003.xml...
    2018-12-10 10:35:07  Importing OfficeXP.xml...
    2018-12-10 10:35:07  Importing Office2003.xml...
    2018-12-10 10:35:07  Importing SQLServer.xml...
    2018-12-10 10:35:07  Importing WindowsXP64BitEditionVersion2003.xml...
    2018-12-10 10:35:07  Importing DefinitionUpdateSusXml.xml...
    2018-12-10 10:35:08  Importing ClientServicingApiDetectoid.xml...
    2018-12-10 10:35:08  Importing default detectoids succeeded.
    2018-12-10 10:35:08  Creating default subscription.
    2018-12-10 10:35:08  Instantiating UpdateServer
    2018-12-10 10:35:10  Calling GetConfiguration
    2018-12-10 10:35:14  Instantiating Subscription
    2018-12-10 10:35:14  Instantiating UpdateCategoryCollection
    2018-12-10 10:35:14  Adding Windows Category
    2018-12-10 10:35:14  Instantiating UpdateClassificationCollection
    2018-12-10 10:35:14  Adding Critical Updates classification
    2018-12-10 10:35:14  Adding Security Updates classification
    2018-12-10 10:35:14  Adding Definition Updates classification
    2018-12-10 10:35:14  Set subscription values
    2018-12-10 10:35:14  Saving Subscription
    2018-12-10 10:35:14  Creating default subscription succeeded.
    2018-12-10 10:35:14  Populating Auto-Approval Rules.
    2018-12-10 10:35:15  Populating Auto-Approval Rules Succeeded.
    2018-12-10 10:35:15  StartServer completed successfully.
    2018-12-10 10:35:15  Marking PostInstall done for UpdateServices-Services in the registry...
    2018-12-10 10:35:15  Mark initialization done in database...
    2018-12-10 10:35:15  End: Run
    2018-12-10 10:35:15  Postinstall completed

    It works...

    Thanks,
    Dom


    Security / System Center Configuration Manager Current Branch / SQL



    • Edited by Felyjos 4 hours 24 minutes ago
    4 hours 29 minutes ago
  • Hello,

    So now that WSUS has been reinstalled what should I verify/confirm?

    - Cleanup to be in place for a monthly run?

    - Software Update Point to be reinstalled?

    - Launch Synchronization in SCCM?

    Thanks,
    Dom


    Security / System Center Configuration Manager Current Branch / SQL

    4 hours 11 minutes ago