Upgrade from SQL 2005 to SQL 2008 might fail with MsiGetProductInfo error

Upgrade from SQL 2005 to SQL 2008 might fail with MsiGetProductInfo error

Rate This
  • Comments 32

Consider a scenario where an upgrade from SQL 2005 to SQL 2008 fails with the following messages while installing Setup Support Files.

 

********************************************************

TITLE: SQL Server Setup failure.

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

SQL Server Setup has encountered the following error:

MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code =

'{0826F9E4-787E-481D-83E0-BC6A57B056D5}'. Error code: 1605..

 

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

********************************************************

From Detail_ComponentUpdate.txt -

********************************************************

2009-03-16 22:00:59 Slp: Inner exceptions are being indented

2009-03-16 22:00:59 Slp:

2009-03-16 22:00:59 Slp: Exception type: System.InvalidOperationException

2009-03-16 22:00:59 Slp: Message:

2009-03-16 22:00:59 Slp: MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{0826F9E4-787E-481D-83E0-BC6A57B056D5}'. Error code: 1608.

2009-03-16 22:00:59 Slp: Stack:

2009-03-16 22:00:59 Slp: at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallPropertyByProductCode(PackageInstallProperty pkg, String prodCode)

2009-03-16 22:00:59 Slp: at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.FillInstallProperty(PackageInstallProperty pkg)

2009-03-16 22:00:59 Slp: at Microsoft.SqlServer.Configuration.MsiExtension.SetFeatureInstallStateAction.ExecuteAction(String actionId)

2009-03-16 22:00:59 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)

2009-03-16 22:00:59 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)

2009-03-16 22:00:59 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
********************************************************

 

 

SOLUTION (Worked at my end)

*********************************

Get the Product Code = '{0826F9E4-787E-481D-83E0-BC6A57B056D5}' from the error message that you are getting.

Byte reverse the first part from 0826F9E4 to 4E9F6280.

Search in the registry under HKEY_CLASSES_ROOT\Installer\UpgradeCodes and try to find a match.

Take a backup of the registry and delete the parent key.

Re-run the Upgrade and if it fails again for a different GUID, then repeat the steps stated above.

In my case, I had to repeat these steps thrice as there were 3 other locations where I needed to change the product code. Then the setup was successful.

 

Note: If your Product Code is different, you would like to see Search hints to find the appropriate GUID .

 

Note: This post should not be treated as the Microsoft’s Recommendation or Resolution to the problem, it is only a workaround which worked in our environment and so we would like to share it.

 

 

Dibakar Dharchoudhury

SE, Microsoft SQL Server,

 

Reviewed By,

Rakesh Singh,

TL, Microsoft SQL Server

Leave a Comment
  • Please add 3 and 7 and type the answer here:
  • Post
  • This solution worked for me! Thanks!

  • I had to go through the entire registry, not just the HKEY_CLASSES_ROOT but it ultimately worked for me.  Thanks!

  • Solved the problem for me. Many thanks!

  • Worked for me as well, installing a new SQL 2008 R2 instance onto a cluster that already had two SQL 2008 instances on it - thanks!

  • THANK YOU!!!

  • Still a good fix in 2011...  Thanks

  • How i can solve the following error MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{D441BD04-E548-4F8E-97A4-1B66135BAAA8}'. Error code: 1605..

  • Thank You! Solution worked for me to install SQL 2k8 r2.

  • My code from error message is 72DE3C67-FB48-450E-8BEA-4EB1B3B5355D but  I can not find it in registry. So, how I can do? My OS is XP pro and work in domain. Please help me.

  • Rakesh, I have seen this post all over the web, however, I do it and nothing seems to work. I am getting the following Error.

    MsiGetProductInfo failed to retrieve ProductVersion

    for package with Product Code = '{C942A025-A840-4BF2-8987-849C0DD44574}'. Error code: 1605.

    Every attempt to follow these instructions comes up with no resolution and the same error.

    It would be really nice to know how to fix this problem once and for all.

    Hank Freeman

    hfreeman@msn.com

  • Hi Rakesh,

    I installed SQL server successfully. Then, I uninstalled it because I forget password and reinstalled it.

    The error was released like your case. And, I found product code in

    <HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\Folders>

    and try to reverse like your way but it doesn't word.

    If you have some ideas to help me solve this issue, please send to my email leanhvu1989@yahoo.com

    Thank in advance.

  • hi i removed sql server 2008r2 and i want reinstall sql server 2008r2 and confront

    error:

    " SQL Server Setup has encountered the following error:

    MiGetProductInfo failed to retrieve ProductVersion for package Code ='{72DE3C67-FB48-450E-8BEA-4EB1B3B5355D}' Error Code = 1608.. "

  • Hi Dibakar,

    This solution worked like a wonder. I had encountered this error due to improper uninstallation of SQL server 2008.

    You are right about repeating 3 times...

    Thanks a lot. Saved me hell lot of time.

    Regards,

    Mohan

  • yes ! great !

    sometimes need to repeat the search 4 or 5 times...

  • This solution worked for me! Thanks!

Page 1 of 3 (32 items) 123