Post reply

Serious bug in SQL Server 2012 SP1, due to msiexec process keep running

  • September 11, 2013 at 2:07 pm

    #395461

    Cumulative Update 2 (CU2) for SQL Server 2012 is a very important patch that you should APPLY AS SOON AS POSSIBLE.

    There is a serious bug in SP1 that is bloating the registry hive, because msiexec.exe processes keep running, even after rebooting and can use almost 100% of the CPU constantly. Windows will crash and you need to reinstall Windows when the registry hive reaches 2GB in size!

    If you look in the Eventlog, the following warnings are logged repeatedly:

    EventId: 1004 Source: MsiInstaller Description: Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_Ans', Component '{0CECE655-2A0F-4593-AF4B-EFC31D622982}' failed. The resource'' does not exist.

    EventId: 1001 Source: MsiInstaller Description: Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_Ans' failed during request for component '{6E985C15-8B6D-413D-B456-4F624D9C11C2}'

    Read more at:

    http://blogs.msdn.com/b/sqljourney/archive/2012/10/25/why-the-registry-size-can-cause-problems-with-your-sql-2012-alwayson-setup.aspx

    https://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1

    https://support.microsoft.com/kb/2793634

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • September 11, 2013 at 2:18 pm

    #1649493

    Maybe your post should focus more on the fact that this bug is already resolved.

    The fix can be downloaded here:

    Non Security Update for SQL Server 2012 SP1 (KB2793634)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 11, 2013 at 2:26 pm

    #1649494

    Koen Verbeeck (9/11/2013)

    Maybe your post should focus more on the fact that this bug is already resolved.

    The fix can be downloaded here:

    Non Security Update for SQL Server 2012 SP1 (KB2793634)

    Yes, it should! I copied the text from my blog, but missed the first few lines, where I mention that you should install at least CU2 to remove the bug.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • December 23, 2013 at 9:05 am

    #1675640

    Hi,

    I have a serious problem. The registry is so bloated that it won't let me install any hotfix.

    Any ideas what to do?

    Is there any remote registry cleaner authorized by Microsoft that will give some air for my poor registry so I can install Microsoft hotfix for this issue?

    thanks,

    Avi

  • December 23, 2013 at 1:58 pm

    #1675685

    avi_ka (12/23/2013)

    Hi,

    I have a serious problem. The registry is so bloated that it won't let me install any hotfix.

    Any ideas what to do?

    Is there any remote registry cleaner authorized by Microsoft that will give some air for my poor registry so I can install Microsoft hotfix for this issue?

    thanks,

    Avi

    Follow the steps in the Connect item To Clean the registry hive.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply