none
Windows Installer does not permit patching of managed advertised products.

    Question

  • Hi There,

     

    I have recently undertaken the task of rebuilding the DEV server at one of our clients. Initially the server had 10 instances, but we restructered the environment to ease development, testing and deployment and will now have 5 instances. Reinstalling Windows Server was not really an option due to the turn around time, however I would recommend going this route if possible.

     

    When uninstalling the SQL Server Instances I had no issues up until I tried to uninstall the last remaining instance and all the end user tools. It just died on me. So manually went through all the directories and deleted the program files, and did the same in the registry.

     

    Long story short, after troubleshooting countless issues I now know the inner workings of Windows Installer. However, there are a few error messages that have me stumped and are stopping SQL Server SP2 from installing (The error messages are consistant for SQL, AS and SSRS so I have just placed the relevant info from the SQL upgrade);

     

    MSI (s) (ACBig Smile0) [08:46:42:787]: APPCOMPAT: looking for appcompat database entry with ProductCode '{2373A92B-1C1C-4E71-B494-5CA97F96AA19}'.
    MSI (s) (ACBig Smile0) [08:46:42:787]: APPCOMPAT: no matching ProductCode found in database.
    MSI (s) (ACBig Smile0) [08:46:42:787]: Transforms are not secure.
    MSI (s) (ACBig Smile0) [08:46:42:787]: Transforming table Property.

    MSI (s) (ACBig Smile0) [08:46:42:804]: Transforming table Property.

    MSI (s) (ACBig Smile0) [08:46:42:804]: Transforming table Property.

    MSI (s) (ACBig Smile0) [08:46:42:804]: Transforming table Property.

    MSI (s) (ACBig Smile0) [08:46:42:804]: Note: 1: 2262 2: Property 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:804]: Transforming table Property.

    MSI (s) (ACBig Smile0) [08:46:42:804]: Note: 1: 2262 2: Property 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:822]: Transforming table Control.

    MSI (s) (ACBig Smile0) [08:46:42:822]: Note: 1: 2262 2: Control 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:840]: Transforming table Control.

    MSI (s) (ACBig Smile0) [08:46:42:840]: Transforming table Control.

    MSI (s) (ACBig Smile0) [08:46:42:840]: Note: 1: 2262 2: Control 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:840]: Transforming table Control.

    MSI (s) (ACBig Smile0) [08:46:42:840]: Note: 1: 2262 2: Control 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:840]: Transforming table Control.

    MSI (s) (ACBig Smile0) [08:46:42:840]: Note: 1: 2262 2: Control 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:840]: Command Line: PATCH=e:\5ae5fc42ddfab8a35e97e1\HotFixSQL\Files\sqlrun_sql.msp REINSTALL=All REINSTALLMODE=omus SQLBUILD=3042 KBNUMBER=KB921896 REBOOT=ReallySuppress ADDLOCAL=ALL CURRENTDIRECTORY=e:\5ae5fc42ddfab8a35e97e1 CLIENTUILEVEL=3 CLIENTPROCESSID=968 MSIINSTANCEGUID={2373A92B-1C1C-4E71-B494-5CA97F96AA19}
    MSI (s) (ACBig Smile0) [08:46:42:840]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{11FE9DE4-380B-45FE-985E-3EC1EFF9D159}'.
    MSI (s) (ACBig Smile0) [08:46:42:840]: PROPERTY CHANGE: Adding TRANSFORMS property. Its value is 'Tongue TiedqlRun01.mst;:InstID01.mst;:InstName01.mst'.
    MSI (s) (ACBig Smile0) [08:46:42:840]: Product Code passed to Engine.Initialize:           '{2373A92B-1C1C-4E71-B494-5CA97F96AA19}'
    MSI (s) (ACBig Smile0) [08:46:42:840]: Product Code from property table before transforms: '{2373A92B-1C1C-4E71-B494-5CA97F96AA19}'
    MSI (s) (ACBig Smile0) [08:46:42:840]: Product Code from property table after multiple instance transforms: '{2373A92B-1C1C-4E71-B494-5CA97F96AA19}'
    MSI (s) (ACBig Smile0) [08:46:42:840]: Product Code from property table after transforms:  '{2373A92B-1C1C-4E71-B494-5CA97F96AA19}'
    MSI (s) (ACBig Smile0) [08:46:42:840]: Product not registered: beginning first-time install
    MSI (s) (ACBig Smile0) [08:46:42:840]: PROPERTY CHANGE: Adding ProductState property. Its value is '1'.
    MSI (s) (ACBig Smile0) [08:46:42:840]: Entering CMsiConfigurationManager:Tongue TiedetLastUsedSource.
    MSI (s) (ACBig Smile0) [08:46:42:840]: Specifed source is already in a list.
    MSI (s) (ACBig Smile0) [08:46:42:840]: User policy value 'SearchOrder' is 'nmu'
    MSI (s) (ACBig Smile0) [08:46:42:840]: Adding new sources is allowed.
    MSI (s) (ACBig Smile0) [08:46:42:840]: Package name retrieved from configuration data: 'SqlRun_SQL.msi'
    MSI (s) (ACBig Smile0) [08:46:42:840]: Determined that existing product (either this product or the product being upgraded with a patch) is installed per-machine.
    MSI (s) (ACBig Smile0) [08:46:42:840]: Transforming table Error.

    MSI (s) (ACBig Smile0) [08:46:42:840]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:857]: Transforming table Error.

    MSI (s) (ACBig Smile0) [08:46:42:875]: Transforming table Error.

    MSI (s) (ACBig Smile0) [08:46:42:875]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:875]: Transforming table Error.

    MSI (s) (ACBig Smile0) [08:46:42:875]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:875]: Transforming table Error.

    MSI (s) (ACBig Smile0) [08:46:42:875]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:875]: Note: 1: 2262 2: AdminProperties 3: -2147287038
    MSI (s) (ACBig Smile0) [08:46:42:875]: Machine policy value 'DisableMsi' is 1
    MSI (s) (ACBig Smile0) [08:46:42:875]: Machine policy value 'AlwaysInstallElevated' is 0
    MSI (s) (ACBig Smile0) [08:46:42:875]: User policy value 'AlwaysInstallElevated' is 0
    MSI (s) (ACBig Smile0) [08:46:42:875]: Product {2373A92B-1C1C-4E71-B494-5CA97F96AA19} is admin assigned: LocalSystem owns the publish key.
    MSI (s) (ACBig Smile0) [08:46:42:875]: Product {2373A92B-1C1C-4E71-B494-5CA97F96AA19} is managed.
    MSI (s) (ACBig Smile0) [08:46:42:875]: Running product '{2373A92B-1C1C-4E71-B494-5CA97F96AA19}' with elevated privileges: Product is assigned.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding PATCH property. Its value is 'e:\5ae5fc42ddfab8a35e97e1\HotFixSQL\Files\sqlrun_sql.msp'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding REINSTALL property. Its value is 'All'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding REINSTALLMODE property. Its value is 'omus'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding SQLBUILD property. Its value is '3042'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding KBNUMBER property. Its value is 'KB921896'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'e:\5ae5fc42ddfab8a35e97e1'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '968'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: PROPERTY CHANGE: Adding MSIINSTANCEGUID property. Its value is '{2373A92B-1C1C-4E71-B494-5CA97F96AA19}'.
    MSI (s) (ACBig Smile0) [08:46:42:875]: Product {2373A92B-1C1C-4E71-B494-5CA97F96AA19} is admin assigned: LocalSystem owns the publish key.
    MSI (s) (ACBig Smile0) [08:46:42:875]: Product {2373A92B-1C1C-4E71-B494-5CA97F96AA19} is managed.
    MSI (s) (ACBig Smile0) [08:46:42:892]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server Database Services 2005 ENU (KB921896)' could not be installed. Error code 1651. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log.

    MSI (s) (ACBig Smile0) [08:46:42:910]: Attempting to delete file C:\WINDOWS\Installer\872d8.msp
    MSI (s) (ACBig Smile0) [08:46:42:927]: MainEngineThread is returning 1651
    Info 1651.Windows Installer does not permit patching of managed advertised products. At least one feature of the product must be installed before applying the patch.
    D:\Software\SQL Server 2005 Developer Edition\Servers\Setup\SqlRun_SQL.msi

    MSI (c) (C8:5C) [08:46:43:050]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
    MSI (c) (C8:5C) [08:46:43:050]: MainEngineThread is returning 1651

     

     

    Anybody have any ideas?

    Wednesday, June 25, 2008 7:15 AM

