none
SQL Server 2016 Full text search and Database Engine Services update could not be installed. Error code 1642.

    Question

  • Hi,

    I applied Cumulative Update for Servicepack 1 from 07. Jan. 2017 on two SQL Server 2016.

    https://support.microsoft.com/en-us/help/3208177/cumulative-update-1-for-sql-server-2016-sp1

    The update run on User Interface well without any error / warning message.

    After reboot I checked Event IDs and saw an failed update error related to full text search:

    Log Name:      Application
    Source:        MsiInstaller
    Date:          15.02.2017 12:39:30
    Event ID:      1024
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          <ADMIN ACCOUNT>
    Computer:      <SQL Server>
    Description:
    Product: SQL Server 2016 Full text search - Update '{747C8340-686E-450A-BA30-B7222BC4517B}' could not be installed. Error code 1642. Windows Installer can create logs to help troubleshoot issues with installing software packages. Use the following link for instructions on turning on logging support: http://go.microsoft.com/fwlink/?LinkId=23127
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MsiInstaller" />
        <EventID Qualifiers="0">1024</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2017-02-15T11:39:30.000000000Z" />
        <EventRecordID>5328</EventRecordID>
        <Channel>Application</Channel>
        <Computer>SQL Server</Computer>
        <Security UserID="S-1-5-21-220523388-602609370-1801674531-164445" />
      </System>
      <EventData>
        <Data>SQL Server 2016 Full text search</Data>
        <Data>{747C8340-686E-450A-BA30-B7222BC4517B}</Data>
        <Data>1642</Data>
        <Data>(NULL)</Data>
        <Data>(NULL)</Data>
        <Data>(NULL)</Data>
        <Data>
        </Data>
        <Binary>7B35394431413142422D433531332D343143322D384638332D3243443041353744463135417D207B37343743383334302D363836452D343530412D424133302D4237323232424334353137427D2031363432</Binary>
      </EventData>
    </Event>

    It is also the same error for Database Engine Services

    SQL Server 2016 Database Engine Services - Update '{E393F25D-E30C-4E74-90BB-49F5AE4B70D2}' could not be installed. Error code 1642. 

    How about with resolution of this issue?

    Best Regards

    Birdal


    • Edited by _Birdal Wednesday, February 15, 2017 12:33 PM
    Wednesday, February 15, 2017 12:16 PM

Answers

  • Hi _Birdal,

    Please first run the SQL Server 2016 Discovery Report (Please refer to this article: SQL Server 2012 Discovery Report, the method is same with SQL Server 2016). You can check if SQL Server 2016 has been upgraded successfully. If it is upgraded successfully, you can ignore this message.

    If it is not, you can disable Windows Update first and upgrade it again. Here is a similar case: Security Update for SQL Server 2012 Service Pack 2 (KB3045321) update problem.

    If you have any other questions, please let me know.

    Best Regards,
    Teige

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, February 16, 2017 9:05 AM