Remove From My Forums

KB3159706 breaks WSUS even after postinstall steps

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

0

Sign in to vote

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
0

Sign in to vote

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
1

Sign in to vote

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
0

Sign in to vote

Hi,

same problem.

Did you solve it?

Regards,

sia

Friday, August 26, 2016 1:13 PM
0

Sign in to vote

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

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

Asked by:

KB3159706 breaks WSUS even after postinstall steps

Question

All replies