Rule "SQL Server "Denali" CTP3 Feature Upgrade" failed. by Anita LaJuett

Why hasn't an ugrade PID been made available via MSDN Subscription? How can we test upgrading a SQL Server 2008 R2 Enterprise installation to SQL Server 2012 when the upgrade path is not supported without a PID?

Sub:Unable to Upgrade to Denali CTP3 . Let me know if you have any Suggestions.

Below is SQL Version & Windows Version I am ON :

Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

Windows Server 2008 SP2 .


Below is the Error I get from the Installation Log while Upgrading:

(15) 2011-10-21 18:29:37 Slp: Rule evaluation message: The selected instance of SQL Server 2005 is not clustered or is installed into only one group.
(15) 2011-10-21 18:29:37 Slp: Send result to channel : RulesEngineNotificationChannel
(15) 2011-10-21 18:29:37 Slp: Initializing rule     : SQL Server "Denali" CTP3 Feature Upgrade
(15) 2011-10-21 18:29:37 Slp: Rule is will be executed : True
(15) 2011-10-21 18:29:37 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.SkuUpgradeRule
(15) 2011-10-21 18:29:37 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' looking for previous version upgrade data for feature package 'sql_as_Cpu64'.
(15) 2011-10-21 18:29:37 Slp: -- SkuUpgradeRule : Found feature package 'sql_as_ctp6_Cpu64' with SkuValue=ENTERPRISE (Enterprise) ProductVersion=10.2.4000.0
(15) 2011-10-21 18:29:37 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' found sourceVersion 10.0 and edition ENTERPRISE for feature package 'sql_as_Cpu64'.
(15) 2011-10-21 18:29:37 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix checking sku matrix for sourceVersion=10.0 sourceEdition=ENTERPRISE (Enterprise) sourceArchitecture=X64 targetEdition=EVAL (Evaluation) targetArchitecture=X64
(15) 2011-10-21 18:29:37 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix source and target architecture match.
(15) 2011-10-21 18:29:37 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix did not find a match in sku matrix .
(15) 2011-10-21 18:29:37 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' feature package 'sql_as_Cpu64' is blocking upgrade.
(15) 2011-10-21 18:29:37 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' detection result: IsValidFeatureUpgrade=False
(15) 2011-10-21 18:29:37 Slp: Evaluating rule        : FeatureUpgradeMatrixCheck
(15) 2011-10-21 18:29:37 Slp: Rule running on machine: TK5CATROPSSQL04
(15) 2011-10-21 18:29:37 Slp: Rule evaluation done : Failed
(15) 2011-10-21 18:29:37 Slp: Rule evaluation message: The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server "Denali" CTP3 version and edition upgrade in Books Online.
(15) 2011-10-21 18:29:37 Slp: Send result to channel : RulesEngineNotificationChannel
(15) 2011-10-21 18:29:37 Slp: Initializing rule     : Incomplete upgrade

Hello,

Per Bhupinder's feedback, we are closing this by design. Thanks for contacting Microsoft.

Regards,
SQL Server

Hi Anita,

I have reviewed the setup logs that you uploaded and found the reason why you are getting that message for upgrade Ruled failed.

From Detail.txt
----------------------------------------------------------------------------------------------------------------------------------
(12) 2011-07-27 11:50:28 Slp: Initializing rule     : SQL Server "Denali" CTP3 Feature Upgrade
(12) 2011-07-27 11:50:28 Slp: Rule is will be executed : True
(12) 2011-07-27 11:50:28 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.SkuUpgradeRule
(12) 2011-07-27 11:50:28 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' looking for previous version upgrade data for feature package 'sql_as_Cpu64'.
(12) 2011-07-27 11:50:28 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' feature package 'sql_as_Cpu64' found no upgrade features.
(12) 2011-07-27 11:50:28 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' looking for previous version upgrade data for feature package 'sql_engine_core_inst_Cpu64'.
(12) 2011-07-27 11:50:28 Slp: -- SkuUpgradeRule : Found feature package 'sql_engine_core_inst_ctp6_Cpu64' with SkuValue=ENTERPRISE (Enterprise) ProductVersion=10.51.2500.0
(12) 2011-07-27 11:50:28 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' found sourceVersion 10.0 and edition ENTERPRISE for feature package 'sql_engine_core_inst_Cpu64'.
(12) 2011-07-27 11:50:28 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix checking sku matrix for sourceVersion=10.0 sourceEdition=ENTERPRISE (Enterprise) sourceArchitecture=X64 targetEdition=EVAL (Evaluation) targetArchitecture=X64
(12) 2011-07-27 11:50:28 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix source and target architecture match.
(12) 2011-07-27 11:50:28 Slp: -- SkuPublicConfigObject : ValidateSkuMatrix did not find a match in sku matrix .
(12) 2011-07-27 11:50:28 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' feature package 'sql_engine_core_inst_Cpu64' is blocking upgrade.
(12) 2011-07-27 11:50:28 Slp: -- SkuUpgradeRule : Rule 'FeatureUpgradeMatrixCheck' detection result: IsValidFeatureUpgrade=False
(12) 2011-07-27 11:50:28 Slp: Evaluating rule        : FeatureUpgradeMatrixCheck
(12) 2011-07-27 11:50:28 Slp: Rule running on machine: KNXPNA1
(12) 2011-07-27 11:50:28 Slp: Rule evaluation done : Failed
(12) 2011-07-27 11:50:28 Slp: Rule evaluation message: The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server "Denali" CTP3 version and edition upgrade in Books Online.
----------------------------------------------------------------------------------------------------------------------------------

=> From above logs I see that you are trying to upgrade SQL 2008 R2 ENTERPRISE edition to Denali Evaluation Edition.
=> This upgrade path is not supported as you cannot upgrade to Evaluation Edition of Denali.
=> In this case you need to get an upgrade PID.
=> I would recommend you to get in touch with you TAP PM and he will help you get one with which you can test it.
=> You can reply to the forum post or send me an email to bhupinder.sachdeva@microsoft.com if you have more questions for me.

Thanks,
Bhupinder.

Hi Anita,

I have received the setup logs that you have uploaded. I will analyze them and get back to you on Monday.
Please let me know your contact details and best time to call you in case I need to work with you over phone on the server. You can send your contact details to me at bhupinder.sachdeva@microsoft.com

Please note that my working hours are from 9:00 AM PST to 6:00 PM PST.

The setup logs have been uploaded.
Thanks!
Anita

Hello,

You can locate the logs under %Program Files%\Microsoft SQL Server\110\Setup Bootstrap\Log

Thank you for your help.

SQL Server

Bhupinder,
I would be happy to do this if you will kindly tell me where the log will be located.
All I find is:
FeatureUpgradeMatrixCheck Checks whether the specified feature meets SQL Server "Denali" CTP3 upgrade requirements. Failed The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server "Denali" CTP3 version and edition upgrade in Books Online.
And it will not let me go past the "Ugrade Rules" screen.
Thanks,
Anita

Hi Anita,

I am sorry I missed that you are trying to upgrade from SQL 2008 R2 to Denali CTP3 which is fully supported. We will look into this. Can you please upload the setup logs for us to start our investigation.

Thanks,
Bhupinder Sachdeva
Denali Beta Engineer.

Hi Anita,

Thank you for sharing your feedback with us. I see that you have raised this issue on 10.50.250000 i.e. SQL 2008 R2. As this issue is happening on a released product, I would encourage you to open a regular ticket with CSS and work with them. You can continue to file bugs if you are facing issues with Denali Beta product.

Thanks,
Bhupinder Sachdeva
Denali Beta Engineer.