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