MsiGetProductInfo failed to retrieve ProductVersion for package during install

Question

I keep getting this when trying to install SQL Server 2008 Workstation Components on a Vista Premium PC that has SQL Server 2005 tools on it.

MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.

I have tried all kinds of cleanup of the 2005 version to no avail (Uninstall, MS Install Cleanup Utility, Registry cleanup, Old SQL Server directory deletes, etc... ).

Wipe PC and start over is not an option.

Any suggestions?  What the heck is it looking for? 

I have reinstalled my SQL Server 2005 tools and have no mention of '2243F21A-E132-44F7-BA13-024D0845C815' in my registry, but 2008 tools still do not want to install.



Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -289740454
  Exit facility code:            1722
  Exit error code:               59738
  Exit message:                  MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
  Start time:                    2008-09-04 14:33:37
  End time:                      2008-09-04 14:38:32
  Requested action:              ComponentUpdate
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_143319\Detail_ComponentUpdate.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.1600.22%26EvtType%3d0xD94919CC%400xEEBAE95A

Machine Properties:
  Machine name:                  ORBIT
  Machine processor count:       2
  OS version:                    Windows Vista
  OS service pack:               Service Pack 1
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x86
  Process architecture:          32 Bit
  OS clustered:                  No

Package properties:
  Description:                   SQL Server Database Services 2008
  SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
  ProductName:                   SQL2008
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         C:\Temp\Zips and ISOs\SQLServer\SQLServer2008Standard\x86\setup\
  Installation edition:          STANDARD

User Input Settings:
  ACTION:                        ComponentUpdate
  CONFIGURATIONFILE:            
  HELP:                          False
  INDICATEPROGRESS:              False
  MEDIASOURCE:                   C:\Temp\Zips and ISOs\SQLServer\SQLServer2008Standard\
  PID:                           *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_143319\ConfigurationFile.ini

Detailed results:

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_143319\SystemConfigurationCheck_Report.htm

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

Exception type: System.InvalidOperationException
    Message:
        MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
    Data:
      DisableWatson = true
    Stack:
        at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
        at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
        at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.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)

Answer 1

One clarification.... this is happening on Vista Ultimate 32 bit

I also tried installing the tools via command line using:  setup /Action=Install /FEATURES=Tools

Here is what the Detail_ComponentUpdate.txt file has in it (towards bottom):

2008-09-04 16:00:12 Slp: Package ID SqlWriter_Cpu32: NotInstalled
2008-09-04 16:00:12 Slp: Package ID BOL_Cpu32: NotInstalled
2008-09-04 16:00:12 Slp: Package ID BestPracticesPolicies_Cpu32: NotInstalled
2008-09-04 16:00:12 Slp: Package ID SyncServicesADO_Cpu32: NotInstalled
2008-09-04 16:00:12 Slp: Package ID Synchronization_Cpu32: NotInstalled
2008-09-04 16:00:12 Slp: Error: Action "CuSetFeatureInstallStateAction" threw an exception during execution.
2008-09-04 16:00:12 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605. ---> System.InvalidOperationException: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)
2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2008-09-04 16:00:12 Slp:    --- End of inner exception stack trace ---
2008-09-04 16:00:12 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2008-09-04 16:00:15 Slp: Received request to add the following file to Watson reporting: C:\Users\sa\AppData\Local\Temp\tmp996.tmp
2008-09-04 16:00:15 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2008-09-04 16:00:15 Slp: Inner exceptions are being indented
2008-09-04 16:00:15 Slp:
2008-09-04 16:00:15 Slp: Exception type: System.InvalidOperationException
2008-09-04 16:00:15 Slp:     Message:
2008-09-04 16:00:15 Slp:         MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
2008-09-04 16:00:15 Slp:     Stack:
2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)
2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
2008-09-04 16:00:15 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2008-09-04 16:00:20 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_155937\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2008-09-04 16:00:21 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_155937\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2008-09-04 16:00:21 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080904_155937\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2008-09-04 16:00:22 Slp: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
2008-09-04 16:00:22 Slp: Watson bucket for exception based failure has been created
2008-09-04 16:00:22 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2008-09-04 16:00:22 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
2008-09-04 16:00:22 Slp: Sco: Attempting to get registry value DW0200
2008-09-04 16:00:53 Slp: Submitted 1 of 1 failures to the Watson data repository
2008-09-04 16:00:53 Slp:
2008-09-04 16:00:53 Slp: ----------------------------------------------------------------------
2008-09-04 16:00:53 Slp:
2008-09-04 16:00:53 Slp: Error result: -289740454
2008-09-04 16:00:53 Slp: Result facility code: 1722
2008-09-04 16:00:53 Slp: Result error code: 59738

Answer 2

Conor Cunningham's Blog saved me on this one.  He was describing a very similar error also resulting in the 1605 error with a MsiGetProductInfo failed message.

