locked
Service packs and patch MS14-044 keeps failing during a installation on a cluster RRS feed

  • Question

  • Hi, 

    We have a cluster with several sql2008 R2 instances and recently we had to add one more. But now when we try to apply a service pack or patch on that instance on one the same node the installation fails. They all fail with the same error:

    SP1 

    2014-09-17 12:53:40 Slp: Parameter 0 : SQL2008@RTM@KB2528583 
    2014-09-17 12:53:40 Slp: Parameter 1 : 0x4A9286D0 
    2014-09-17 12:53:40 Slp: Parameter 2 : 0x4A9286D0 
    2014-09-17 12:53:40 Slp: Parameter 3 : 0x54657B2B 
    2014-09-17 12:53:40 Slp: Parameter 4 : 0x54657B2B

    SP2

    2014-09-16 12:56:23 Slp: Parameter 0 : SQL2008@RTM@KB2630458 
    2014-09-16 12:56:23 Slp: Parameter 1 : 0x4A9286D0 
    2014-09-16 12:56:23 Slp: Parameter 2 : 0x4A9286D0 
    2014-09-16 12:56:23 Slp: Parameter 3 : 0x54657B2B 
    2014-09-16 12:56:23 Slp: Parameter 4 : 0x54657B2B 

    MS14-044

    2014-09-16 20:55:15 Slp: Parameter 0 : SQL2008@RTM@KB2977320 
    2014-09-16 20:55:15 Slp: Parameter 1 : 0x4A9286D0 
    2014-09-16 20:55:15 Slp: Parameter 2 : 0x4A9286D0 
    2014-09-16 20:55:15 Slp: Parameter 3 : 0x54657B2B 
    2014-09-16 20:55:15 Slp: Parameter 4 : 0x54657B2B 2014-09-16 20:55:05 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.InitializeUIDataAction" threw an exception during execution.
    2014-09-16 20:55:06 Slp: Received request to add the following file to Watson reporting: C:\Users\adm_koomenh\AppData\Local\Temp\tmp7FDE.tmp
    2014-09-16 20:55:06 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2014-09-16 20:55:06 Slp: Inner exceptions are being indented
    2014-09-16 20:55:06 Slp: 
    2014-09-16 20:55:06 Slp: Exception type: System.Resources.MissingManifestResourceException
    2014-09-16 20:55:06 Slp:     Message: 
    2014-09-16 20:55:06 Slp:         Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure "Errors.resources" was correctly embedded or linked into assembly "Microsoft.SqlServer.Discovery" at compile time, or that all the satellite assemblies required are loadable and fully signed.
    2014-09-16 20:55:06 Slp:     Stack: 
    2014-09-16 20:55:06 Slp:         at System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents)
    2014-09-16 20:55:06 Slp:         at System.Resources.ResourceManager.GetObject(String name, CultureInfo culture, Boolean wrapUnmanagedMemStream)
    2014-09-16 20:55:06 Slp:         at Microsoft.SqlServer.Discovery.MsiException.GetErrorMessage(Int32 errorNumber, CultureInfo culture)
    2014-09-16 20:55:06 Slp:         at Microsoft.SqlServer.Discovery.MsiException.GetErrorMessage(MsiRecord errorRecord, CultureInfo culture)
    2014-09-16 20:55:06 Slp:         at Microsoft.SqlServer.Discovery.MsiException.get_Message()
    2014-09-16 20:55:06 Slp:         at System.Exception.ToString()
    2014-09-16 20:55:06 Slp:         at System.Exception.ToString()
    2014-09-16 20:55:06 Slp:         at System.Exception.ToString()
    2014-09-16 20:55:06 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
    2014-09-16 20:55:06 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(WorkflowObject workflowObject, HandleInternalException exceptionHandler)
    2014-09-16 20:55:06 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.RunRequestedWorkflow()
    2014-09-16 20:55:06 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.Run()
    2014-09-16 20:55:06 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.Start()
    2014-09-16 20:55:06 Slp:         at Microsoft.SqlServer.Chainer.Setup.Setup.Main()
    2014-09-16 20:55:15 Slp: Watson Bucket 1 
     Original Parameter Values 

    2014-09-16 20:55:15 Slp: Parameter 0 : SQL2008@RTM@KB2977320 
    2014-09-16 20:55:15 Slp: Parameter 1 : System.Resources.ResourceManager.InternalGetResourceSet 
    2014-09-16 20:55:15 Slp: Parameter 2 : System.Resources.ResourceManager.InternalGetResourceSet 
    2014-09-16 20:55:15 Slp: Parameter 3 : System.Resources.MissingManifestResourceException@-2146233038 
    2014-09-16 20:55:15 Slp: Parameter 4 : System.Resources.MissingManifestResourceException@-2146233038 
    2014-09-16 20:55:15 Slp: 
     Final Parameter Values 

    Note that on the other cluster node we have no problem at all but patching one side and the other is a no go.

    regards

    Hans Koomen

    Wednesday, September 17, 2014 1:26 PM