Answers

  • Right, it appears all the hacking I did has worked to an extent but here is my observation;

     

    When uninstalling SQL Server 2005 from a server with the intention of reinstalling it, you are going about it all wrong. It will be far quicker to just reinstall the server from scratch. I have been fighting with the server for 3 days, whereas it would've taken me 1 day to fully rebuild the machine - which was not an option in my case as it would've taken a week just to get the change request approved.

     

    The problem seems to lie with Windows Installer. It appears that while the SQL Server Installation is removed, the patches and references to the patches are not. By reading the error messages in the installation logs and removing references to the orphaned packages in the Registry you can overcome the problem - but it is very time consuming.

     

    You'll generally get a message saying msd2143234.msi cannot be found. Just search the registry for the file and delete the key it falls under, generally the key has a long number like 0162F4AA1FF5DCD46ABFCB2A0DA94634 and is generally somewhere in the HKEY_CLASSES_ROOT\Installer\Patches\ folder.

     

    Be 100% comfortable with what you are doing in the registry, you either have a feel for it or you don't!

     

     

     

    Wednesday, June 25, 2008 8:55 AM

All replies

  • Thats the trick, "At least one feature" is installed and it works!

    I just can't get SP2 to install.

     

    Wednesday, June 25, 2008 7:32 AM
  • Right, it appears all the hacking I did has worked to an extent but here is my observation;

     

    When uninstalling SQL Server 2005 from a server with the intention of reinstalling it, you are going about it all wrong. It will be far quicker to just reinstall the server from scratch. I have been fighting with the server for 3 days, whereas it would've taken me 1 day to fully rebuild the machine - which was not an option in my case as it would've taken a week just to get the change request approved.

     

    The problem seems to lie with Windows Installer. It appears that while the SQL Server Installation is removed, the patches and references to the patches are not. By reading the error messages in the installation logs and removing references to the orphaned packages in the Registry you can overcome the problem - but it is very time consuming.

     

    You'll generally get a message saying msd2143234.msi cannot be found. Just search the registry for the file and delete the key it falls under, generally the key has a long number like 0162F4AA1FF5DCD46ABFCB2A0DA94634 and is generally somewhere in the HKEY_CLASSES_ROOT\Installer\Patches\ folder.

     

    Be 100% comfortable with what you are doing in the registry, you either have a feel for it or you don't!

     

     

     

    Wednesday, June 25, 2008 8:55 AM
  • Hi Dillon

     

    Alternatively you might want to try and use the <msiexec> DOS command, becuase SQL Server 2005 uses the Windows Installer 3.1, it might be easier to either repair the instance of the installer with the command and then remove SQL Server from the server. Just a thought. Type in the command, and it will print out a while list of options for you to run through. (Windows Dialog Box!!!) Found that strange too :-) ha ha.

     

    For future reference, if you perhaps happen to run into the windows errors revolving around the SQL Server then use the <sfc /scannow> command, i've had to use that in the past.

     

    Kind Regards

    Carel Greaves

     

    Thursday, June 26, 2008 7:49 AM