locked
KB3159706 with manual steps followed gives System.IndexOutOfRangeException -- Index was outside the bounds of the array RRS feed

  • Question

  • We have SCCM 2012 R2 with WSUS enabled on Windows 2012. SUSDB was WID but I migrated this to a remote sql 2012 cluster.

    After applying KB3159706 and following the manual steps WSUS cannot start. Opening the console I get the error:

    The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists,

    Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.


    System.IndexOutOfRangeException -- Index was outside the bounds of the array.

    Source
    Microsoft.UpdateServices.BaseApi

    Stack Trace:
       at Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException soapException)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPGetConfiguration()
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration.Load()
       at Microsoft.UpdateServices.Internal.ClassFactory.CreateWellKnownType(Type type, Object[] args)
       at Microsoft.UpdateServices.Internal.ClassFactory.CreateInstance(Type type, Object[] args)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.set_UserSelectedCulture(String value)
       at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools.TrySetServerCulture(String culture)
       at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools.SetServerCulture()
       at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools..ctor(CultureInfo culture, IUpdateServer updateServer)
       at Microsoft.UpdateServices.UI.SnapIn.Common.ServerTools..ctor(ServerSummaryScopeNode serverSummaryScopeNode, SnapInTools snapInTools, IUpdateServer updateServer)
       at Microsoft.UpdateServices.UI.SnapIn.Scope.ServerSummaryScopeNode.ConnectToServer()
       at Microsoft.UpdateServices.UI.SnapIn.Scope.ServerSummaryScopeNode.get_ServerTools()

    This same error comes up immediately after applying the KB and stays the same after applying the manual steps described in the KB article.

    The wsusutil postinstall is immediately over and gives no errors:

    2016-05-10 16:32:04  Postinstall started
    2016-05-10 16:32:04  Detected role services: Api, UI, Services
    2016-05-10 16:32:04  Start: LoadSettingsForServicing
    2016-05-10 16:32:04  End: LoadSettingsForServicing
    2016-05-10 16:32:04  Postinstall completed

    WSUS service starts but stops intermittently.
    • Edited by Francis_D Wednesday, May 11, 2016 7:58 AM
    Wednesday, May 11, 2016 7:29 AM

Answers

  • As a way of testing I decided to bring back the SUSDB to WID from external SQL 2012. As I suspected the update and postinstallation steps now worked flawless. This is clearly an issue with external databases if you get the "index was outside of the bounds of the array" thingy.

    In my case this was the solution. For me this was all on our testenvironment so I could play with moving the database.

    • Marked as answer by Francis_D Monday, May 23, 2016 8:37 AM
    Tuesday, May 17, 2016 10:47 AM
  • Hi Francis_D,

    Have you got any progress recently, if CGS_001's reply could be of help?

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    I cannot confirm this is of any help. I solved this problem by bringing back the SUSDB from external SQL server to Windows Internal Database.
    Monday, May 23, 2016 8:26 AM

