locked
KB3159706 breaks WSUS even after postinstall steps RRS feed

  • Question

  • Hello,



    I'm running WSUS and SCCM 1606 on a 2012 R2 server. SQL Server 2014 is running on the same server and hosts the database for SCCM and WSUS. I am playing around with the Anniversary Update and trying to find the best way, so I need to install the KB3159706 



    I installed it and followed the install steps per the KB, but after installing it my WSUS service would not start. After reverting the update, WSUS started working again. 



    Here's the last few lines of the SoftwareDistibution.log:

    2016-08-19 12:15:02.541 UTC	Warning	w3wp.12	SoapUtilities.CreateException	ThrowException: actor = http://sccm.domain.com.local:8530/SimpleAuthWebService/SimpleAuth.asmx, ID=3b0f53fd-2e3c-4c4a-a882-48b11010f7eb, ErrorCode=InternalServerError, Message=, Client=?
    2016-08-19 12:15:03.220 UTC	Info	w3wp.116	SimpleAuth..ctor	Initializing SimpleAuth WebService ProcessID = 3120, Process Start Time = 8/18/2016 7:00:18 AM, Product Version = 6.3.9600.18324
    2016-08-19 12:15:03.224 UTC	Error	w3wp.116	SimpleAuthImplementation..ctor	Exception in SimpleAuth constructor: System.IndexOutOfRangeException: Index was outside the bounds of the array.
       at Microsoft.UpdateServices.Internal.DatabaseAccess.GenericReadableRow.GetInt32(Int32 index)
       at Microsoft.UpdateServices.Internal.ConfigurationTableRow.ReadRow(IDataRecord record)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetConfiguration()
       at Microsoft.UpdateServices.Internal.SimpleAuthImplementation..ctor(ConfigChangeHandler handler)
       at Microsoft.UpdateServices.Internal.SimpleAuthImplementation..ctor(ConfigChangeHandler handler)
       at Microsoft.UpdateServices.Internal.SimpleAuth..ctor()
       at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
       at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
       at System.Activator.CreateInstance(Type type, Boolean nonPublic)
       at System.Activator.CreateInstance(Type type)
       at System.Web.Services.Protocols.ServerProtocol.CreateServerInstance()
       at System.Web.Services.Protocols.SoapServerProtocol.CreateServerInstance()
       at System.Web.Services.Protocols.WebServiceHandler.Invoke()
       at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
       at System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
       at System.Web.Script.Services.ScriptHandlerFactory.HandlerWrapper.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
       at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
       at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
       at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
       at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
       at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
    2016-08-19 12:15:03.225 UTC	Warning	w3wp.116	SoapUtilities.CreateException	ThrowException: actor = http://sccm.domain.com.local:8530/SimpleAuthWebService/SimpleAuth.asmx, ID=83536655-623e-42c9-8283-a21006990af3, ErrorCode=InternalServerError, Message=, Client=?
    2016-08-19 12:15:04.124 UTC	Info	w3wp.103	SimpleAuth..ctor	Initializing SimpleAuth WebService ProcessID = 3120, Process Start Time = 8/18/2016 7:00:18 AM, Product Version = 6.3.9600.18324
    2016-08-19 12:15:04.127 UTC	Error	w3wp.103	SimpleAuthImplementation..ctor	Exception in SimpleAuth constructor: System.IndexOutOfRangeException: Index was outside the bounds of the array.
       at Microsoft.UpdateServices.Internal.DatabaseAccess.GenericReadableRow.GetInt32(Int32 index)
       at Microsoft.UpdateServices.Internal.ConfigurationTableRow.ReadRow(IDataRecord record)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetConfiguration()
       at Microsoft.UpdateServices.Internal.SimpleAuthImplementation..ctor(ConfigChangeHandler handler)
       at Microsoft.UpdateServices.Internal.SimpleAuthImplementation..ctor(ConfigChangeHandler handler)
       at Microsoft.UpdateServices.Internal.SimpleAuth..ctor()
       at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
       at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
       at System.Activator.CreateInstance(Type type, Boolean nonPublic)
       at System.Activator.CreateInstance(Type type)
       at System.Web.Services.Protocols.ServerProtocol.CreateServerInstance()
       at System.Web.Services.Protocols.SoapServerProtocol.CreateServerInstance()
       at System.Web.Services.Protocols.WebServiceHandler.Invoke()
       at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
       at System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
       at System.Web.Script.Services.ScriptHandlerFactory.HandlerWrapper.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
       at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
       at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
       at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
       at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
       at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
       at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
    2016-08-19 12:15:04.128 UTC	Warning	w3wp.103	SoapUtilities.CreateException	ThrowException: actor = http://sccm.domain.com.local:8530/SimpleAuthWebService/SimpleAuth.asmx, ID=7f47becf-1df8-4cca-9824-4c3118c35615, ErrorCode=InternalServerError, Message=, Client=?
    

    Here's the .tmp file from the postinstall

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

    I really want this patch to work so I can deploy this update. 


    Thanks! 

    Friday, August 19, 2016 1:48 PM

All replies

  • there have been quite a few reports here in the WSUS forum, of people having this problem, applying KB3159706 to their WSUS, when the SUSDB is *not* hosted by WID.

    I'm yet to see anybody report it working.

    I suggest that you log a support case with MSFT to get assistance with it.
    (which I think was a suggestion by Steve Henry@MSFT in one of his responses, either here in the forum or perhaps in blog comments)

    https://blogs.technet.microsoft.com/wsus/2016/05/05/the-long-term-fix-for-kb3148812-issues/


    Don [doesn't work for MSFT, and they're probably glad about that ;]

    Saturday, August 20, 2016 10:51 AM
  • Hi jon.larson,

    If you want to open a case with Microsoft, you may use the following 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.

    Monday, August 22, 2016 5:55 AM
  • I don't have to pay for a MSFT support case, do I? I'm not paying because your patch doesn't work. 
    Monday, August 22, 2016 12:14 PM
  • Hi,

    same problem.

    Did you solve it?

    Regards,

    sia

    Friday, August 26, 2016 1:13 PM
  • Hi jon.larson13,

    As far as I know, if the issue is actually defined to be a bug, then, MS will refund.

    Have you got any progress with the issue?

    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, September 2, 2016 7:47 AM