Answers

  • The problem was resolved after removing all SQL tools (SSMS, development studio and more) and then reinstall them again.

    • Proposed as answer by Ashwin Menon Wednesday, October 8, 2014 10:35 AM
    • Marked as answer by Charlie Liao Thursday, October 9, 2014 9:39 AM
    Wednesday, October 8, 2014 10:24 AM

All replies

  • Hi,

    Seems like you are trying to apply SP1 on cluster is it correct ?. Have you already applied security patch which is there in MS14-044 /

    Can you please post output of

    select @@version


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Articles

    Wednesday, September 17, 2014 1:33 PM
  • Wednesday, September 17, 2014 1:53 PM
  • There are 4 instance running in this cluster and 2 have patch ms14-044. On one instance it is missing but it has SP2 and the new instance is still 10.50.1600
    Thursday, September 18, 2014 1:51 PM
  • Hi,

    We tried that including the findSQLintaller.vbs scripts. We corrected all the findings mentioned in the outcome of that script. but nothing works. 

    Thursday, September 18, 2014 1:53 PM
  • There are 4 instance running in this cluster and 2 have patch ms14-044. On one instance it is missing but it has SP2 and the new instance is still 10.50.1600

    Is it so hard for you to put output of query than  writing something which is difficult to understand. I don't believe how how you think you can provide half information and still expect answer.

    So can you go run select @@Version on all instances and post result here it seems you have different patch on different nodes or instances i cannot figure out.

    If instance is patched  with MS14-044 you cannot and ALSO it is not required to apply any SP or CU related to SQl server 2008 r2


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Articles

    Thursday, September 18, 2014 2:10 PM
  • 1st instance: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4033.0 (X64)   Jul  9 2014 16:04:25   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

    2nd instance: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4033.0 (X64)   Jul  9 2014 16:04:25   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

    3rd instance: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4033.0 (X64)   Jul  9 2014 16:04:25   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

    4th instance: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

    Furthermore using http://support.microsoft.com/kb/2015100/es we find this:

    PRODUCT NAME   : SQL Server 2008 R2 SP2 Database Engine Services
    ================================================================================
      Product Code: {2E81ADBE-DED7-4B54-9C8D-FBD885C259C5}
      Version     : 10.52.4000.0
      Most Current Install Date: 20140718
      Target Install Location: 
      Registry Path: 
       HKEY_CLASSES_ROOT\Installer\Products\EBDA18E27DED45B4C9D8BF8D582C955C\SourceList
         Package    : sql_engine_core_inst_loc.msi
      Install Source: \1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\
      LastUsedSource: n;1;E:\software\SQL2008R2_Std_X64\1033_ENU_LP\x64\setup\sql_engine_core_inst_loc_msi\
     
        sql_engine_core_inst_loc.msi exists on the LastUsedSource path, no actions needed.
     
    Installer Cache File: C:\Windows\Installer\21807f.msi

    while the log states:

    2014-09-19 14:56:31 Slp: Package sql_engine_core_inst_loc_Cpu64_1033: - The path of cached MSI package is: C:\Windows\Installer\21807f.msi . The RTM product version is: 10.50.1600.1

    Friday, September 19, 2014 1:19 PM
  • The problem was resolved after removing all SQL tools (SSMS, development studio and more) and then reinstall them again.

    • Proposed as answer by Ashwin Menon Wednesday, October 8, 2014 10:35 AM
    • Marked as answer by Charlie Liao Thursday, October 9, 2014 9:39 AM
    Wednesday, October 8, 2014 10:24 AM