none
where can I find the file "SqlSqmShared.msp"? RRS feed

  • Frage

  • Hi

    I have troubles updating my SQL Server 2008 to Service Pack 3. I get continuing error messages concerning missing files in the %windir%\installer-directory.

    So far, I could get back all the necessary file, but now I am really stuk:
    I cannot find the file SqlSqmShared.msp, which should be in the package of "Service Pack 2 for SQL Server 2008 (KB2285068)".
    -> I don't even find ANYTHING in Google, Bing or anywhere else called SqlSqmShared.msp...

    Following you find the whole output of the summary file of the update-log:

    ---------------------------------------------------------------------

    Overall summary:
      Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2068709373
      Exit facility code:            1202
      Exit error code:               3
      Exit message:                  The cached patch file "C:\Windows\Installer\6b18f.msp" is missing. The original file for this cached file is "SqlSqmShared.msp", which can be installed from "Service Pack 2 for SQL Server 2008 (KB2285068)", version 10.2.4000.0.  For more information about how to resolve this problem, see “Steps to resolve missing media issue with SQL Server 2008” (http://go.microsoft.com/fwlink/?LinkId=144387) in the Microsoft Knowledge Base.
      Start time:                    2011-12-28 11:51:46
      End time:                      2011-12-28 11:52:03
      Requested action:              Patch
      Log with failure:              C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20111228_115144\Detail.txt
      Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll
    %26EvtID%3d50000%26ProdVer%3d10.0.5500.0%26EvtType%3d0x5C7938F3%400xC2B0B50B%401202%403

    Machine Properties:
      Machine name:                  VM-0020
      Machine processor count:       8
      OS version:                    Windows Server 2008
      OS service pack:               Service Pack 1
      OS region:                     Schweiz
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          32 Bit
      OS clustered:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
      Sql Server 2008      CITRIX_METAFRAME     MSSQL10.CITRIX_METAFRAME       Database Engine Services                 1033                 Express Edition      10.2.4000.0     No       

    Package properties:
      Description:                   SQL Server Database Services 2008
      SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
      ProductName:                   SQL2008
      Type:                          RTM
      Version:                       10
      SPLevel:                       3
      KBArticle:                     KB2546951
      KBArticleHyperlink:            http://support.microsoft.com/?kbid=2546951
      PatchType:                     SP
      AssociatedHotfixBuild:         0
      Platform:                      x86
      PatchLevel:                    10.3.5500.0
      ProductVersion:                10.0.1600.22
      GDRReservedRange:              10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0;10.0.4010.0:10.0.4250.0;10.0.5501.0:10.0.5750.0
      PackageName:                   SQLServer2008-KB2546951-x86.exe
      Installation location:         c:\a9a6508bc9c27d2303e1\x86\setup\

    User Input Settings:
      ACTION:                        Patch
      ALLINSTANCES:                  True
      CLUSTERPASSIVE:                False
      CONFIGURATIONFILE:            
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTANCENAME:                  <empty>
      QUIET:                         True
      QUIETSIMPLE:                   False
      X86:                           False

    Rules with failures:

    Global rules:

    There are no scenario-specific rules.

    Rules report file:               The rule result report file is not available.

    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented

    Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInvalidOperationException
        Message:
            The cached patch file "C:\Windows\Installer\6b18f.msp" is missing. The original file for this cached file is "SqlSqmShared.msp", which can be installed from "Service Pack 2 for SQL Server 2008 (KB2285068)", version 10.2.4000.0.
           
            For more information about how to resolve this problem, see “Steps to resolve missing media issue with SQL Server 2008” (http://go.microsoft.com/fwlink/?LinkId=144387) in the Microsoft Knowledge Base.
        Data:
          ChainerInvalidOperationExceptionData = this.GetInstalledPatchByMsi
          DisableWatson = true
        Stack:
            at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.GetInstalledPatchByMsi(PackageInstallProperty targetPackage, UInt32 patchIndex)
            at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.GetInstalledPatchByMsi(PackageInstallProperty targetPackage)
            at Microsoft.SqlServer.Configuration.MsiExtension.SetPatchInstallStateAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.GetInstalledPackages(String instanceName, List`1& installedInstancePackages, List`1& installedSharedPackages, String& returnedErrorMessage)
            at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.CollectProductData()
            at Microsoft.SqlServer.Configuration.MsiExtension.SetInstanceInstallStateAction.GetEligiableInstances()
            at Microsoft.SqlServer.Configuration.MsiExtension.SetInstanceInstallStateAction.ExecuteAction(String actionId)
            at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
            at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    ---------------------------------------------------------------------

    I have downloaded and unpacked the Service pack 2, but cannot find such a .msp :-(

     

    Would be very glad, if somebody could help me with this - thank you very much in advance!

    David


    Mittwoch, 28. Dezember 2011 17:26

Antworten

  • Hallo David,

    man sollte die folgenden Zeilen mit ' auskommentieren oder löschen

    // Copyright © Microsoft Corporation.  All Rights Reserved.
    // This code released under the terms of the 
    // Microsoft Public License (MS-PL, http://opensource.org/licenses/ms-pl.html.)
    

    Hast Du das Umbenennen von sqlsqm.msp ausprobiert?


    Xing   ExPEditor 0.0.11.0
    Freitag, 30. Dezember 2011 08:33

Alle Antworten

  • Hi Yury

    Thank you very much for your answer. I was doing that already according Procedure 2 (procedure 1 is too complicated for me - sorry, don't understand that clearly... :-( ), but then I have exactely the problem at step 6, I cannot find the file mentioned.

    || Infos, I have and therefore use (according step 1):
    ||   * PatchName: "Service Pack 2 for SQL Server 2008 (KB2285068)"
    ||   * Original MSP file that is used by the Patch: SqlSqmShared.msp
    ||   * Cached MSP file: c:\Windows\Installer\6b18f.msp

    -> This Original MSP file "SqlSqmShared.msp" cannot be found at the extracted "Service Pack 2 for SQL Server 2008 (KB2285068)"

     

    Thank you for any additional informations

    David

    Donnerstag, 29. Dezember 2011 00:17
  • Hallo David,
      
    ich würde doch versuchen, das Skript FindSQLInstalls.vbs auszuführen und dann die Ausgabedatei bezüglich sqlsqm zu untersuchen.
     
    Im KB2285068 ist nur die Datei sqlsqm.msp erhältlich. Versuche die Datei sqlsqm.msp auf 6b18f.msp umzubenennen und ins Ordner C:\Windows\Installer\ zu kopieren…

    Xing   ExPEditor 0.0.11.0
    Donnerstag, 29. Dezember 2011 03:26
  • Hallo Yury

    Vielen Dank für Deine Hilfe.

    Mit dem Script haben ich einfach Mühe :-( Der Output ist:

    C:\temp\script>Cscript FindSQLInstallsOnly.vbs %computername%_sql_install_details.txt
    Microsoft (R) Windows Script Host Version 5.8
    Copyright (C) Microsoft Corporation. All rights reserved.
    
    C:\temp\script\FindSQLInstallsOnly.vbs(1, 1) Microsoft VBScript compilation error: Expected statement

    -> Habe ich da etwas nicht begriffen? Etwas falsch gemacht?

     

    Ich habe es manuell weiter versucht und komme offensichtlich nun einen Schritt weiter.

    Leider nur einen Schritt:

    Nun bricht mir das Update ab - und im Summary.txt-log steht folgendes:

    Overall summary:
      Final result:                  The patch installer has failed to update the following instance: CITRIX_METAFRAME. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2068643839
      Exit facility code:            1203
      Exit error code:               1
      Exit message:                  The patch installer has failed to update the following instance: CITRIX_METAFRAME. To determine the reason for failure, review the log files.
      Start time:                    2011-12-30 09:27:09
      End time:                      2011-12-30 09:29:57
      Requested action:              Patch
    
    Instance CITRIX_METAFRAME overall summary:
      Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -2068643839
      Exit facility code:            1203
      Exit error code:               1
      Exit message:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
      Start time:                    2011-12-30 09:28:13
      End time:                      2011-12-30 09:29:49
      Requested action:              Patch
      Log with failure:              C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_092703\CITRIX_METAFRAME\RsFx_Cpu32_1.log
      Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.5500.0
    
    Machine Properties:
      Machine name:                  VM-0020
      Machine processor count:       8
      OS version:                    Windows Server 2008
      OS service pack:               Service Pack 1
      OS region:                     Schweiz
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          32 Bit
      OS clustered:                  No
    
    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
      Sql Server 2008      CITRIX_METAFRAME     MSSQL10.CITRIX_METAFRAME       Database Engine Services                 1033                 Express Edition      10.2.4000.0     No       
    
    Package properties:
      Description:                   SQL Server Database Services 2008
      SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
      ProductName:                   SQL2008
      Type:                          RTM
      Version:                       10
      SPLevel:                       3
      KBArticle:                     KB2546951
      KBArticleHyperlink:            http://support.microsoft.com/?kbid=2546951
      PatchType:                     SP
      AssociatedHotfixBuild:         0
      Platform:                      x86
      PatchLevel:                    10.3.5500.0
      ProductVersion:                10.0.1600.22
      GDRReservedRange:              10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0;10.0.4010.0:10.0.4250.0;10.0.5501.0:10.0.5750.0
      PackageName:                   SQLServer2008-KB2546951-x86.exe
      Installation location:         c:\7eae375e0c223ac4f4626c6a0998bd\x86\setup\
    
    Updated product edition:
      Instance             Edition            
      CITRIX_METAFRAME     EXPRESS            
    
    User Input Settings:
      ACTION:                        Patch
      ALLINSTANCES:                  True
      CLUSTERPASSIVE:                False
      CONFIGURATIONFILE:            
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTANCENAME:                  <empty>
      QUIET:                         True
      QUIETSIMPLE:                   False
      X86:                           False
    
    Rules with failures:
    
    Global rules:
    
    There are no scenario-specific rules.
    
    Rules report file:               C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20111230_092703\SystemConfigurationCheck_Report.htm
    Im Log Detail.txt steht auch nicht mehr als diese Error Codes... :-(

    Was kann man da wohl machen? Ist das evt. ein falsches .msi, das ich erwischt habe?

     

    Freitag, 30. Dezember 2011 07:56
  • Hallo David,

    man sollte die folgenden Zeilen mit ' auskommentieren oder löschen

    // Copyright © Microsoft Corporation.  All Rights Reserved.
    // This code released under the terms of the 
    // Microsoft Public License (MS-PL, http://opensource.org/licenses/ms-pl.html.)
    

    Hast Du das Umbenennen von sqlsqm.msp ausprobiert?


    Xing   ExPEditor 0.0.11.0
    Freitag, 30. Dezember 2011 08:33
  • Hallo Yury

    Super, Script funktinoiert nun, fand doch noch etwa drei Pakete, die installiert werden mussten, sich jedoch in den Summary-Logs nicht bemekbar machten :-(

    Vielen herzlichen Dank für Deine Hilfe!

    Einen guten Rutsch ins neue Jahr und Gruss aus der verschneiten Schweiz :-)

    David

    Freitag, 30. Dezember 2011 09:49
  • Hallo David,
     
    danke, ich wünsche Dir auch einen guten Rutsch ins neue Jahr!
     
    Könntest Du bitte kurz berichten, welche Pakete nachinstalliert werden müssen und ob danach sich der SP3 installieren ließ.

    Xing   ExPEditor 0.0.11.0
    Freitag, 30. Dezember 2011 10:29
  • Manuell musste ich einige Pakete nachladen und in das Installer-Verzeichnis kopieren, bei welchen ich nicht mehr weiss, was alles. War aber kein Problem, da sich jeweils im summary.txt-Log die entsprechenden Dateien fanden.

    Anstelle vom "SqlSqmShared.msp" konnte ich "SqlSqm.msp" nehmen, wie von Dir vorgeschlagen (ist im Verzeichnis <Patch>\x86\setup\x86

    Aus dem Script (nachdem es dann lief) ergaben sich noch folgende Dateien:
     - rsfx.msi, aus dem Pfad
    <Patch>\x86\setup
     - sqlncli.msi,
    ebenfalls aus Pfad <Patch>\x86\setup\x86
     - sqlwriter.msp, aus Pfad <Patch>\x86\setup\x86\1033

    Leider weiss ich die Installer-ID nicht mehr :-(

    Die Info, die mir letztendlich viel geholfen hat, war, dass bei dem Script die ersten drei Zeile auskommentiert oder gelöscht werden müssen. Das war aus der MS-Doku NICHT ersichtlich

    • Als Antwort vorgeschlagen Yury Iwtschenko Freitag, 30. Dezember 2011 11:38
    Freitag, 30. Dezember 2011 11:07
  • Hallo David,

    danke für deine Rückmeldung, es wird sicherlich noch einem oder anderem helfen.

    Das war aus der MS-Doku NICHT ersichtlich
    Ich habe bereits Microsoft Support darüber informiert.
    Xing   ExPEditor 0.0.11.0
    Freitag, 30. Dezember 2011 11:37