All replies

  • Same here - again a faulty MS update! Really terrible. They don't get to grips with their QA.

    Uninstalling KB3159706 fixed the issue for us...

    • Proposed as answer by 6ratgus Friday, May 13, 2016 2:19 PM
    Wednesday, May 11, 2016 8:24 AM
  • Very Similar here as well.  We too moved the SUSDB from WID to a local SQL Server 2012 SP1 Express (64bit) instance.  Since that is the only part that is a little different I am starting to think that might be the issue.  For now I have rolled back the server to a prepatched state....



    • Edited by IT Mbeya Wednesday, May 11, 2016 12:25 PM
    Wednesday, May 11, 2016 12:04 PM
  • We uninstalled KB3159706 too and now everything works again.

    Edit: I should add we did follow the manual steps in the original install of the update.


    System Windows 2012 R2, SCCM current branch, WSUS 4, and SQL 2014.
    • Edited by ConfigMatt Tuesday, June 7, 2016 3:36 PM
    Wednesday, May 11, 2016 12:56 PM
  • Thanks for the answers and confirmation (I'm not alone).

    I know that uninstalling the KB fixes WSUS again but we are planning an upgrade to SCCM 1602 and wish to deploy Windows 10 feature updates. I would like this to work :)

    Wednesday, May 11, 2016 2:12 PM
  • Hi Francis_D,

    It is suggested to open a case with Microsoft, so that more in-depth investigation can be done and you'll get more effective help.

    Here is the link:
    https://support.microsoft.com/en-us/gp/support-options-for-business

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.


    Friday, May 13, 2016 6:00 AM
  • Anne,

    I don't have access to the same information that you do; however, the statement "most people could apply the KB and make WSUS server working correctly" does not match up with what I am seeing in lots of different forums.  I personally have a WSUS only environment with local but non WID database and the patch (including the post install instruction) simply does not work correctly in our environment or lots of others.  Since it appears to be the"C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing step where the problem exists, is it possible to see the script for what this step is actually doing so that it could be debugged.

    Thanks!  

    Friday, May 13, 2016 6:40 AM
  • Hi IT Mbeya,

    >  Since it appears to be the"C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing step where the problem exits

    What is the result when you run the command, and what problem exits?

    Here is my result:

    After doing the manual steps, I can launch my WSUS console and make WSUS work.

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Proposed as answer by A.Brouzell Friday, May 13, 2016 7:35 AM
    Friday, May 13, 2016 6:49 AM
  • Anne,

    Sorry for the delay (I waited for my account to be verified so I could include images but its taking a bit longer than expected so I will post this minus the images and add the images when it gets verified). 

    Patch is applied without error...

    Computer is rebooted and then postinstall servicing is run (log file looks pretty mundane) ... 



    HTTP Activation feature is installed...


    Server rebooted in lieu of WSUS service restart. When I try and connect to console "Error: Unexpected Error" ....

    Here is the accompanying eventlog message ...

    Log Name:      Application
    Source:        Windows Server Update Services
    Date:          5/13/2016 12:00:37 PM
    Event ID:      7053
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      [redacted]
    Description:
    The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists, 

    Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.


    System.IndexOutOfRangeException -- Index was outside the bounds of the array.

    Source
    Microsoft.UpdateServices.BaseApi

    Stack Trace:
       at Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException soapException)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPGetConfiguration()
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration.Load()
       at Microsoft.UpdateServices.Internal.ClassFactory.CreateWellKnownType(Type type, Object[] args)
       at Microsoft.UpdateServices.Internal.ClassFactory.CreateInstance(Type type, Object[] args)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.set_UserSelectedCulture(String value)
       at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools.TrySetServerCulture(String culture)
       at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools.SetServerCulture()
       at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools..ctor(CultureInfo culture, IUpdateServer updateServer)
       at Microsoft.UpdateServices.UI.SnapIn.Common.ServerTools..ctor(ServerSummaryScopeNode serverSummaryScopeNode, SnapInTools snapInTools, IUpdateServer updateServer)
       at Microsoft.UpdateServices.UI.SnapIn.Scope.ServerSummaryScopeNode.ConnectToServer()
       at Microsoft.UpdateServices.UI.SnapIn.Scope.ServerSummaryScopeNode.get_ServerTools()
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Windows Server Update Services" />
        <EventID Qualifiers="0">7053</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2016-05-13T09:00:37.000000000Z" />
        <EventRecordID>18890</EventRecordID>
        <Channel>Application</Channel>
        <Computer>[redacted]</Computer>
        <Security />
      </System>
      <EventData>
        <Data>The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists, 

    Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.


    System.IndexOutOfRangeException -- Index was outside the bounds of the array.

    Source
    Microsoft.UpdateServices.BaseApi

    Stack Trace:
       at Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException soapException)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPGetConfiguration()
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServerConfiguration.Load()
       at Microsoft.UpdateServices.Internal.ClassFactory.CreateWellKnownType(Type type, Object[] args)
       at Microsoft.UpdateServices.Internal.ClassFactory.CreateInstance(Type type, Object[] args)
       at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.set_UserSelectedCulture(String value)
       at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools.TrySetServerCulture(String culture)
       at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools.SetServerCulture()
       at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools..ctor(CultureInfo culture, IUpdateServer updateServer)
       at Microsoft.UpdateServices.UI.SnapIn.Common.ServerTools..ctor(ServerSummaryScopeNode serverSummaryScopeNode, SnapInTools snapInTools, IUpdateServer updateServer)
       at Microsoft.UpdateServices.UI.SnapIn.Scope.ServerSummaryScopeNode.ConnectToServer()
       at Microsoft.UpdateServices.UI.SnapIn.Scope.ServerSummaryScopeNode.get_ServerTools()</Data>
      </EventData>
    </Event>

    Thanks again for your help!

    (Updated to add images as promised)

    • Edited by IT Mbeya Monday, May 16, 2016 5:18 AM
    Friday, May 13, 2016 10:44 AM
  • Hi IT Mbeya,

    Do you have win10 clients need updates released after May 1, 2016. If not, I would recommend un-installing the KB instead of troubleshooting.

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, May 16, 2016 3:18 AM
  • Anne,

    Unfortunately that is not a viable solution as we were early adopters of Win 10 and our clients are 100% Win 10 Pro. So sorting out the problem with this update is fairly important to myself and ethers like Francis_D.  If MS is serious about getting Win 10 on 1 billion devices in the next 1-2 years making sure that admins can actually deploy it and patch it simply and reliably should be a pretty significant goal.  It seems like an update that completely breaks that ability is a pretty significant problem. Your help sorting out this problem is greatly appreciated.

    Respectfully,

    David

     

    Monday, May 16, 2016 5:12 AM
  • Hi IT Mbeya,

    1. Check if reindex WSUS database could work:

    https://technet.microsoft.com/en-us/library/dd939795(v=ws.10).aspx

    2. If it still doesn't work, then I'm thinking if rebuilt the database could work. Backup the original database, then re-install the WSUS server.

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, May 16, 2016 9:24 AM
  • Anne,

    Unfortunately that is not a viable solution as we were early adopters of Win 10 and our clients are 100% Win 10 Pro. So sorting out the problem with this update is fairly important to myself and ethers like Francis_D.  If MS is serious about getting Win 10 on 1 billion devices in the next 1-2 years making sure that admins can actually deploy it and patch it simply and reliably should be a pretty significant goal.  It seems like an update that completely breaks that ability is a pretty significant problem. Your help sorting out this problem is greatly appreciated.

    Respectfully,

    David

    Same issue here, just noticed this morning that I was unable to connect to the WSUS console and found this thread discussing the same issue. I get the same error message and logged events as the OP.

    We're running standalone WSUS on 2012 R2. About 80% of our clients are on Windows 10 so we obviously need to be able to deploy updates to the OS.

    As a temporary solution, I've uninstalled KB3159706 from the WSUS server, so it now works properly. Waiting for Microsoft to fix this issue.

    Monday, May 16, 2016 9:57 AM
  • Anne,

    I was hopeful that reindexing the db would help but as far as I can tell there was no change. 

    Regarding rebuilding the WSUS server.  Would that involve re-downloading all of the updates? I ask because I am located in Tanzania Africa so downloading 50GB of updates again will be a quite time consuming exercise over our limited bandwidth.

    Thanks,

    David 

    Monday, May 16, 2016 11:04 AM
  • Hi David,

    could you please post what other event ids are logged under the Application log with WSUS as the source? (level: error).

    They should give us further hints.

    Best regards,

    Andrei


    We could change the world, if God would give us the source code.

    Monday, May 16, 2016 12:19 PM
  • Andrei,

    I am reverting our production WSUS after each test so that I can continue to monitor updates.  I did export a copy of the server so that I could leave it in a broken state for testing and I do see a different 7053 event and an event 507.

    Log Name:      Application
    Source:        Windows Server Update Services
    Date:          5/11/2016 9:06:02 AM
    Event ID:      7053
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      [redacted]
    Description:
    The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists, 

    Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.


    System.Collections.Generic.KeyNotFoundException -- The given key was not present in the dictionary.

    Source
    mscorlib

    Stack Trace:
       at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
       at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesListPage.GetUpdateRow(WsusUpdate update)
       at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesListPage.RefreshUpdateInfo(DataGridViewRow row, WsusUpdate update, UpdateChangeTypes changeTypes)
       at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesListPage.ListUpdatePropertiesCache_BulkUpdatePropertiesChanged(Object sender, BulkUpdatePropertiesChangedEventArgs e)
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Windows Server Update Services" />
        <EventID Qualifiers="0">7053</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2016-05-11T06:06:02.000000000Z" />
        <EventRecordID>18199</EventRecordID>
        <Channel>Application</Channel>
        <Computer>[redacted]</Computer>
        <Security />
      </System>
      <EventData>
        <Data>The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists, 

    Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.


    System.Collections.Generic.KeyNotFoundException -- The given key was not present in the dictionary.

    Source
    mscorlib

    Stack Trace:
       at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
       at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesListPage.GetUpdateRow(WsusUpdate update)
       at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesListPage.RefreshUpdateInfo(DataGridViewRow row, WsusUpdate update, UpdateChangeTypes changeTypes)
       at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesListPage.ListUpdatePropertiesCache_BulkUpdatePropertiesChanged(Object sender, BulkUpdatePropertiesChangedEventArgs e)</Data>
      </EventData>
    </Event>

    Log Name:      Application
    Source:        Windows Server Update Services
    Date:          5/15/2016 9:10:09 AM
    Event ID:      507
    Task Category: 1
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      [redacted]
    Description:
    Update Services failed its initialization and stopped.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Windows Server Update Services" />
        <EventID Qualifiers="0">507</EventID>
        <Level>2</Level>
        <Task>1</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2016-05-15T06:10:09.000000000Z" />
        <EventRecordID>18912</EventRecordID>
        <Channel>Application</Channel>
        <Computer>[redacted]</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Update Services failed its initialization and stopped.</Data>
      </EventData>
    </Event>

    Thanks

    David

    Monday, May 16, 2016 12:53 PM
  • Hi David,

    please check if you also have these other Event IDs:

    Error 13/05/16 4:49:49 PM Windows Server Update Services 12072 (9)
    Error 13/05/16 4:49:49 PM Windows Server Update Services 10012 (7)
    Error 13/05/16 4:49:49 PM Windows Server Update Services 13002 (6)
    Error 13/05/16 4:27:27 PM Windows Server Update Services 12072 (9)
    Error 13/05/16 4:27:27 PM Windows Server Update Services 10012 (7)
    Error 13/05/16 4:27:27 PM Windows Server Update Services 13002 (6)
    Information 13/05/16 4:27:13 PM Windows Server Update Services 501 (1)
    Error 13/05/16 4:25:58 PM Windows Server Update Services 507 (1)
    Error 13/05/16 4:16:42 PM Windows Server Update Services 7053 None
    Error 13/05/16 4:16:42 PM Windows Server Update Services 7053 None

    If not, then try the following to start "fresh" with the WSUS Console:

    1. Net stop wsusservice.

    2. Delete the wsus file under %appdata%\Microsoft\MMC\.

    3. Start MMC and load the Update Services snap-in.

    Start the console and once it fails, check for the other event IDs again.

    Thanks,

    Andrei


    We could change the world, if God would give us the source code.


    Monday, May 16, 2016 1:10 PM
  • I ran it again on my production WSUS and I get the 7053 errors only ....

    Not sure if it matters but for step 4 I restarted the  wsusservice service and checked for more events.

    I also realized I have never included the postinstall log (in case it is helpful I will include it here)

    2016-05-16 16:22:09  Postinstall started
    2016-05-16 16:22:09  Detected role services: Api, UI, Services
    2016-05-16 16:22:09  Start: LoadSettingsForServicing
    2016-05-16 16:22:09  End: LoadSettingsForServicing
    2016-05-16 16:22:09  Stopping service WSUSService
    2016-05-16 16:22:09  Stopping service W3SVC
    2016-05-16 16:23:40  Starting service W3SVC
    2016-05-16 16:23:40  Starting service WSUSService
    2016-05-16 16:23:40  Postinstall completed

    Thanks

    David

    Monday, May 16, 2016 1:36 PM
  • Could you upload the c:\program files\update services\logfiles\softwaredistribution.log somewhere so I can take a look for additional errors?

    Thanks,

    Andrei


    We could change the world, if God would give us the source code.

    Monday, May 16, 2016 1:43 PM
  • Andrei,

    If you could email me [burner(dot)email(at)sil(dot)org] from you MSFT email address I will send you a link to the log file.  In the mean time I am going to start setting up a new wsus server.

    Thanks again for your help!

    David 

    Tuesday, May 17, 2016 5:11 AM
  • So I setup the temp WSUS server and the patch applied just fine (to a clean WSUS using WID), but I was struck by how different the Post install log looks when it works versus when it doesn't.  It may be running the same SQL script either way but the fact that it is non-existent in the one log and clearly shown it the other seems very strange.  Both Logs are bellow.

    PostInstall from non-working WSUS w/ non WID db

    2016-05-16 16:22:09  Postinstall started
    2016-05-16 16:22:09  Detected role services: Api, UI, Services
    2016-05-16 16:22:09  Start: LoadSettingsForServicing
    2016-05-16 16:22:09  End: LoadSettingsForServicing
    2016-05-16 16:22:09  Stopping service WSUSService
    2016-05-16 16:22:09  Stopping service W3SVC
    2016-05-16 16:23:40  Starting service W3SVC
    2016-05-16 16:23:40  Starting service WSUSService
    2016-05-16 16:23:40  Postinstall completed

    PostInstall from working WSUS w/ WID db

    2016-05-17 09:55:32  Postinstall started
    2016-05-17 09:55:32  Detected role services: Api, UI, WidDatabase, Services
    2016-05-17 09:55:33  Start: LoadSettingsForServicing
    2016-05-17 09:55:33  WID instance name: MICROSOFT##WID
    2016-05-17 09:55:33  End: LoadSettingsForServicing
    2016-05-17 09:55:33  Stopping service WSUSService
    2016-05-17 09:55:33  Stopping service W3SVC
    2016-05-17 09:55:33  Servicing WID database...
    2016-05-17 09:55:33  Servicing the database...
    2016-05-17 09:55:33  Establishing DB connection...
    2016-05-17 09:55:33  Checking to see if database exists...
    2016-05-17 09:55:33  Database exists
    2016-05-17 09:55:33  Switching database to single user mode...
    2016-05-17 09:55:34  Loading install type query...
    2016-05-17 09:55:34  DECLARE @currentDBVersion       int
    DECLARE @scriptMajorVersion     int = (9600)
    DECLARE @scriptMinorVersion     int = (18324)
    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

    2016-05-17 09:55:34  Install type is: Upgrade
    2016-05-17 09:55:34  Creating database...
    2016-05-17 09:55:35  Changed database context to 'SUSDB'.
    2016-05-17 09:55:36  Changed database context to 'SUSDB'.
    2016-05-17 09:55:36  Creating Procedures spDropForeignKeyConstraint
    2016-05-17 09:55:36  Adding function spDropTableColumnIfExists
    2016-05-17 09:55:36  Adding function spAddTableColumnIfNotExists
    2016-05-17 09:55:36  Adding function spDropPrimaryKeyConstraint
    2016-05-17 09:55:36  Creating table dbo.tbPrerequisiteDependency
    2016-05-17 09:55:36  Creating table dbo.tbBundleDependency
    2016-05-17 09:55:36  Creating table tbUpdateStatusPerComputer
    2016-05-17 09:55:37  Creating table tbUpdateSummaryForAllComputers
    2016-05-17 09:55:37  Creating table tbComputerSummaryForMicrosoftUpdates
    2016-05-17 09:55:37  Creating table dbo.tbRequestedTargetGroup
    2016-05-17 09:55:37  Creating table dbo.tbRequestedTargetGroupsForTarget
    2016-05-17 09:55:37  Creating table tbDeletedComputer
    2016-05-17 09:55:37  Creating table dbo.tbComputerTargetDetail
    2016-05-17 09:55:37  Creating table dbo.tbComputerTarget
    2016-05-17 09:55:41  upgrading tbComputerTarget, moving columns to tbComputerTargetDetail
    2016-05-17 09:55:41  Creating table dbo.tbClientWithRecentNameChange
    2016-05-17 09:55:41  Creating table dbo.tbDownstreamServerTarget
    2016-05-17 09:55:41  Creating table dbo.tbDownstreamServerSummaryRollup
    2016-05-17 09:55:41  Creating table dbo.tbDownstreamServerClientSummaryRollup
    2016-05-17 09:55:41  Creating table dbo.tbDownstreamServerClientActivityRollup
    2016-05-17 09:55:41  Creating table dbo.tbTarget
    2016-05-17 09:55:41  Creating table dbo.tbTargetType
    2016-05-17 09:55:41  Creating table dbo.tbDeployment
    2016-05-17 09:55:42  tbDeployment exists, updating it
    2016-05-17 09:55:42  Creating table dbo.tbDeadDeployment
    2016-05-17 09:55:42  Creating table dbo.tbRevisionLanguage
    2016-05-17 09:55:42  Creating table dbo.tbProperty
    2016-05-17 09:55:42  Creating table dbo.tbRevisionExtendedProperty
    2016-05-17 09:55:42  Creating table dbo.tbKBArticleForRevision
    2016-05-17 09:55:42  Creating table dbo.tbMoreInfoURLForRevision
    2016-05-17 09:55:42  Creating table dbo.tbSecurityBulletinForRevision
    2016-05-17 09:55:43  Creating table dbo.tbLocalizedPropertyForRevision
    2016-05-17 09:55:43  Creating table dbo.tbFileForRevision
    2016-05-17 09:55:43  Creating table dbo.tbFileHash
    2016-05-17 09:55:43  Creating table dbo.tbRevisionSupersedesUpdate
    2016-05-17 09:55:43  Creating table dbo.tbInstalledUpdateSufficientForPrerequisite
    2016-05-17 09:55:43  Creating table dbo.tbBundleAtLeastOne
    2016-05-17 09:55:43  Creating table dbo.tbBundleAll
    2016-05-17 09:55:43  Creating table dbo.tbPrerequisite
    2016-05-17 09:55:43  Creating table dbo.tbDriver
    2016-05-17 09:55:43  Creating table dbo.tbCompatiblePrinterProvider
    2016-05-17 09:55:43  Creating table dbo.tbDriverClass
    2016-05-17 09:55:43  Creating table dbo.tbTargetGroup
    2016-05-17 09:55:43  Creating table dbo.tbFlattenedTargetGroup
    2016-05-17 09:55:43  Creating table dbo.tbTargetGroupType
    2016-05-17 09:55:43  Creating table dbo.tbExpandedTargetInTargetGroup
    2016-05-17 09:55:43  Creating table dbo.tbTargetInTargetGroup
    2016-05-17 09:55:43  Inserting into dbo.tbExpandedTargetInTargetGroup during upgrade of dbo.tbTargetInTargetGroup
    2016-05-17 09:55:43  Creating table dbo.tbEulaProperty
    2016-05-17 09:55:43  Creating table dbo.tbEulaAcceptance
    2016-05-17 09:55:43  Creating table dbo.tbLocalizedProperty
    2016-05-17 09:55:43  Creating table dbo.tbFile
    2016-05-17 09:55:43  Creating table dbo.tbXml
    2016-05-17 09:55:43  Creating table dbo.tbGroupAuthorization
    2016-05-17 09:55:43  Creating table dbo.tbAuthorization
    2016-05-17 09:55:43  Creating table dbo.tbFileOnServer
    2016-05-17 09:55:44  Creating table dbo.tbFileDownloadProgress
    2016-05-17 09:55:44  Creating table dbo.tbSingletonData
    2016-05-17 09:55:44  Creating table dbo.tbReference
    2016-05-17 09:55:44  Creating table dbo.tbFrontEndServersHealth
    2016-05-17 09:55:44  Creating table dbo.tbConfigurationC
    2016-05-17 09:55:44  Creating table dbo.tbConfigurationB
    2016-05-17 09:55:44  Creating table dbo.tbConfigurationA
    2016-05-17 09:55:44  Creating table dbo.tbConfiguration
    2016-05-17 09:55:44  Creating table dbo.tbImplicitCategory
    2016-05-17 09:55:44  Creating table dbo.tbCategoryInSubscription
    2016-05-17 09:55:44  Creating table dbo.tbLanguageInSubscription
    2016-05-17 09:55:44  Creating table dbo.tbSchedule
    2016-05-17 09:55:44  Creating table dbo.tbEmailNotificationRecipient
    2016-05-17 09:55:44  Creating table dbo.tbRevisionInCategory
    2016-05-17 09:55:44  Creating table dbo.tbCategory
    2016-05-17 09:55:44  Creating table dbo.tbRevision
    2016-05-17 09:55:44  Creating table dbo.tbRevisionExtendedLanguageMask
    2016-05-17 09:55:44  Creating table dbo.tbUpdate
    2016-05-17 09:55:44  Creating table dbo.tbUpdateType
    2016-05-17 09:55:44  Creating table dbo.tbUpdateFlag
    2016-05-17 09:55:44  Creating table dbo.tbHandler
    2016-05-17 09:55:44  Creating table dbo.tbLanguage
    2016-05-17 09:55:44  Creating table dbo.tbCategoryType
    2016-05-17 09:55:44  Creating table dbo.tbStateMachine
    2016-05-17 09:55:44  Creating table dbo.tbStateMachineState
    2016-05-17 09:55:44  Creating table dbo.tbStateMachineEvent
    2016-05-17 09:55:44  Creating table dbo.tbStateMachineTransition
    2016-05-17 09:55:44  Creating table dbo.tbStateMachineEventTransitionLog
    2016-05-17 09:55:44  Adding View vwStateMachineEventTransitionLog
    2016-05-17 09:55:44  Creating table dbo.tbNotificationEvent
    2016-05-17 09:55:44  Creating table dbo.tbChangeTracking
    2016-05-17 09:55:44  Creating table dbo.tbFlattenedRevisionInCategory
    2016-05-17 09:55:44  Creating table dbo.tbServerSyncResult
    2016-05-17 09:55:44  Creating table dbo.tbAutoDeploymentRule
    2016-05-17 09:55:44  Creating table dbo.tbUpdateClassificationInAutoDeploymentRule
    2016-05-17 09:55:44  Creating table dbo.tbCategoryInAutoDeploymentRule
    2016-05-17 09:55:44  Creating table dbo.tbTargetGroupInAutoDeploymentRule
    2016-05-17 09:55:44  Creating table dbo.tbSchemaVersion
    2016-05-17 09:55:44  Creating table dbo.tbSchemaVersionHistory
    2016-05-17 09:55:44  Creating table dbo.tbServerHealth
    2016-05-17 09:55:44  Creating table dbo.tbProgramKeys
    2016-05-17 09:55:44  Creating table tbComputersThatNeedDetailedRollup
    2016-05-17 09:55:45  Adding indexed view ivwApiUpdateRevision
    2016-05-17 09:55:45  Creating Procedure spAddConstraint
    2016-05-17 09:55:45  executing stored PROCEDURE spAddConstraint
    2016-05-17 09:55:46  Adding FUNCTION fn_GetGrade 
    2016-05-17 09:55:46  Adding FUNCTION fnGetOnlineSummaryFlags
    2016-05-17 09:55:46  Adding PROCEDURE spUpdateChangeTrackingNumber
    2016-05-17 09:55:46  Creating PROCEDURE spUpdateChangeTrackingNumber
    2016-05-17 09:55:46  Adding Trigger trOnUpdatingConfiguration
    2016-05-17 09:55:46  Adding Trigger trOnInsertingUpdateStatus
    2016-05-17 09:55:46  Adding Trigger trOnDeletingUpdateStatus
    2016-05-17 09:55:46  Adding Trigger trOnUpdatingUpdateStatus
    2016-05-17 09:55:46  Adding FUNCTION fn_GetBestRevisionForEvaluateDeployment
    2016-05-17 09:55:46  Adding PROCEDURE spMoveEvaluateDeploymentsAsNeeded
    2016-05-17 09:55:46  Adding PROCEDURE spDeleteUneededPrerequisiteDeployments
    2016-05-17 09:55:46  Adding PROCEDURE spDeleteUneededBundleDeployments
    2016-05-17 09:55:46  Adding PROCEDURE spProcessPrerequisitesForRevision
    2016-05-17 09:55:46  Adding TRIGGER trOnUpdatingRevision
    2016-05-17 09:55:46  Adding TRIGGER trOnUpdatingDeployment
    2016-05-17 09:55:47  Adding TRIGGER trOnAddingDeployment
    2016-05-17 09:55:47  Adding PROCEDURE spGetUpdateThrottlingSettings
    2016-05-17 09:55:47  Creating PROCEDURE spGetUpdateThrottlingSettings
    2016-05-17 09:55:47  Adding Trigger trOnDeletingDeployment
    2016-05-17 09:55:47  Adding trigger trAdjustIsLeaf_reduce 
    2016-05-17 09:55:47  Adding trigger trAdjustPrerequisite 
    2016-05-17 09:55:47  Adding triggers trExpandRevisionInCategory 
    2016-05-17 09:55:47  Adding triggers trExpandFlattenedRevisionInCategory 
    2016-05-17 09:55:47  Adding triggers trExpandRevisionLanguage 
    2016-05-17 09:55:47  Adding triggers trAdjustIsLeaf_increase 
    2016-05-17 09:55:47  Adding trigger trOnAddingUpdatingGroupAuthorization
    2016-05-17 09:55:48  Adding trigger trOnDeletingGroupAuthorization
    2016-05-17 09:55:48  Adding trigger trOnAddingUpdatingAuthorization
    2016-05-17 09:55:48  Adding trigger trOnDeletingAuthorization
    2016-05-17 09:55:48  Adding trigger trOnAddingLanguage
    2016-05-17 09:55:48  Adding trigger trOnChangingLanguage
    2016-05-17 09:55:48  Adding trigger trOnDeletingLanguage
    2016-05-17 09:55:48  Adding trigger trOnAddingDriver
    2016-05-17 09:55:48  Adding trigger trOnDeletingDriver
    2016-05-17 09:55:48  Adding trigger tr_insert_ExpandedTargetInTargetGroup
    2016-05-17 09:55:48  Adding trigger tr_delete_ExpandedTargetInTargetGroup
    2016-05-17 09:55:48  Adding FUNCTION fn_later_date 
    2016-05-17 09:55:49  Adding PROCEDURE spSaveXmlFragment 
    2016-05-17 09:55:49  Creating Procedure spSaveXmlFragment
    2016-05-17 09:55:49  Adding PROCEDURE spGetChildCategories 
    2016-05-17 09:55:49  Creating Procedure spGetChildCategories
    2016-05-17 09:55:49  Adding PROCEDURE spGetUssDeployments 
    2016-05-17 09:55:49  Creating Procedure spGetUssDeployments
    2016-05-17 09:55:49  Adding PROCEDURE spUpdateSubTimestamp 
    2016-05-17 09:55:49  Creating Procedure spUpdateSubTimestamp
    2016-05-17 09:55:49  Adding PROCEDURE spPopulateLanguageInSubscription 
    2016-05-17 09:55:49  Creating Procedure spPopulateLanguageInSubscription
    2016-05-17 09:55:49  Adding PROCEDURE spAddNewLanguage 
    2016-05-17 09:55:49  Creating Procedure spAddNewLanguage
    2016-05-17 09:55:49  Adding PROCEDURE spCheckRevisionExists 
    2016-05-17 09:55:49  Creating Procedure spCheckRevisionExists
    2016-05-17 09:55:49  Adding PROCEDURE spCheckUpdateExists 
    2016-05-17 09:55:49  Creating Procedure spCheckUpdateExists
    2016-05-17 09:55:49  Adding PROCEDURE spGetFilter 
    2016-05-17 09:55:49  Creating procedure spUpdateOnlineSummaryTablesForUpdateVisible
    2016-05-17 09:55:49  Creating procedure spUpdateOnlineSummaryTablesForUpdateNotVisible
    2016-05-17 09:55:50  Creating Procedure spImportUpdate
    2016-05-17 09:55:51  Creating Procedure spDeploymentAutomation
    2016-05-17 09:55:51  Creating Procedure spSetInitialDeploymentStatus
    2016-05-17 09:55:51  Creating Procedure spImportUpdateForServerSync
    2016-05-17 09:55:51  Adding FUNCTION fn_FormatError 
    2016-05-17 09:55:51  Adding FUNCTION fn_FormatLog 
    2016-05-17 09:55:51  Adding FUNCTION fn_BuildDeploymentMessage
    2016-05-17 09:55:51  Creating Procedure spSelectProcFortbNotificationEvent
    2016-05-17 09:55:51  Creating Procedure spUpdateProcFortbNotificationEvent
    2016-05-17 09:55:51  Creating Procedure spSelectProcFortbSubscription
    2016-05-17 09:55:51  Creating Procedure spUpdateProcFortbSubscription
    2016-05-17 09:55:51  Creating Procedure spSelectProcFortbRevision
    2016-05-17 09:55:51  Creating Procedure spUpdateProcFortbRevision
    2016-05-17 09:55:51  Creating Procedure spSelectProcFortbFileOnServerDesired
    2016-05-17 09:55:51  Creating Procedure spUpdateProcFortbFileOnServerDesired
    2016-05-17 09:55:52  Creating Procedure spSelectProcFortbFileOnServerActual
    2016-05-17 09:55:52  Creating Procedure spUpdateProcFortbFileOnServerActual
    2016-05-17 09:55:52  Creating Procedure spFireStateMachineEventEx
    2016-05-17 09:55:52  Creating Procedure spFireStateMachineEvent
    2016-05-17 09:55:52  Adding PROCEDURE spGetNotificationEventItem
    2016-05-17 09:55:52  Creating Procedure spGetNotificationEventItem
    2016-05-17 09:55:52  Adding PROCEDURE spGetNotificationEventNamesToWakeUp
    2016-05-17 09:55:52  Creating PROCEDURE spGetNotificationEventNamesToWakeUp
    2016-05-17 09:55:52  Adding PROCEDURE spGetNotificationEventNamesToWakeUpOnStartup
    2016-05-17 09:55:52  Creating PROCEDURE spGetNotificationEventNamesToWakeUpOnStartup
    2016-05-17 09:55:52  Adding PROCEDURE spCleanupIntermediateFileStatesOnStartup
    2016-05-17 09:55:52  Creating PROCEDURE spCleanupIntermediateFileStatesOnStartup
    2016-05-17 09:55:52  Adding PROCEDURE spStartCatalogSync
    2016-05-17 09:55:52  Creating Procedure spStartCatalogSync
    2016-05-17 09:55:52  Adding PROCEDURE spCancelCatalogSync
    2016-05-17 09:55:52  Creating Procedure spCancelCatalogSync
    2016-05-17 09:55:52  Adding PROCEDURE spSetHandshakeAnchor
    2016-05-17 09:55:52  Creating Procedure spSetHandshakeAnchor
    2016-05-17 09:55:52  Adding PROCEDURE spResetNotificationState
    2016-05-17 09:55:52  Creating Procedure spResetNotificationState
    2016-05-17 09:55:52  Adding PROCEDURE spGetLocalIdList 
    2016-05-17 09:55:52  Creating Procedure spGetLocalIdList
    2016-05-17 09:55:52  Adding PROCEDURE spQueueCatalogSyncRequest
    2016-05-17 09:55:52  Creating Procedure spQueueCatalogSyncRequest
    2016-05-17 09:55:52  Adding PROCEDURE spGetSubscriptionProgress
    2016-05-17 09:55:52  Creating Procedure spGetSubscriptionProgress
    2016-05-17 09:55:53  Adding PROCEDURE spSetSubscriptionProgress
    2016-05-17 09:55:53  Creating Procedure spSetSubscriptionProgress
    2016-05-17 09:55:53  Adding PROCEDURE spSetCatalogSyncFail
    2016-05-17 09:55:53  Creating Procedure spSetCatalogSyncFail
    2016-05-17 09:55:53  Adding PROCEDURE spNotifySyncCancel
    2016-05-17 09:55:53  Creating Procedure spNotifySyncCancel
    2016-05-17 09:55:53  Adding PROCEDURE spSyncWorkDone
    2016-05-17 09:55:53  Creating Procedure spSyncWorkDone
    2016-05-17 09:55:53  Adding PROCEDURE spGetNextQueuedSubscription
    2016-05-17 09:55:53  Creating Procedure spGetNextQueuedSubscription
    2016-05-17 09:55:53  Adding PROCEDURE spGetSubscriptionState
    2016-05-17 09:55:53  Creating Procedure spGetSubscriptionState
    2016-05-17 09:55:53  Adding PROCEDURE spFixCatalogSyncStates
    2016-05-17 09:55:53  Creating Procedure spFixCatalogSyncStates
    2016-05-17 09:55:53  Creating Procedure spCancelFilesAndRelatedRevisions
    2016-05-17 09:55:53  Creating Procedure spDeactivateDeploymentsAndNotifyParentRevisionsChildNotReady
    2016-05-17 09:55:53  Creating Procedure spCheckRevisionsNeedingFile
    2016-05-17 09:55:53  Creating Procedure spNotifyFileActualStateMUUrlNeeded
    2016-05-17 09:55:54  Creating Procedure spNotifyFileActualStateDownloadNeeded
    2016-05-17 09:55:54  Creating Procedure spNotifyFileActualStateImportNeeded
    2016-05-17 09:55:54  Creating Procedure spNotifyFileActualStateNotNeeded
    2016-05-17 09:55:54  Creating Procedure spNotifyActualStateAndRevisionsFileCancelled
    2016-05-17 09:55:54  Creating Procedure spWakeUpContentAgent
    2016-05-17 09:55:54  Creating Procedure spRemoveFileFromProgress
    2016-05-17 09:55:54  Creating Procedure spRemoveFileFromProgressAndWakeUpContentAgent
    2016-05-17 09:55:54  Creating Procedure spNotifyRevisionsFileReady
    2016-05-17 09:55:54  Creating Procedure spNotifyRevisionsFileFailed
    2016-05-17 09:55:54  Creating Procedure spCheckFileDesiredState
    2016-05-17 09:55:55  Creating Procedure spCheckFileDownloadQueue
    2016-05-17 09:55:55  Creating Procedure spCheckDesiredStateAndNotifyRevisionsFileReady
    2016-05-17 09:55:55  Creating Procedure spCheckFileDownloadQueueAndNotifyRevisionsFileFailed
    2016-05-17 09:55:55  Creating Procedure spCheckDesiredStateAndNotifyRevisionsFileFailed
    2016-05-17 09:55:55  Creating Procedure spNotifyRevisionsFileNotReadyAndCheckDesiredState
    2016-05-17 09:55:55  Creating Procedure spCheckFileDownloadQueueAndRemoveFileFromProgress
    2016-05-17 09:55:55  Creating Procedure spCheckFileDownloadQueueAndDesiredState
    2016-05-17 09:55:55  Creating Procedure spUpdateQueueEntryTimeAndCheckFileDownloadQueue
    2016-05-17 09:55:55  Creating Procedure spNotifyContentSyncNotificationEventWorking
    2016-05-17 09:55:55  Creating Procedure spGetNextContentSyncWorkItem
    2016-05-17 09:55:55  Creating Procedure spGetNextContentSyncWorkItemOnStartup
    2016-05-17 09:55:55  Creating PROCEDURE spUpdateFileDownloadProgress
    2016-05-17 09:55:56  Creating Procedure spSetFileMUUrl
    2016-05-17 09:55:56  Creating Procedure spGetUpdatesForFile
    2016-05-17 09:55:56  Creating Procedure spRetrieveFileDigestFromRowID
    2016-05-17 09:55:56  Creating Procedure spNotifyEulaFilesNeeded
    2016-05-17 09:55:56  Creating Procedure spCheckRevisionInstallationPossibility
    2016-05-17 09:55:56  Creating Procedure spNotifyParentsEulasReadyAndCheckRevisionInstallationPossibility
    2016-05-17 09:55:56  Creating Procedure spCheckRevisionNeededAndNotifyParentsChildInstallationPossible
    2016-05-17 09:55:56  Adding procedure spAddDownstreamServerToTargetGroup
    2016-05-17 09:55:56  Adding procedure spPreregisterDownstreamServer
    2016-05-17 09:55:56  Adding PROCEDURE spGetDssTargetGroup 
    2016-05-17 09:55:56  Adding PROCEDURE spUpdateDownstreamServerID 
    2016-05-17 09:55:56  Adding PROCEDURE spReturnStateMachineTransitionEventLogEntriesFromError
    2016-05-17 09:55:56  Creating Procedure spReturnStateMachineTransitionEventLogEntriesFromError
    2016-05-17 09:55:56  Creating Procedure spCheckFilesAndChildRevisionsReady
    2016-05-17 09:55:56  Creating Procedure spNotifyFilesAndChildRevisionsNeeded
    2016-05-17 09:55:56  Creating Procedure spActivateDeploymentsAndNotifyParentRevisionsChildReady
    2016-05-17 09:55:56  Creating Procedure spFailParentRevisions
    2016-05-17 09:55:56  Creating Procedure spCheckEulasAndChildRevisionsReady
    2016-05-17 09:55:56  Creating Procedure spDeactivateDeploymentsNotifyFilesNotNeeded
    2016-05-17 09:55:57  Creating Procedure spResetStateMachineAndReEvaluate
    2016-05-17 09:55:57  Creating Procedures spCancelAllNotReadyRevisions
    2016-05-17 09:55:57  Creating Procedures spDownloadAllNotNeededRevisions
    2016-05-17 09:55:57  Creating Procedures spWakeUpResetAgent
    2016-05-17 09:55:57  Creating Procedures spWakeUpEmailNotificationAgent
    2016-05-17 09:55:57  Creating Procedures spNotifyResetAgentNotificationEventWorking
    2016-05-17 09:55:57  Creating Procedures spNotifyResetAgentNotificationEventDone
    2016-05-17 09:55:57  Creating Procedures spWakeUpRollupAgent
    2016-05-17 09:55:57  Creating Procedures spNotifyRollupAgentNotificationEventWorking
    2016-05-17 09:55:57  Creating Procedures spNotifyRollupAgentNotificationEventDone
    2016-05-17 09:55:57  Creating Procedures spNotifyEmailNotificationAgentNotificationEventWorking
    2016-05-17 09:55:57  Creating Procedures spNotifyEmailNotificationAgentNotificationEventDone
    2016-05-17 09:55:57  Creating Procedure spSaveUssHostOnMU
    2016-05-17 09:55:57  Creating Procedure spRetrieveUssHostOnMU
    2016-05-17 09:55:57  Creating Procedure spGetLastServerSyncCookie 
    2016-05-17 09:55:57  Creating Procedure spSetLastServerSyncCookie 
    2016-05-17 09:55:57  Creating Procedure spResetServer 
    2016-05-17 09:55:57  Creating Procedure spGetLastSyncTime 
    2016-05-17 09:55:58  Creating Procedure spSetLastSyncTime 
    2016-05-17 09:55:59  Creating Procedure spIsRegistrationRequired 
    2016-05-17 09:55:59  Creating Procedure spGetComputerTargetGroup 
    2016-05-17 09:55:59  Creating Procedure spCheckForClientNameChange 
    2016-05-17 09:55:59  Creating Procedure spGetFrontEndServers 
    2016-05-17 09:55:59  Creating Procedure spRemoveFrontEndServer 
    2016-05-17 09:55:59  Creating Procedure spGetClientsWithRecentNameChange 
    2016-05-17 09:55:59  Creating Procedure spGetComputerTargetGroupEx 
    2016-05-17 09:55:59  Adding PROCEDURE spRegisterComputer 
    2016-05-17 09:55:59  Creating Procedure spSetBatchURL
    2016-05-17 09:55:59  Creating Procedure spUpdateServerHealthStatus
    2016-05-17 09:55:59  Creating PROCEDURE spGetExportData
    2016-05-17 09:55:59  Creating Procedure spGetExportUpdateData
    2016-05-17 09:55:59  Adding PROCEDURE spGetDataForSyncPackage
    2016-05-17 09:56:00  Creating Procedure spGetDataForSyncPackage
    2016-05-17 09:56:00  Creating Procedure spGetBundedByDataForSyncPackage
    2016-05-17 09:56:00  Creating Procedure spGetUpdateDataForSyncPackage
    2016-05-17 09:56:00  Creating Procedure spGetUpdateTypeByRevisionID
    2016-05-17 09:56:00  Creating Procedure spEnableReplica
    2016-05-17 09:56:00  Creating Procedure spGetAllExplicitComputerDeployments
    2016-05-17 09:56:00  Adding procedure spGetUpdatesForBulkHideInReplicaSync
    2016-05-17 09:56:00  Adding Procedure spDeleteRevision
    2016-05-17 09:56:00  Creating Procedure spGetCompressionThesholds
    2016-05-17 09:56:00  Adding Procedure spGetUpdatesWithPermanantlyInactiveDeployments
    2016-05-17 09:56:00  Adding Procedure spDeleteDeploymentsForUpdatesWithPermanantlyInactiveDeployments
    2016-05-17 09:56:00  Adding Procedure spSetUpdateFlagCatalogSite
    2016-05-17 09:56:00  Adding Procedure spGetUpdatesWithCatalogSiteFlag
    2016-05-17 09:56:00  Adding Procedure spMarkComputerAsNeedingDetailedRollup
    2016-05-17 09:56:00  Adding Procedure spMarkComputerAsDeletedForDss
    2016-05-17 09:56:01  Adding Procedure spUpdateDownstreamServerTarget
    2016-05-17 09:56:01  Adding Procedure spUpdateDownstreamServerSummaryRollup
    2016-05-17 09:56:01  Adding Procedure spUpdateDownstreamServerClientSummaryRollup
    2016-05-17 09:56:01  Adding Procedure spUpdateDownstreamServerClientActivityRollup
    2016-05-17 09:56:01  Adding Procedure spGetDownstreamServerClientSummaries
    2016-05-17 09:56:01  Adding Procedure spClearAllClientActivityCounts
    2016-05-17 09:56:01  Adding Procedure spGetClientSummaryForAllServers
    2016-05-17 09:56:01  Adding Procedure spGetClientActivityForAllServers
    2016-05-17 09:56:01  Adding Procedure spSetLastTimeReportToMU
    2016-05-17 09:56:01  Adding Procedure spGetLastTimeReportToMU
    2016-05-17 09:56:01  Adding PROCEDURE spGetTempContentCache
    2016-05-17 09:56:01  Creating PROCEDURE spGetTempContentCache
    2016-05-17 09:56:01  Creating PROCEDURE spPopulateMissingExpandedUpdateContentThrottlingInfo
    2016-05-17 09:56:01  Creating PROCEDURE spSetStringInContextInfo
    2016-05-17 09:56:01  Creating PROCEDURE spGetStringFromContextInfo
    2016-05-17 09:56:01  Creating PROCEDURE spSetOfflineSyncExclusionList
    2016-05-17 09:56:01  Creating PROCEDURE spGetEncryptedProxyPasswordFromDatabaseForUpgrade
    2016-05-17 09:56:01  Creating PROCEDURE spResetDssRequestedStateForFiles
    2016-05-17 09:56:01  Creating PROCEDURE spAllowComputersWithDuplicateNames
    2016-05-17 09:56:02  Creating PROCEDURE spGetAllUpdateUrls
    2016-05-17 09:56:02  Creating PROCEDURE spGetStartServerInitializationStatus
    2016-05-17 09:56:02  Creating PROCEDURE spSetStartServerInitializationStatus
    2016-05-17 09:56:02  Changed database context to 'SUSDB'.
    2016-05-17 09:56:02  Adding function fnGetConfigurationValue
    2016-05-17 09:56:02  Adding view vwConfiguration 
    2016-05-17 09:56:02  Adding PROCEDURE spConfiguration 
    2016-05-17 09:56:02  Creating Procedure spConfiguration
    2016-05-17 09:56:02  Creating Procedure spGetUpstreamServerInfo
    2016-05-17 09:56:02  Adding PROCEDURE spGetUpdateXmlFromRevision 
    2016-05-17 09:56:02  Creating Procedure spGetUpdateXmlFromRevision
    2016-05-17 09:56:03  Adding PROCEDURE spGetChangeTrackingInformation
    2016-05-17 09:56:03  Creating PROCEDURE spGetChangeTrackingInformation
    2016-05-17 09:56:03  Adding PROCEDURE spGetChangeTrackingNumber
    2016-05-17 09:56:03  Creating PROCEDURE spGetChangeTrackingNumber
    2016-05-17 09:56:03  Adding procedure spGetAllLanguagesWithEnabledState
    2016-05-17 09:56:03  Adding procedure spCheckConnection
    2016-05-17 09:56:03  Adding procedure spGetChangeTrackingNumbersForCache
    2016-05-17 09:56:03  Adding procedure spGetLanguageListForCache
    2016-05-17 09:56:03  Adding procedure spGetRevisionIdListForCache
    2016-05-17 09:56:03  Adding Procedure spGetRelatedRevisionsForUpdateID
    2016-05-17 09:56:03  Adding Procedure spGetAllUpdateIDs
    2016-05-17 09:56:03  Adding procedure spGetProgramKeys
    2016-05-17 09:56:04  Creating Procedure spGetUpdateDecryptionData
    2016-05-17 09:56:04  Creating Procedure spSetUpdateDecryptionData
    2016-05-17 09:56:04  Changed database context to 'SUSDB'.
    2016-05-17 09:56:04  Creating Function fnCsvToInt
    2016-05-17 09:56:04  Creating Function fnCsvToUniqueID
    2016-05-17 09:56:04  Creating Procedure spGetCoreUpdateXml
    2016-05-17 09:56:04  Creating Procedure spGetLocalizedUpdateXml
    2016-05-17 09:56:04  Creating Procedure spGetLocaleNames
    2016-05-17 09:56:04  Creating Procedure spGetGlobalUpdates
    2016-05-17 09:56:04  Creating Procedure spGetHardwareDrivers
    2016-05-17 09:56:04  Creating Procedure spGetMonitorableStatus
    2016-05-17 09:56:04  Creating Procedure spGetFileLocations
    2016-05-17 09:56:04  Adding procedure spGetAllTargetGroups
    2016-05-17 09:56:04  Creating Procedure spGetFrontEndServerInfo
    2016-05-17 09:56:04  Creating Procedure spSetFrontEndServerInfo
    2016-05-17 09:56:04  Creating Procedure spSetFileLocationChange
    2016-05-17 09:56:04  Creating Procedure spGetRevisionInfo
    2016-05-17 09:56:04  Creating Procedure spGetDeltaRevisionInfo
    2016-05-17 09:56:04  Changed database context to 'SUSDB'.
    2016-05-17 09:56:04  Adding procedure spAdduser
    2016-05-17 09:56:04  Adding procedure spGrantAsp 
    2016-05-17 09:56:04  Adding procedure spSetupLogin
    2016-05-17 09:56:05  Adding procedure spSetContentCacheLocation
    2016-05-17 09:56:05  Adding procedure spSetDefaults
    2016-05-17 09:56:05  Adding database version 
    2016-05-17 09:56:05  Changed database context to 'SUSDB'.
    2016-05-17 09:56:05  Creating table tbEventMessageTemplate
    2016-05-17 09:56:05  Creating table tbEventInstance
    2016-05-17 09:56:06  Caution: Changing any part of an object name could break scripts and stored procedures.
    2016-05-17 09:56:06  Creating table tbEvent
    2016-05-17 09:56:06  Creating table tbEventSource
    2016-05-17 09:56:06  Creating table tbEventNamespace
    2016-05-17 09:56:07  Alter table tbEvent with foreign key
    2016-05-17 09:56:07  Alter table tbEventSource with foreign key
    2016-05-17 09:56:07  Alter table tbEventMessageTemplate with foreign key
    2016-05-17 09:56:07  Alter table tbEventInstance with foreign keys
    2016-05-17 09:56:07  Adding procedure spImportEventNamespaceDescriptor
    2016-05-17 09:56:07  Adding procedure spAutoPurgeReportingEvents 
    2016-05-17 09:56:07  Adding procedure spLoadReportingEventAttributes
    2016-05-17 09:56:07  Changed database context to 'SUSDB'.
    2016-05-17 09:56:07  Creating table tbLocaleMap
    2016-05-17 09:56:07  Creating table tbOSMap
    2016-05-17 09:56:07  Creating table tbDownstreamServerRollupConfiguration
    2016-05-17 09:56:07  Creating table tbEventRollupCounters
    2016-05-17 09:56:07  Adding function fnFindOsID 
    2016-05-17 09:56:07  Adding function fnGetSummarizationState 
    2016-05-17 09:56:07  Adding function fnGetEffectiveDeployment 
    2016-05-17 09:56:07  Adding function fnGetTargetGroupIDForComputer
    2016-05-17 09:56:07  Adding procedure spAddReportingEventBatch 
    2016-05-17 09:56:08  Adding procedure spProcessActivityEvents 
    2016-05-17 09:56:08  Adding procedure spAddReportingEventInternal 
    2016-05-17 09:56:08  Adding procedure spAddUpdateStatusEventBatch 
    2016-05-17 09:56:08  Adding procedure spHandleClientRebootedEvent 
    2016-05-17 09:56:08  Adding procedure spUpdateLatestRollupEventTime
    2016-05-17 09:56:08  Adding procedure spGetCurrentSqlServerTime
    2016-05-17 09:56:08  Adding procedure spGetLatestRollupEventTime
    2016-05-17 09:56:08  Adding procedure spUpdateCurrentRollupState
    2016-05-17 09:56:08  Adding procedure spGetCurrentRollupState
    2016-05-17 09:56:08  Adding procedure spGetRollupCounter
    2016-05-17 09:56:08  Adding procedure spUpdateRollupCounter
    2016-05-17 09:56:08  Adding procedure spSetLastRollupInfo
    2016-05-17 09:56:08  Adding procedure spGetLastRollupInfo
    2016-05-17 09:56:08  Adding procedure spResetOnlineSummaryTables
    2016-05-17 09:56:08  Changed database context to 'SUSDB'.
    2016-05-17 09:56:08  Adding procedure spGetComputersToRollup
    2016-05-17 09:56:09  Adding procedure spMarkComputersAsNeedingFullComputerRollup
    2016-05-17 09:56:09  Adding procedure spUpdateComputersAfterRollup
    2016-05-17 09:56:09  Adding procedure spAddRollupComputers
    2016-05-17 09:56:09  Adding procedure spGetComputerLastRollupNumbers
    2016-05-17 09:56:10  Adding procedure spGetOutOfSyncComputers
    2016-05-17 09:56:10  Adding procedure spMarkComputersAsNeedingFullStatusRollup
    2016-05-17 09:56:10  Adding procedure spGetComputerStatusToRollup
    2016-05-17 09:56:10  Adding procedure spUpdateComputerStatusAfterRollup
    2016-05-17 09:56:10  Adding procedure spAddRollupStatus
    2016-05-17 09:56:10  Adding procedure spAddRollupStatusNoStatus
    2016-05-17 09:56:10  Adding procedure spMarkDataForFullRollup
    2016-05-17 09:56:10  Changed database context to 'SUSDB'.
    2016-05-17 09:56:10  Adding function fnMapLocalUpdateIDToGlobal 
    2016-05-17 09:56:10  Adding function fnMapGlobalToLocalUpdateID 
    2016-05-17 09:56:10  Adding function fnHasStaleDeployments
    2016-05-17 09:56:10  Adding function fnHasSupersededUpdates
    2016-05-17 09:56:10  Adding function fnIsEulaAcceptanceRequired
    2016-05-17 09:56:10  Adding function fnGetTargetGroupTypeID
    2016-05-17 09:56:10  Adding function fnGetComputerTargetID 
    2016-05-17 09:56:10  Adding function fnGetLatestRevisionNumber
    2016-05-17 09:56:10  Adding function fnIsInReplicaMode
    2016-05-17 09:56:10  Adding function fnComputeAutoApprovalDeadline
    2016-05-17 09:56:10  Adding view vwUpdatesToReport
    2016-05-17 09:56:10  Adding view vwUpdateInCategory
    2016-05-17 09:56:10  Adding view vwApiUpdateType
    2016-05-17 09:56:10  Adding view vwMinimalUpdate 
    2016-05-17 09:56:10  Adding view vwUpdateLanguage 
    2016-05-17 09:56:10  Adding view vwDefaultLocalizedProperty 
    2016-05-17 09:56:10  Adding view vwUpdateLocalizedProperties 
    2016-05-17 09:56:10  Adding view vwCategoryProperties 
    2016-05-17 09:56:11  Adding view vwEventHistory 
    2016-05-17 09:56:11  Adding function fnTbUpdateTypeNamesToGet
    2016-05-17 09:56:11  Adding function fnTbComputersInTargetGroup
    2016-05-17 09:56:11  Adding procedure spFilterUpdatesByScopeInternal
    2016-05-17 09:56:12  Adding procedure spGetCategories
    2016-05-17 09:56:12  Adding procedure spGetTopLevelCategories
    2016-05-17 09:56:12  Adding procedure spGetCategoryPropertiesByID
    2016-05-17 09:56:12  Adding procedure spGetSubCategoriesByUpdateID
    2016-05-17 09:56:12  Adding procedure spGetUpdatesUnderACategory
    2016-05-17 09:56:13  Adding procedure spGetTotalSummary
    2016-05-17 09:56:13  Adding procedure spGetSummariesPerComputer
    2016-05-17 09:56:13  Adding procedure spGetSummariesPerUpdate
    2016-05-17 09:56:13  Adding procedure spGetTotalUpdateSummaryForTargetGroup
    2016-05-17 09:56:13  Adding procedure spGetUpdateSummariesForTargetGroup
    2016-05-17 09:56:14  Adding procedure spGetTotalSummaryForComputer
    2016-05-17 09:56:14  Adding procedure spGetComputerSummariesForTargetGroup
    2016-05-17 09:56:14  Adding procedure spGetTargetGroupSummariesForUpdate
    2016-05-17 09:56:14  Adding procedure spGetUpdateSummaryForSingleTargetGroup
    2016-05-17 09:56:14  Adding procedure spGetTotalSummaryForCategory
    2016-05-17 09:56:14  Adding procedure spGetUpdateSummariesForCategory
    2016-05-17 09:56:14  Adding procedure spGetComputerSummariesForCategory
    2016-05-17 09:56:14  Adding procedure spGetUpdateInstallationInfoForUpdate
    2016-05-17 09:56:15  Adding procedure spGetUpdateInstallationInfoForComputer 
    2016-05-17 09:56:15  Adding procedure spGetUpdateInstallationInfoForTargetGroup
    2016-05-17 09:56:15  Adding procedure spDeployRevisionToDss
    2016-05-17 09:56:15  Adding procedure spGetAutoDeploymentRuleByID
    2016-05-17 09:56:15  Adding procedure spSaveParsedExtendedProperties
    2016-05-17 09:56:15  Adding procedure spGetUpdatesAndDeployments
    2016-05-17 09:56:15  Adding procedure spSetAutoDeploymentRule
    2016-05-17 09:56:15  Adding procedure spGetAutoDeploymentRuleIDs
    2016-05-17 09:56:15  Adding procedure spCreateAutoDeploymentRule
    2016-05-17 09:56:15  Adding procedure spDeleteAutoDeploymentRuleByID
    2016-05-17 09:56:15  Adding procedure spGetUpdateListToApproveForAutoDeploymentRule
    2016-05-17 09:56:15  Adding procedure spGetComputersNotContactedSinceCount
    2016-05-17 09:56:15  Adding procedure spDeclineUpdate
    2016-05-17 09:56:15  Adding procedure spGetParentCategories
    2016-05-17 09:56:16  Adding procedure spSearchUpdates 
    2016-05-17 09:56:16  Adding procedure spGetAllUpdates 
    2016-05-17 09:56:16  Adding procedure spGetUpdateCount
    2016-05-17 09:56:16  Adding procedure spGetRevisions
    2016-05-17 09:56:16  Adding procedure spGetComputerTargetByName
    2016-05-17 09:56:16  Adding procedure spSimpleSearchComputers
    2016-05-17 09:56:16  Adding procedure spSimpleSearchUpdates 
    2016-05-17 09:56:16  Adding procedure spGetEulaFiles
    2016-05-17 09:56:16  Adding procedure spGetShortLanguage
    2016-05-17 09:56:16  Adding procedure spGetEulaAcceptances
    2016-05-17 09:56:16  Adding procedure spAcceptEula
    2016-05-17 09:56:16  Adding procedure spAcceptEulaForReplicaDSS
    2016-05-17 09:56:17  Adding procedure spRecurseInsertCategoriesIntoFlatTable
    2016-05-17 09:56:17  Adding procedure spInsertCategoriesIntoFlatTable
    2016-05-17 09:56:17  Adding procedure spRepairPrecomputedTables
    2016-05-17 09:56:17  Adding procedure spGetInstallableItems
    2016-05-17 09:56:17  Adding PROCEDURE spGetApprovedUpdateMetadata 
    2016-05-17 09:56:17  Creating Procedure spGetApprovedUpdateMetadata
    2016-05-17 09:56:17  Adding procedure spHasApprovalsChanged
    2016-05-17 09:56:17  Adding procedure spGetUpdateByID
    2016-05-17 09:56:18  Adding procedure spGetUpdatesBundledByUpdate
    2016-05-17 09:56:18  Adding procedure spGetUpdatesThatBundleUpdate
    2016-05-17 09:56:18  Adding procedure spGetUpdatesSupersededByUpdate
    2016-05-17 09:56:18  Adding procedure spGetUpdatesThatSupersedeUpdate
    2016-05-17 09:56:18  Adding procedure spGetUpdatesRequiredByUpdate
    2016-05-17 09:56:18  Adding procedure spGetUpdatesThatRequireUpdate
    2016-05-17 09:56:18  Adding procedure spGetLanguagesForUpdate
    2016-05-17 09:56:18  Adding procedure spGetContentDownloadProgress
    2016-05-17 09:56:18  Adding procedure spCancelDownload
    2016-05-17 09:56:18  Adding procedure spCancelAllDownloads
    2016-05-17 09:56:18  Adding procedure spResumeDownload
    2016-05-17 09:56:18  Adding procedure spResumeAllDownloads
    2016-05-17 09:56:18  Adding procedure spSetConfiguration 
    2016-05-17 09:56:18  Adding Procedure spSetRollupConfiguration
    2016-05-17 09:56:19  Adding procedure spGetResetStateMachineNeededFlag
    2016-05-17 09:56:19  Adding procedure spDeleteDeployment
    2016-05-17 09:56:19  Adding procedure spCreateImplicitDeployment
    2016-05-17 09:56:19  Adding procedure spUndeclineUpdate
    2016-05-17 09:56:19  Adding procedure spDeployUpdate
    2016-05-17 09:56:19  Adding procedure spGetDeploymentByID 
    2016-05-17 09:56:19  Adding procedure spGetDeploymentsForAnUpdate
    2016-05-17 09:56:19  Adding procedure spGetDeployments
    2016-05-17 09:56:20  Adding procedure spRefreshDeployments
    2016-05-17 09:56:20  Adding procedure spGetSubscription
    2016-05-17 09:56:20  Adding procedure spGetSubscriptionCategories
    2016-05-17 09:56:20  Adding procedure spGetSubscriptionNextSynchronizationTime
    2016-05-17 09:56:20  Adding procedure spSetSubscription
    2016-05-17 09:56:20  Adding procedure spSetSubscriptionLastRunTime
    2016-05-17 09:56:20  Adding procedure spSetScheduleFrequency
    2016-05-17 09:56:21  Adding procedure spSetSubscriptionDeploymentAnchor
    2016-05-17 09:56:21  Adding procedure spSetSubscriptionAnchor
    2016-05-17 09:56:21  Adding procedure spGetTargetGroupByID
    2016-05-17 09:56:21  Adding procedure spGetTargetGroupForComputer
    2016-05-17 09:56:21  Adding procedure spGetTargetGroupsForComputer
    2016-05-17 09:56:21  Adding procedure spGetChildTargetGroups
    2016-05-17 09:56:21  Adding procedure spGetParentTargetGroup
    2016-05-17 09:56:21  Adding procedure spCreateTargetGroup
    2016-05-17 09:56:21  Adding procedure spDeleteTargetGroup
    2016-05-17 09:56:21  Adding procedure spAddTargetToTargetGroup
    2016-05-17 09:56:21  Adding procedure spRemoveTargetFromTargetGroup
    2016-05-17 09:56:21  Adding procedure spGetAllComputers
    2016-05-17 09:56:21  Adding procedure spSearchComputers
    2016-05-17 09:56:21  Adding procedure spGetComputerCount
    2016-05-17 09:56:22  Adding procedure spGetAllDownstreamServers
    2016-05-17 09:56:22  Adding procedure spGetInventoryItemsForComputer
    2016-05-17 09:56:22  Adding procedure spGetInventorySummary
    2016-05-17 09:56:22  Adding procedure spGetComputersHavingInventoryItem
    2016-05-17 09:56:22  Adding procedure spGetComputersInTargetGroup
    2016-05-17 09:56:22  Adding procedure spAddComputerToTargetGroup
    2016-05-17 09:56:22  Adding procedure spAddComputerToTargetGroupAllowMultipleGroups
    2016-05-17 09:56:22  Adding procedure spRemoveComputerFromTargetGroup
    2016-05-17 09:56:22  Adding procedure spGetDownstreamServersInTargetGroup
    2016-05-17 09:56:22  Adding procedure spCreateTargetEntry
    2016-05-17 09:56:22  Adding procedure spPreregisterComputer
    2016-05-17 09:56:22  Adding procedure spGetComputerByID
    2016-05-17 09:56:23  Adding procedure spGetDownstreamServer
    2016-05-17 09:56:23  Adding procedure spDeleteComputer
    2016-05-17 09:56:23  Adding procedure spDeleteDownstreamServer
    2016-05-17 09:56:23  Adding procedure spSearchEventHistory  
    2016-05-17 09:56:23  Adding procedure spPurgeReportingEvents 
    2016-05-17 09:56:23  Adding procedure spGetComponentsWithErrors
    2016-05-17 09:56:24  Adding procedure spGetUpdateServerStatus
    2016-05-17 09:56:24  Adding Procedure spGetDownstreamServerRollupSummary
    2016-05-17 09:56:24  Creating Procedure spGetXmlForUpdate
    2016-05-17 09:56:24  Creating Procedure spGetPreviousRevision
    2016-05-17 09:56:24  Adding Procedure spGetLatestRevisionNumberForUpdate
    2016-05-17 09:56:24  Adding Procedure spGetSdpXmlForUpdate
    2016-05-17 09:56:24  Adding PROCEDURE spGetEmailNotificationConfiguration
    2016-05-17 09:56:24  Adding PROCEDURE spSetEmailNotificationConfiguration
    2016-05-17 09:56:25  Adding procedure spGetEmailNotificationStatus
    2016-05-17 09:56:25  Adding procedure spSetEmailNotificationStatus
    2016-05-17 09:56:25  Adding PROCEDURE spScheduleEmailNotification
    2016-05-17 09:56:25  Adding PROCEDURE spGetEmailsToNotify
    2016-05-17 09:56:25  Adding PROCEDURE spGetEmailNotificationRecipients
    2016-05-17 09:56:25  Adding PROCEDURE spAddEmailNotificationRecipient
    2016-05-17 09:56:25  Adding PROCEDURE spDeclineSupersededUpdates
    2016-05-17 09:56:25  Adding PROCEDURE spDeclineExpiredUpdates
    2016-05-17 09:56:25  Adding PROCEDURE spCountObsoleteUpdatesToCleanup
    2016-05-17 09:56:25  Adding PROCEDURE spGetObsoleteUpdatesToCleanup
    2016-05-17 09:56:25  Adding PROCEDURE spDeleteUpdate
    2016-05-17 09:56:25  Adding PROCEDURE spDeleteUpdateByUpdateID
    2016-05-17 09:56:25  Adding PROCEDURE spCountUpdatesToCompress
    2016-05-17 09:56:25  Adding PROCEDURE spGetUpdatesToCompress
    2016-05-17 09:56:26  Adding PROCEDURE spCompressUpdate
    2016-05-17 09:56:26  Adding PROCEDURE spCleanupObsoleteComputers
    2016-05-17 09:56:26  Adding PROCEDURE spCleanupUnneededContentFiles
    2016-05-17 09:56:26  Adding procedure spGetFailedToDownloadUpdatesCount
    2016-05-17 09:56:26  Changed database context to 'SUSDB'.
    2016-05-17 09:56:26  Populating the database with basic configuration information
    2016-05-17 09:56:27  Creating the pre-defined target groups 
    2016-05-17 09:56:27  Populating Auto Deployment Rules
    2016-05-17 09:56:27  Populating System Subscription
    2016-05-17 09:56:27  Populating Email Notification Configuration
    2016-05-17 09:56:27  Populating Email Notification Status
    2016-05-17 09:56:27  Populating Languages
    2016-05-17 09:56:29  Populating tbLanguageInSubscription for default subscription
    2016-05-17 09:56:29  Populating Categories
    2016-05-17 09:56:29  Populating Driver classes
    2016-05-17 09:56:29  Populating handlers
    2016-05-17 09:56:29  Populating driver types
    2016-05-17 09:56:29  Populating state machine
    2016-05-17 09:56:31  Creating DSS deployments for any existing locally published updates that do not have one...
    2016-05-17 09:56:31  Finished creating DSS deployments.
    2016-05-17 09:56:32  Changed database context to 'SUSDB'.
    2016-05-17 09:56:32  Changed database context to 'SUSDB'.
    2016-05-17 09:56:32  Creating PROCEDURE spUpdateInventoryRulesXml
    2016-05-17 09:56:32  Creating PROCEDURE spAddDetailedInventoryRules
    2016-05-17 09:56:32  Creating PROCEDURE spGetInventoryVersion
    2016-05-17 09:56:32  Creating PROCEDURE spAddInventoryXml
    2016-05-17 09:56:32  Creating PROCEDURE spAddDetailedInventoryInformation
    2016-05-17 09:56:32  Changed database context to 'SUSDB'.
    2016-05-17 09:56:32  Dropping views and functions from the PUBLIC_VIEWS schema
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vUpdate
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vCategory
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vClassification
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vUpdateInCategory
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vLanguage
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vUpdateText
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vUpdateAdditionalInfoUrl
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vCategoryText
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vClassificationText
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vDownstreamServer
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vComputerTarget
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vComputerTargetGroup
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vComputerGroupMembership
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vUpdateApproval
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vUpdateInstallationInfoBasic
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vUpdateInstallationInfo
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vUpdateEffectiveApprovalPerComputer
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vSupportedInventory
    2016-05-17 09:56:32  Creating view PUBLIC_VIEWS.vComputerInventory
    2016-05-17 09:56:32  Creating TVF PUBLIC_VIEWS.fnUpdateInstallationStateMap
    2016-05-17 09:56:32  Reestablishing database connection...
    2016-05-17 09:56:32  Swtching DB to multi-user mode......
    2016-05-17 09:56:33  Finished setting multi-user mode
    2016-05-17 09:56:33  Starting service W3SVC
    2016-05-17 09:56:33  Starting service WSUSService
    2016-05-17 09:56:33  Postinstall completed


    • Edited by IT Mbeya Tuesday, May 17, 2016 7:41 AM
    Tuesday, May 17, 2016 7:38 AM
  • I have now seen this problem on 3 different customers running ConfigMgr 1602 / Sql 2012 / Server 2012 R2 / wsus DB in SQL. Uninstallation of the update seems to solve the issue as a workaround for now.

    Tuesday, May 17, 2016 8:13 AM
  • Exactly same issue here.  "Error: Unexpected Error" on console after kb installed.

    SCCM with wsus on same server.

    Tuesday, May 17, 2016 9:34 AM
  • As a way of testing I decided to bring back the SUSDB to WID from external SQL 2012. As I suspected the update and postinstallation steps now worked flawless. This is clearly an issue with external databases if you get the "index was outside of the bounds of the array" thingy.

    In my case this was the solution. For me this was all on our testenvironment so I could play with moving the database.

    • Marked as answer by Francis_D Monday, May 23, 2016 8:37 AM
    Tuesday, May 17, 2016 10:47 AM
  • As a way of testing I decided to bring back the SUSDB to WID from external SQL 2012. 

    Did you run WsusUtil.exe with the SQL_INSTANCE_NAME parameter? This is required if the SQL-server is external

    It is clearly stated if you run -> "WsusUtil.exe help postinstall".


    Rolf Lidvall, Swedish Radio (Ltd)

    Tuesday, May 17, 2016 11:55 AM
  • As a way of testing I decided to bring back the SUSDB to WID from external SQL 2012. 

    Did you run WsusUtil.exe with the SQL_INSTANCE_NAME parameter? This is required if the SQL-server is external

    It is clearly stated if you run -> "WsusUtil.exe help postinstall".


    Rolf Lidvall, Swedish Radio (Ltd)


    I did that. Same result with error "index was outside...". That's why I decided it was time to move the SUSD database back to WID.
    Tuesday, May 17, 2016 12:14 PM
  • OK, thanks.

    Rolf Lidvall, Swedish Radio (Ltd)

    Tuesday, May 17, 2016 12:21 PM
  • @Francis,

    was your external SQL server also a express version?

    Best regards,

    Andrei


    We could change the world, if God would give us the source code.

    Tuesday, May 17, 2016 12:22 PM
  • @Francis,

    was your external SQL server also a express version?

    Best regards,

    Andrei


    We could change the world, if God would give us the source code.

    No it was SQL 2012 cluster. Same sql cluster as our SCCM 2012 environment.

    • Edited by Francis_D Tuesday, May 17, 2016 12:40 PM
    Tuesday, May 17, 2016 12:39 PM
  • Thanks for the info.


    We could change the world, if God would give us the source code.

    Tuesday, May 17, 2016 12:56 PM
  • Same thing happened to my SCCM environment.  We found removing the WSUS feature, completely removing the content folder that was associated with it (We use an SQL database that wasn't touched during this), and then adding WSUS back seemed to completely resolve the issue.
    Tuesday, May 17, 2016 1:58 PM
  • Same thing happened to my SCCM environment.  We found removing the WSUS feature, completely removing the content folder that was associated with it (We use an SQL database that wasn't touched during this), and then adding WSUS back seemed to completely resolve the issue.
    So you kept the SUSDB on the SQL and just reinstalled the whole WSUS thing pointing to the existing SUSDB on your external SQL?
    Thursday, May 19, 2016 7:58 AM
  • I have the same issue, removing the update allows me to connect to the console. The environment was working fine previous to the recent updates that came out.
    Thursday, May 19, 2016 8:22 AM
  • Same here - again a faulty MS update! Really terrible. They don't get to grips with their QA.

    Uninstalling KB3159706 fixed the issue for us...

    Same here
    Thursday, May 19, 2016 8:41 AM
  • Another customer with the same issue, There is another tread regarding this issue

    https://social.technet.microsoft.com/Forums/windowsserver/en-US/59ad21be-7514-46df-adf3-fdf6ec15e132/wsus-breaks-after-kb3159706-released-552016?forum=winserverwsus

    Friday, May 20, 2016 7:29 AM
  • There is manual instructions in https://support.microsoft.com/en-us/kb/3159706 and it seems to work.

    1. Open an elevated Command Prompt window, and then run the following command (case sensitive, assume "C" as the system volume):
    2. "C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing
    3. Select HTTP Activation under .NET Framework 4.5 Features in the Server Manager Add Roles and Features wizard.

      HTTP activation
    4. Restart the WSUS service.

    • Proposed as answer by Daniel_Olsson Friday, May 20, 2016 1:37 PM
    • Unproposed as answer by Francis_D Monday, May 23, 2016 7:34 AM
    • Proposed as answer by ned7077 Wednesday, August 31, 2016 2:48 AM
    Friday, May 20, 2016 1:37 PM
  • Hi Francis_D,

    Have you got any progress recently, if CGS_001's reply could be of help?

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, May 23, 2016 6:39 AM
  • Hi Francis_D,

    Have you got any progress recently, if CGS_001's reply could be of help?

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    I cannot confirm this is of any help. I solved this problem by bringing back the SUSDB from external SQL server to Windows Internal Database.
    Monday, May 23, 2016 8:26 AM
  • Hi Francis_D,

    Anyway, glad to hear you have solved the issue and thanks for your feeding back. You may mark your resolution as answer.

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, May 23, 2016 8:29 AM
  • I believe this article covers the issue:

    https://support.microsoft.com/en-us/kb/3159706

    Tuesday, May 24, 2016 3:58 PM
  • I believe this article covers the issue:

    https://support.microsoft.com/en-us/kb/3159706


    Have you read the thread?
    Thursday, June 9, 2016 10:48 AM
  • Same here - again a faulty MS update! Really terrible. They don't get to grips with their QA.

    Uninstalling KB3159706 fixed the issue for us...

    This saved my butt today, 2 servers updated today, and were offline for a while shortly after that.

    I'm glad you posted this, because it worked!

    Thursday, June 9, 2016 11:43 PM
  • Hi IT Mbeya,

    >  Since it appears to be the"C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing step where the problem exits

    What is the result when you run the command, and what problem exits?

    Here is my result:

    After doing the manual steps, I can launch my WSUS console and make WSUS work.

    Best Regards,

    Anne


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Same solution here!!..

    After execute the command and few minutes later...  the server is working again!!

    Thx!!!

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

    Monday, June 13, 2016 11:06 AM
  • Unfortunately, this does not fix the problem on WSUS running with a SQL DB.

    Any workaround possible?

    Monday, June 13, 2016 1:22 PM
  • Yah, same issue here. I've been working on this for a month. It appears there is no other way around it if you are using an external DB. I'm not sure if anyone at M$ is even looking at it anymore.....
    Wednesday, June 15, 2016 2:22 PM
  • What worked for me was opening an Administrative command prompt.

    Change directory to cd C:\Program Files\Update Services\Tools

    Then run the line below, using your SQL instance and the correct WSUS content directory.

    wsusutil.exe postinstall SQL_INSTANCE_NAME="servername\instance" CONTENT_DIR=E:\WSUS

    This also fixed the problem caused by KB3159706. Running the above line after installing the update, allowed WSUS console to function as normal.

    • Proposed as answer by EviljesterNZ Friday, June 17, 2016 3:29 AM
    Friday, June 17, 2016 3:16 AM
  • Worked perfectly for me - thanks!
    Saturday, June 18, 2016 3:23 PM
  • I had the same problem, uninstalling KB3159706 resolved the problem. You would think MS would have pulled this update, or fixed it so it does not break WSUS by now. I've now declined this update and everything is working fine again.
    Monday, June 20, 2016 10:03 AM
  • EviljesterNZ's solution worked for me but it reset everything (approved updates, status on updates, etc).  It's a good thing my WSUS setup is really simple.

    What an absolute CLUSTER this update has been.  Could MS make it any more difficult?  And all this pain just so somebody doesn't get a sneak peak at some Win10 new feature.  Ridiculous.  The WSUS team and their QA really dropped the ball here.

    Monday, June 20, 2016 3:26 PM
  • It solved my problem! Thanx a lot!
    Thursday, June 23, 2016 2:29 AM
  • What worked for me was opening an Administrative command prompt.

    Change directory to cd C:\Program Files\Update Services\Tools

    Then run the line below, using your SQL instance and the correct WSUS content directory.

    wsusutil.exe postinstall SQL_INSTANCE_NAME="servername\instance" CONTENT_DIR=E:\WSUS

    This also fixed the problem caused by KB3159706. Running the above line after installing the update, allowed WSUS console to function as normal.

    This helped me too.  For people who are using a Default instance name, then you don't include \instance.  For example,

    wsusutil.exe postinstall SQL_INSTANCE_NAME="servername" CONTENT_DIR=E:\WSUS



    • Edited by LesterClayton Friday, July 22, 2016 7:12 AM
    • Proposed as answer by Jeffmw Wednesday, August 10, 2016 2:04 PM
    Friday, July 22, 2016 7:11 AM
  • I do not use WID, but MSSQL Express 2014. The problem persisted, even after doing the manual steps described in the KB. I could solve the problem by verifying the installed roles and features.

    WSUS Roles:
    - WID Database (not installed)
    - WSUS Services (installed)
    - Database (not installed)

    I have installed "Database"  and used the existing database ( and server MSSQL Express). Problems are gone.
    • Proposed as answer by ICT-IEPER Wednesday, August 17, 2016 12:09 PM
    Wednesday, August 17, 2016 12:07 PM
  • Just adding my two cents here. I recently built a new instance of WSUS with all the Windows 10 updates, am still not able to get Windows 7 machines to see Windows 10 upgrade as an option, but that's for another post. I installed the update in question, immediately ran the manual steps in the KB, rebooted and once the system was back up also wound up with a broken MMC.

    What I found is Microsoft article probably should clarify that you have to install the update, reboot the WSUS server, THEN once the system has rebooted run the manual configuration steps in the KB article, reboot or restart services once more. (I am using remote SQL 2012 as my database server as well.) What helped me was looking at the log file generated from running wsusutil the first time (after patch install before reboot) in the logfile under C:\users\username\appdata\local\temp (my file was tmp7406.tmp; open with notepad), at the end of the file it said,

    2016-08-26 11:10:42   Install type is: Reinstall

    2016-08-26 11:10:42   Install type is Reinstall, but should be Upgrade. Cannot service the database

    This lead me to seeing that the patch was not able to make the changes necessary for the database update (which is what the patch is for) so the MMC is not going to work until the changes happen. I went back and re-ran the manual steps in the KB article and checked the log; this time it listed a whole bunch of database table changes, procedure modifications and such. I rebooted, opened the MMC and all was well once again.

    If you have issues try running the manual steps again (it can't hurt, worst case is it will report nothing to do), don't forget to reboot or restart services afterward. This may not fix everyone, but it may help some!


    Sean

    Friday, August 26, 2016 7:11 PM
  • Removing update : KB3159706 fixed this for me too.

    WSUS Service would stop running after few minutes.  Removed the update, bounced, all fixed and console starts again.

    Monday, September 26, 2016 3:05 PM
  • This fixed it for me too, run the add features, check off the database and point it at the existing db server.  It didn't appear to overwrite the db, and once I did this I could run the wsusutil command. 
    Monday, September 26, 2016 5:46 PM
  • wsusutil postinstall /servicing worked for me. Thanks.

    David Jenkins

    Tuesday, February 21, 2017 8:23 PM
  • I ended up still removing KB3159706

    David Jenkins

    Tuesday, February 21, 2017 9:21 PM
  • Running the postinstall servicing fixed it for me too. Thanks!
    Friday, February 24, 2017 5:13 PM