In my case I took the guid 2243F21A-E132-44F7-BA13-024D0845C815 and used the first part of it 2243F21A, I then reversed that to be A12F3422 and searched within the registry key HKCR\Installer\UpgradeCodes for matches.

I got one match and deleted its parent.

My install is currently running (sailed past the earlier error).

Conor's Blog is at http://www.sqlskills.com/blogs/conor/CommentView,guid,a044bb7f-bfb6-4f4c-9a94-3a8687a33105.aspx

Answer 3

I had the same issue today and this solved it for me.  Thanks Henrik.

Ben

Answer 4

It's solved my problem too. Thanks to Conor

Answer 5

Conor is the King! Saved me too.

 

Answer 6

Hi Henrik.

I only found one match of the reversed key. Should I delete this one?

Thanks

Answer 7

Hi

I get the following error please help:


2009-03-13 15:54:19 Slp: Error: Action "CuSetFeatureInstallStateAction" threw an exception during execution.
2009-03-13 15:54:20 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{4A6F34E2-09E5-4616-B227-4A26A488A6F9}'. Error code: 1605. ---> System.InvalidOperationException: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{4A6F34E2-09E5-4616-B227-4A26A488A6F9}'. Error code: 1605.
2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)
2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2009-03-13 15:54:20 Slp:    --- End of inner exception stack trace ---
2009-03-13 15:54:20 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2009-03-13 15:54:21 Slp: Received request to add the following file to Watson reporting: C:\Documents and Settings\.......\Local Settings\Temp\tmpAE.tmp
2009-03-13 15:54:21 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2009-03-13 15:54:21 Slp: Inner exceptions are being indented
2009-03-13 15:54:21 Slp:
2009-03-13 15:54:21 Slp: Exception type: System.InvalidOperationException
2009-03-13 15:54:21 Slp:     Message:
2009-03-13 15:54:21 Slp:         MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{4A6F34E2-09E5-4616-B227-4A26A488A6F9}'. Error code: 1605.
2009-03-13 15:54:21 Slp:     Stack:
2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)
2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)
2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)
2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
2009-03-13 15:54:21 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2009-03-13 15:54:32 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2009-03-13 15:54:32 Slp: Sco: Unable to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_, Win32 error 2
2009-03-13 15:54:32 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2009-03-13 15:54:32 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2009-03-13 15:54:32 Slp: Sco: Unable to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090313_155317\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_, Win32 error 2
2009-03-13 15:54:33 Slp: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{4A6F34E2-09E5-4616-B227-4A26A488A6F9}'. Error code: 1605.
2009-03-13 15:54:34 Slp: Watson bucket for exception based failure has been created
2009-03-13 15:54:34 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2009-03-13 15:54:34 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
2009-03-13 15:54:34 Slp: Sco: Attempting to get registry value DW0200
2009-03-13 15:54:37 Slp: Submitted 1 of 1 failures to the Watson data repository
2009-03-13 15:54:42 Slp:
2009-03-13 15:54:42 Slp: ----------------------------------------------------------------------
2009-03-13 15:54:42 Slp:
2009-03-13 15:54:42 Slp: Error result: -289740454
2009-03-13 15:54:42 Slp: Result facility code: 1722
2009-03-13 15:54:42 Slp: Result error code: 59738

Answer 8

I got the error code 1608 while installing SQL Server 2008 Express and it worked for me aswell. Be aware that you might find (I did) a folder in the registry with these reversed numbers in the "HKCR\Installer\Products" and that isnt the one to delete. You should look for a key with that name and then delete its "folder".
Thanks for the help

Answer 9

Sorry Kruz, did you find solution ragerding this issue ?

Because I'm also stumble in the same problem and still I'm investigation on that from long time without success ...

Thanks in advance for replay.

Answer 10

Sorry unfortunately not, I have given up completely :-( Can anyone help???

Answer 11

this shows how to manually uninstall an instance of sql 2008.


http://support.microsoft.com/kb/955404

Or search for

SQL Server 2008 installation fails when you try to install SQL Server a second time

Answer 12

Reversing the fist part of the guid displayed on the error (msigetproductinfo failed to retrieve... 1605) and searching within the registry, for me got 2 hits, in both cases, I deleted the root key and the installation completed without drama

Answer 13

Amen to that! :)

Answer 14

I solved !!! Finally during last July I found solution and I re-installed Sql 2008 Express without os refresh or os re-install … sorry for delay in my answer …

The solution was under my nose … as found reading some threads … the problem was GUID remained into registry ….

During my previous attempts, I deleted two, three or four times GUID showed into error box from HKCR\Installer\UpgradeCodes (HKEY_CLASSES_ROOT), without success so that I given up this solution …

So, during last July I repeated that ... I run installation for 10, 20 (sorry I don’t remember) times and I deleted GUID showed (by “regedit”), after each attempt …

After last … installation go on …

Hope it Helps …

Answer 15

What do you mean Alevann, exactly? What do I have to do?  For those of us who are not expert.... Thanks.