locked
WSUS Post install error RRS feed

  • Question

  • Trying to install WSUS and i am getting this error, seems like it might have to do something with sql any ideas? Thanks.

    2016-03-16 14:08:27  Postinstall started
    2016-03-16 14:08:27  Detected role services: Api, UI, WidDatabase, Services
    2016-03-16 14:08:27  Start: LoadSettingsFromXml
    2016-03-16 14:08:27  Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentLocal
    2016-03-16 14:08:27  Value is true
    2016-03-16 14:08:27  End: GetConfigValue
    2016-03-16 14:08:27  Start: GetConfigValue with filename=UpdateServices-Services.xml item=ContentDirectory
    2016-03-16 14:08:27  Value is C:\Comsys WSUS
    2016-03-16 14:08:27  End: GetConfigValue
    2016-03-16 14:08:27  Content directory is C:\Comsys WSUS
    2016-03-16 14:08:27  Database roleservice is not installed
    2016-03-16 14:08:27  End: LoadSettingsFromXml
    Post install is starting
    2016-03-16 14:08:27  Start: Run
    2016-03-16 14:08:27  Fetching WsusAdministratorsSid from registry store
    2016-03-16 14:08:27  Value is S-1-5-21-3423620976-244337339-1420169796-1001
    2016-03-16 14:08:27  Fetching WsusReportersSid from registry store
    2016-03-16 14:08:27  Value is S-1-5-21-3423620976-244337339-1420169796-1002
    2016-03-16 14:08:27  Configuring content directory...
    2016-03-16 14:08:27  Configuring groups...
    2016-03-16 14:08:27  Starting group configuration for WSUS Administrators...
    2016-03-16 14:08:27  Found group in regsitry, attempting to use it...
    2016-03-16 14:08:34  Writing group to registry...
    2016-03-16 14:08:34  Finished group creation
    2016-03-16 14:08:34  Starting group configuration for WSUS Reporters...
    2016-03-16 14:08:34  Found group in regsitry, attempting to use it...
    2016-03-16 14:08:34  Writing group to registry...
    2016-03-16 14:08:34  Finished group creation
    2016-03-16 14:08:34  Configuring permissions...
    2016-03-16 14:08:34  Fetching content directory...
    2016-03-16 14:08:34  Fetching ContentDir from registry store
    2016-03-16 14:08:34  Value is C:\Comsys WSUS
    2016-03-16 14:08:34  Fetching group SIDs...
    2016-03-16 14:08:34  Fetching WsusAdministratorsSid from registry store
    2016-03-16 14:08:34  Value is S-1-5-21-3423620976-244337339-1420169796-1001
    2016-03-16 14:08:34  Fetching WsusReportersSid from registry store
    2016-03-16 14:08:34  Value is S-1-5-21-3423620976-244337339-1420169796-1002
    2016-03-16 14:08:34  Creating group principals...
    2016-03-16 14:08:34  Granting directory permissions...
    2016-03-16 14:08:34  Granting permissions on content directory...
    2016-03-16 14:08:34  Granting registry permissions...
    2016-03-16 14:08:34  Granting registry permissions...
    2016-03-16 14:08:34  Granting registry permissions...
    2016-03-16 14:08:34  Configuring shares...
    2016-03-16 14:08:34  Configuring network shares...
    2016-03-16 14:08:34  Fetching content directory...
    2016-03-16 14:08:34  Fetching ContentDir from registry store
    2016-03-16 14:08:34  Value is C:\Comsys WSUS
    2016-03-16 14:08:34  Fetching WSUS admin SID...
    2016-03-16 14:08:34  Fetching WsusAdministratorsSid from registry store
    2016-03-16 14:08:34  Value is S-1-5-21-3423620976-244337339-1420169796-1001
    2016-03-16 14:08:34  Content directory is local, creating content shares...
    2016-03-16 14:08:34  Creating share "UpdateServicesPackages" with path "C:\Comsys 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."
    2016-03-16 14:08:34  Deleting existing share...
    2016-03-16 14:08:34  Creating share...
    2016-03-16 14:08:34  Share successfully created
    2016-03-16 14:08:34  Creating share "WsusContent" with path "C:\Comsys WSUS\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2016-03-16 14:08:34  Deleting existing share...
    2016-03-16 14:08:34  Creating share...
    2016-03-16 14:08:34  Share successfully created
    2016-03-16 14:08:34  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."
    2016-03-16 14:08:34  Deleting existing share...
    2016-03-16 14:08:34  Creating share...
    2016-03-16 14:08:34  Share successfully created
    2016-03-16 14:08:34  Finished creating content shares
    2016-03-16 14:08:34  Stopping service WSUSService
    2016-03-16 14:08:35  Stopping service W3SVC
    2016-03-16 14:08:36  Configuring WID database...
    2016-03-16 14:08:36  Configuring the database...
    2016-03-16 14:08:36  Establishing DB connection...
    2016-03-16 14:08:36  Checking to see if database exists...
    2016-03-16 14:08:36  Database exists
    2016-03-16 14:08:36  Switching database to single user mode...
    2016-03-16 14:08:39  Loading install type query...
    2016-03-16 14:08:39  DECLARE @currentDBVersion       int
    DECLARE @scriptMajorVersion     int = (9600)
    DECLARE @scriptMinorVersion     int = (16384)
    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-03-16 14:08:39  Install type is: Reinstall
    2016-03-16 14:08:39  Creating logins...
    2016-03-16 14:08:39  Fetching account info for S-1-5-20
    2016-03-16 14:08:39  Found principal
    2016-03-16 14:08:39  Found account
    2016-03-16 14:08:39  Got binary SID
    2016-03-16 14:08:39  Fetching WsusAdministratorsSid from registry store
    2016-03-16 14:08:39  Value is S-1-5-21-3423620976-244337339-1420169796-1001
    2016-03-16 14:08:39  Fetching account info for S-1-5-21-3423620976-244337339-1420169796-1001
    2016-03-16 14:08:39  Found principal
    2016-03-16 14:08:39  Found account
    2016-03-16 14:08:39  Got binary SID
    2016-03-16 14:08:39  Setting content location...
    2016-03-16 14:08:39  Fetching ContentDir from registry store
    2016-03-16 14:08:39  Value is C:\Comsys WSUS
    2016-03-16 14:08:39  Swtching DB to multi-user mode......
    2016-03-16 14:08:39  Finished setting multi-user mode
    2016-03-16 14:08:39  Writing DB settings to registry...
    2016-03-16 14:08:39  Marking PostInstall done for UpdateServices-WidDatabase in the registry...
    2016-03-16 14:08:39  Starting service W3SVC
    2016-03-16 14:08:40  Configuring IIS...
    2016-03-16 14:08:40  Start: ConfigureWebsite
    2016-03-16 14:08:40  Configuring website on port 8530
    2016-03-16 14:09:00  2016-03-16 14:08:49  Info      IISCustomAction    Performing Setup Action, Command /Install
    2016-03-16 14:08:59  Info      IISCustomAction    Command /Install Succeeded

    2016-03-16 14:09:00  End: ConfigureWebsite
    2016-03-16 14:09:00  Configuring performance counters...
    2016-03-16 14:09:00  Configuring Stats.NET perf counter...
    2016-03-16 14:09:00  Configuring reporting perf counter...
    2016-03-16 14:09:00  Configuring client webservice perf counter...
    2016-03-16 14:09:00  Configuring server sync webservice perf counter...
    2016-03-16 14:09:00  Configuring API remoting perf counter...
    2016-03-16 14:09:00  Bringing services online...
    2016-03-16 14:09:00  Checking initialization status...
    2016-03-16 14:09:00  StartServer starting...
    2016-03-16 14:09:00  Generating encryption key to write to the registry...
    2016-03-16 14:09:00  Generating encryption key to write to the database...
    2016-03-16 14:09:00  Generating encryption key succeeded...
    2016-03-16 14:09:00  Setting WSUSService to autostart...
    2016-03-16 14:09:00  WSUSService is set to autostart.
    2016-03-16 14:09:00  Starting WSUSService...
    2016-03-16 14:09:00  WSUSService is now started.
    2016-03-16 14:09:00  Importing default detectoids.
    2016-03-16 14:09:00  Importing CriticalUpdates.xml...
    2016-03-16 14:09:01  ImportDefaultDetectoids failed. Exception: System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK__tbDeploym__Targe__38EE7070". The conflict occurred in database "SUSDB", table "dbo.tbTargetGroup", column 'TargetGroupID'.
    Failed to deploy update E6CF1350-C01B-414D-A61F-263D14D133B4\1 to downstream server target group
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    The statement has been terminated.
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
       at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult()
       at Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ExecuteSPImportUpdate(Int32 upstreamServerLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, Int32& localRevisionId)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ImportUpdate(Int32 ussRevLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, String xmlSdpBlob, Int32& localRevisionId)
       at Microsoft.UpdateServices.Internal.DatabaseAccess.CommonDataAccess.ImportUpdate(Int32 ussRevLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed)
       at Microsoft.UpdateServices.Setup.StartServer.StartServer.ImportDefaultDetectoids()
    ClientConnectionId:9eca045e-54d6-4f2d-8e31-9ae256ac1163
    Error Number:547,State:0,Class:16
    2016-03-16 14:09:01  StartServer encountered errors. Exception=The INSERT statement conflicted with the FOREIGN KEY constraint "FK__tbDeploym__Targe__38EE7070". The conflict occurred in database "SUSDB", table "dbo.tbTargetGroup", column 'TargetGroupID'.
    Failed to deploy update E6CF1350-C01B-414D-A61F-263D14D133B4\1 to downstream server target group
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    Warning: The join order has been enforced because a local join hint is used.
    The statement has been terminated.
    2016-03-16 14:09:01  Microsoft.UpdateServices.Administration.CommandException: Failed to start and configure the WSUS service
       at Microsoft.UpdateServices.Administration.PostInstall.Run()
       at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments)
    Fatal Error: Failed to start and configure the WSUS service

    Wednesday, March 16, 2016 9:14 PM

Answers

  • Hi PuskarR,

    Could you provide some information about the questions below?

    1. What the version of your WSUS server?

    2. Do you use WID?

    3. What options do you configure when deploy the WSUS server?

    4. Is the installation first time or re-installation of WSUS role?

    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.


    Thursday, March 17, 2016 2:17 AM