sql 2008 r2 sp1 upgrade active/passive node

Question

Hi,

I'm having a bit of problem upgrading Sql 2008 r2 to sp1 on an passive node running Windows 2008 R2.  A bit of background:

Sql instance is on a 4 node a/p cluster.  Node 2 holds the sql instance.  node 1,3,4 are passive.  Yesterday, one of the system admin guy attempted to install SP1 on node 1 and failed.  He than ran the upgrade (sp1) on node 2, which has the sql instance.

So basically, at the moment, node 2 with the SQL instance has sp1, while node 1,3,4 are still RTM.  they sent me the detail.txt file and I searched for 'failed' and got this:

 

2011-11-01 12:30:03 Slp: ----------------------------------------------------------------------
2011-11-01 12:30:03 Slp: Skipping property InstallMediaPath of class: InitializeMsiExtension
2011-11-01 12:30:03 Slp: Input of property will not be set due to the following failed restriction(s):
2011-11-01 12:30:03 Slp: Condition "Is the datastore flag /Scenario/GlobalFlags/IsMediaRequired set" did not pass as it returned false and true was expected.
2011-11-01 12:30:03 Slp: ---------------------------------------------------------------------- 

 

I have binged/googled for "Condition 'Is the datastore flag /Scenario/GlobalFlags/IsMediaRequired set' did not pass as it returned false and true was expected' and has yet to find an answer.

 

I have updated the server with the latest update, power cycle the server.  attempted to update again and failed.

during the gui upgrade process, I see this

Any advise would be great!

Thanks.

 

Answer 1

Additional notes since I last posted.

- node2 also has this failure

- Found out that even though I get a failure message, when I run select serverproperty('productlevel'), I get a result of SP1 instead of RTM w/ version 10.50.2500.0 instead of the version # shipped with RTM.

I have also attempted to perform a repair and this process failed.  I forgot to capture a screenshot.

I have also attempted to install SP1 on the node w/ sql instance and also failed.

This server is using mount points to store the database files, which I don't think should make much of a differences.

Answer 2

Hi Red8Rain,

Could you please post the log files of summary.txt and detail.txt for node 2 and node 1? If it is too big to post here,please upload them to some network shared folder like 'Skydriver'.

---

Best Regards,
Peja

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 3

Hi Peja,

we called CSS and they provided us w/ the fix.  sql couldn't override the existing .dll file.  we just manually overwrite the .dll and it worked afterward

Answer 4

Red8Rain:

Can you please provide exact details of what you had to do to get this to work. Here it is August 2012, and I am having the exact same issue, but with SQL Server 2008 R2 SP2 CU1. The R2 SP2 applied just fine but then, after a reboot, I attempted to install SP2 CU1, and I get the failure you are talking about.

This node is NOT a cluster node, fyi (but we do have some cluster nodes that need updating).

It is very sad that Microsoft is sending out these "bug-ridden" updates. Note also that CU1 is listed as a "HOTFIX" which, in itself is very disconcerting, but probably is the normal way to list these Cumulative Updates?

But by simply saying that you "overwrote some dll" does not help very much. Which dll? What steps did you take?

Here is a piece of the detail.txt log, where I searched for "failed":

12-08-07 07:05:31 Slp: Skipping property InstallMediaPath of class: InitializeMsiExtension
2012-08-07 07:05:31 Slp: Input of property will not be set due to the following failed restriction(s):
2012-08-07 07:05:31 Slp: Condition "Is the datastore flag /Scenario/GlobalFlags/IsMediaRequired set" did not pass as it returned false and true was expected.

Thanks for any info.

As always, any help is greatly appreciated.

Jeff

---

tnjman

p.s., Another piece of the log:

12-08-07 07:05:54 Slp: Invoking ControlService Win32 API
2012-08-07 07:05:54 Slp: Error: Failed to stop the following NT service prior to patch action: MSSQLSERVER
2012-08-07 07:05:54 Slp: Sleeping 10 seconds before retrying NT service stop request
2012-08-07 07:06:04 Slp: Sco: Attempting to stop service MSSQLSERVER, stop dependents True
2012-08-07 07:06:04 Slp: Sco: Service MSSQLSERVER has dependents... stopping dependents first
2012-08-07 07:06:04 Slp: Sco: Attempting to stop service SQLSERVERAGENT, stop dependents True
2012-08-07 07:06:04 Slp: Sco: Service SQLSERVERAGENT has dependents... stopping dependents first
2012-08-07 07:06:04 Slp: Invoking ControlService Win32 API
2012-08-07 07:06:04 Slp: Sco: Service SQLSERVERAGENT aleady at stop state
2012-08-07 07:06:04 Slp: Invoking ControlService Win32 API
2012-08-07 07:06:04 Slp: Sco: Service MSSQLSERVER stopped

2012-08-07 07:11:06 Slp: The FeatureConfigState of MSI feature SQL_Replication_Core_Inst has been adjusted to patch configuration.
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature configuration state FailedPatchConfigured for feature SQL_Replication_Core_Inst, instance MSSQL10_50.MSSQLSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to set instance feature flag ConfigurationState for machine , feature SQL_Replication_Core_Inst, instance MSSQL10_50.MSSQLSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine

2012-08-07 07:11:06 Slp: The FeatureConfigState of MSI feature SQL_FullText_Adv has been adjusted to patch configuration.
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature configuration state FailedPatchConfigured for feature SQL_FullText_Adv, instance MSSQL10_50.MSSQLSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to set instance feature flag ConfigurationState for machine , feature SQL_FullText_Adv, instance MSSQL10_50.MSSQLSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\ConfigurationState
2012-08-07 07:11:06 Slp: Sco: Attempting to set value SQL_FullText_Adv
2012-08-07 07:11:06 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\ConfigurationState, Name = SQL_FullText_Adv
2012-08-07 07:11:06 Slp: ---- Flush datastore cache before calling configuration action 'AS_cluster_disk_cluster_patch_config_Cpu64'
2012-08-07 07:11:06 Slp: ----------------------------------------------------------------------
2012-08-07 07:11:06 Slp: Running Action: AS_cluster_disk_cluster_patch_config_Cpu64
2012-08-07 07:11:06 Slp: Action Data:
2012-08-07 07:11:06 Slp:   Feature = Analysis_Server_Full_sql_as_Cpu64
2012-08-07 07:11:06 Slp:   Scenario = patch
2012-08-07 07:11:06 Slp:   Timing = ConfigRC
2012-08-07 07:11:06 Slp:   ConfigObjectType = Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterDiskPrivateConfigObject
2012-08-07 07:11:06 Slp:   FeatureName = Analysis_Server_Full
2012-08-07 07:11:06 Slp:   FeatureCpuType = Cpu64
2012-08-07 07:11:06 Slp:   FeaturePackageId = sql_as
2012-08-07 07:11:06 Slp:   InstallId = Machine[@ID='MYSERVER']/Product[@ID='SQL2008']/Instance[@ID='MSSQLSERVER']/Feature[@ID='AS_CTP5' and @RegistryPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\Setup' and @RootPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10_50.MSSQLSERVER']/Install[@ProductCode='6E2EE862-FEF9-408A-90BB-F5B4EC129C8E']
2012-08-07 07:11:06 Slp: Cluster disk operation skipped because patch is not clustered.
2012-08-07 07:11:06 Slp: SlpConfigAction.ExecuteAction(actionId: AS_cluster_disk_cluster_patch_config_Cpu64) completed
2012-08-07 07:11:06 Slp: Checkpoint: PATCH:CONFIGRC:ANALYSIS_SERVER_FULL
2012-08-07 07:11:06 Slp: Completed Action: AS_cluster_disk_cluster_patch_config_Cpu64, returned True
2012-08-07 07:11:06 Slp: ---- Flush datastore cache before calling configuration action 'cluster_disk_cluster_patch_config_Cpu64'
2012-08-07 07:11:06 Slp: ----------------------------------------------------------------------

2012-08-07 07:11:07 Slp: Sco: Attempting to check if file 'C:\Windows\system32\perf-MSSQLSERVER-sqlctr10.52.4000.0.dll' exists
2012-08-07 07:11:07 SQLEngine: --PerfmonRegistration: Failed to delete file 'C:\Windows\system32\perf-MSSQLSERVER-sqlctr10.52.4000.0.dll'. Error: Access to the path 'C:\Windows\system32\perf-MSSQLSERVER-sqlctr10.52.4000.0.dll' is denied.. Marking it to be deleted on reboot
2

2012-08-07 07:11:08 Slp: Comparing file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll' to file 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll'
2012-08-07 07:11:08 Slp: The files are different or some of them are missing
2012-08-07 07:11:08 Slp: Copying file from 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll' to C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll.
2012-08-07 07:11:08 Slp: Sco: Attempting to copy file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll' to file 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll'
2012-08-07 07:11:08 Slp: Sco: Attempting to check if file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll' exists
2012-08-07 07:11:08 Slp: Sco: Attempting to normalize directory path 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll'
2012-08-07 07:11:08 Slp: Sco: Attempting to set file full path to 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll'
2012-08-07 07:11:08 Slp: Sco: Attempting to normalize directory path 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll'
2012-08-07 07:11:08 Slp: Sco: Attempting to check if directory path 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll' is equal to path 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll'
2012-08-07 07:11:08 Slp: Sco: Attempting to check if directory path 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll' is equal to path 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll'
2012-08-07 07:11:08 Slp: Sco: Attempting to normalize directory path 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll'
2012-08-07 07:11:08 Slp: Sco: Attempting to normalize directory path 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll'
2012-08-07 07:11:08 Slp: Error: Action "Microsoft.SqlServer.Configuration.ScoExtension.VerifiedCopyFileAction" threw an exception during execution.
2012-08-07 07:11:08 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: File c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll could not be copied to file path C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll. ---> Microsoft.SqlServer.Configuration.ScoExtension.CopyFileException: File c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll could not be copied to file path C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll. ---> Microsoft.SqlServer.Configuration.Sco.ScoException: The process cannot access the file 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process. ---> System.IO.IOException: The process cannot access the file 'C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll' because it is being used by another process.
2012-08-07 07:11:08 Slp:    at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
2012-08-07 07:11:08 Slp:    at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite)
2012-08-07 07:11:08 Slp:    at Microsoft.SqlServer.Configuration.Sco.SqlFile.CopyTo(String targetFileFullPath, Boolean bCopyAcl)
2012-08-07 07:11:08 Slp:    --- End of inner exception stack trace ---


2012-08-07 07:11:08 Slp: Parameter 0 : SQL2008@RTM@KB2720425

2012-08-07 07:11:08 Slp: Parameter 1 : Microsoft.SqlServer.Configuration.ScoExtension.VerifiedCopyFileAction.ExecuteAction

2012-08-07 07:11:08 Slp: Parameter 2 : System.IO.__Error.WinIOError

2012-08-07 07:11:08 Slp: Parameter 3 : Microsoft.SqlServer.Configuration.ScoExtension.CopyFileException@1360@3

2012-08-07 07:11:08 Slp: Parameter 4 : System.IO.IOException@-2147024864

2012-08-07 07:11:08 Slp: Parameter 5 : CopyPerfCounterDllToSystemDir

2012-08-07 07:11:08 Slp: Parameter 7 : Microsoft.SqlServer.Configuration.ScoExtension.CopyFileException@CopyFileFailed

2012-08-07 07:11:08 Slp: Parameter 8 : sqlagentctr100.dll

2012-08-07 07:11:09 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\20120807_070224\MSSQLSERVER\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2012-08-07 07:11:09 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\20120807_070224\MSSQLSERVER\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2012-08-07 07:11:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120807_070224\MSSQLSERVER\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2012-08-07 07:11:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120807_070224\MSSQLSERVER\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
2012-08-07 07:11:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120807_070224\MSSQLSERVER\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2012-08-07 07:11:09 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120807_070224\MSSQLSERVER\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
2012-08-07 07:11:13 Slp: File c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\DllTmp64\sqlagentctr100.dll could not be copied to file path C:\Windows\system32\perf-MSSQL10_50.MSSQLSERVER-sqlagtctr.dll.
2012-08-07 07:11:13 Slp: Watson bucket for exception based failure has been created
2012-08-07 07:11:13 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()Error: Action "AgentPerfmonConfig" failed during execution.
2012-08-07 07:11:13 Slp: Completed Action: AgentPerfmonConfig, returned False
2012-08-07 07:11:13 Slp: ----------------------------------------------------------------------

2012-08-07 07:11:13 Slp: ----------------------------------------------------------------------
2012-08-07 07:11:13 Slp: Skipping Action: UpdateClusterResource
2012-08-07 07:11:13 Slp: Action is being skipped due to the following restrictions:
2012-08-07 07:11:13 Slp: Condition "Is cluster" did not pass as it returned false and true was expected.
2012-08-07 07:11:13 Slp: Error: Action "AgentPatch_AgentPatching_Cpu64" failed during execution.
2012-08-07 07:11:13 Slp: Completed Action: AgentPatch_AgentPatching_Cpu64, returned False
2012-08-07 07:11:13 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature MPT_AGENT_CORE_CNI, instance MSSQL10_50.MSSQLSERVER, machine name MYSERVER
2012-08-07 07:11:13 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MYSERVER
2012-08-07 07:11:13 Slp: Sco: Attempting to open registry subkey
2012-08-07 07:11:13 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\UpgradeIncompleteState
2012-08-07 07:11:13 Slp: Sco: Attempting to get registry value MPT_AGENT_CORE_CNI
2012-08-07 07:11:13 Slp: Sco: Attempting to get feature configuration state for feature MPT_AGENT_CORE_CNI, instance MSSQL10_50.MSSQLSERVER
2012-08-07 07:11:13 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature MPT_AGENT_CORE_CNI, instance MSSQL10_50.MSSQLSERVER, machine name MYSERVER
2012-08-07 07:11:13 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MYSERVER
2012-08-07 07:11:13 Slp: Sco: Attempting to open registry subkey
2012-08-07 07:11:13 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\ConfigurationState
2012-08-07 07:11:13 Slp: Sco: Attempting to get registry value MPT_AGENT_CORE_CNI
2012-08-07 07:11:13 Slp: The FeatureConfigState of MSI feature MPT_AGENT_CORE_CNI has been adjusted to patch configuration.
2012-08-07 07:11:14 Slp: ---- Flush datastore cache before calling configuration action 'FulltextConfigAction_patch_configrc_Cpu64'
2012-08-07 07:11:14 Slp: ----------------------------------------------------------------------
2012-08-07 07:11:14 Slp: ----------------------------------------------------------------------
2012-08-07 07:11:14 Slp: Running Action: cluster_group_cluster_patch_startup_Cpu64
2012-08-07 07:11:14 Slp: Action Data:
2012-08-07 07:11:14 Slp:   Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64
2012-08-07 07:11:14 Slp:   Scenario = patch
2012-08-07 07:11:14 Slp:   Timing = Startup
2012-08-07 07:11:14 Slp:   ConfigObjectType = Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterGroupPrivateConfigObject
2012-08-07 07:11:14 Slp:   FeatureName = SQL_Engine_Core_Inst
2012-08-07 07:11:14 Slp:   FeatureCpuType = Cpu64
2012-08-07 07:11:14 Slp:   FeaturePackageId = sql_engine_core_inst
2012-08-07 07:11:14 Slp:   InstallId = Machine[@ID='MYSERVER']/Product[@ID='SQL2008']/Instance[@ID='MSSQLSERVER']/Feature[@ID='SQLEngine_CTP5' and @RegistryPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\Setup' and @RootPath='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER']/Install[@ProductCode='FBD367D1-642F-47CF-B79B-9BE48FB34007']
2012-08-07 07:11:14 Slp: Cluster group operation being skipped because the feature is not clustered.
2012-08-07 07:11:14 Slp: SlpConfigAction.ExecuteAction(actionId: cluster_group_cluster_patch_startup_Cpu64) completed
2012-08-07 07:11:14 Slp: Checkpoint: PATCH:STARTUP:SQL_ENGINE_CORE_INST
2012-08-07 07:11:14 Slp: Completed Action: cluster_group_cluster_patch_startup_Cpu64, returned True
2012-08-07 07:11:14 Slp: Action "ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Patch_Startup_postmsi" will return false due to the following conditions:
2012-08-07 07:11:14 Slp: Condition "Feature dependency condition for action: ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Patch_Startup_postmsi The condition tests feature: MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64. There are 2 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.
2012-08-07 07:11:14 Slp: Condition is false because the required feature MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64 failed in result Result
2012-08-07 07:11:14 Slp: ---- Flush datastore cache before calling configuration action 'FulltextConfigAction_patch_startup_Cpu64'
2012-08-07 07:11:14 Slp: ----------------------------------------------------------------------

12-08-07 07:11:06 Slp: Sco: Attempting to get registry value SQL_WRITER
2012-08-07 07:11:06 Slp: The FeatureConfigState of MSI feature SQL_WRITER has been adjusted to patch configuration.
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature configuration state FailedPatchConfigured for feature SQL_WRITER
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_WRITER
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2012-08-07 07:11:06 Slp: Sco: Attempting to set value SQL_WRITER
2012-08-07 07:11:06 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_WRITER
2012-08-07 07:11:06 Slp: Sco: Attempting to get feature configuration state for feature CommonFiles, version
2012-08-07 07:11:06 Slp: Sco: Attempting to get feature flag ConfigurationState for feature CommonFiles from machine name MYSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MYSERVER

12-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2012-08-07 07:11:06 Slp: Sco: Attempting to get registry value CommonFiles
2012-08-07 07:11:06 Slp: The FeatureConfigState of MSI feature CommonFiles has been adjusted to patch configuration.
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature configuration state FailedPatchConfigured for feature CommonFiles
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature CommonFiles
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2012-08-07 07:11:06 Slp: Sco: Attempting to set value CommonFiles

12-08-07 07:11:06 Slp: Sco: Attempting to get registry value SQL_Engine_Core_Shared
2012-08-07 07:11:06 Slp: The FeatureConfigState of MSI feature SQL_Engine_Core_Shared has been adjusted to patch configuration.
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature configuration state FailedPatchConfigured for feature SQL_Engine_Core_Shared
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_Engine_Core_Shared
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey

12-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2012-08-07 07:11:06 Slp: Sco: Attempting to get registry value SQL_PowerShell_Engine_CNS
2012-08-07 07:11:06 Slp: The FeatureConfigState of MSI feature SQL_PowerShell_Engine_CNS has been adjusted to patch configuration.
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature configuration state FailedPatchConfigured for feature SQL_PowerShell_Engine_CNS
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_PowerShell_Engine_CNS
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2012-08-07 07:11:06 Slp: Sco: Attempting to set value SQL_PowerShell_Engine_CNS
2012-08-07 07:11:06 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_PowerShell_Engine_CNS
2012-08-07 07:11:06 Slp: Sco: Attempting to get instance feature flag UpgradeIncomplete for feature RS_Server_Adv, instance MSRS10_50.MSSQLSERVER, machine name MYSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MYSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\UpgradeIncompleteState
2012-08-07 07:11:06 Slp: Sco: Attempting to get registry value RS_Server_Adv
2012-08-07 07:11:06 Slp: Sco: Attempting to get feature configuration state for feature RS_Server_Adv, instance MSRS10_50.MSSQLSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to get instance feature flag ConfigurationState for feature RS_Server_Adv, instance MSRS10_50.MSSQLSERVER, machine name MYSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MYSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey

12-08-07 07:11:06 Slp: The FeatureConfigState of MSI feature SQL_SSMS_Adv has been adjusted to patch configuration.
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature configuration state FailedPatchConfigured for feature SQL_SSMS_Adv
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature SQL_SSMS_Adv
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2012-08-07 07:11:06 Slp: Sco: Attempting to set value SQL_SSMS_Adv
2012-08-07 07:11:06 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState, Name = SQL_SSMS_Adv
2012-08-07 07:11:06 Slp: Sco: Attempting to get feature configuration state for feature SQL_PowerShell_Tools_ANS, version
2012-08-07 07:11:06 Slp: Sco: Attempting to get feature flag ConfigurationState for feature SQL_PowerShell_Tools_ANS from machine name MYSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine MYSERVER
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey
2012-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2012-08-07 07:11:06 Slp: Sco: Attempting to get registry value SQL_PowerShell_Tools_ANS
2012-08-07 07:11:06 Slp: The FeatureConfigState of MSI feature SQL_PowerShell_Tools_ANS has been adjusted to patch configuration.

12-08-07 07:11:06 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState
2012-08-07 07:11:06 Slp: Sco: Attempting to get registry value Tools_Legacy_Full
2012-08-07 07:11:06 Slp: The FeatureConfigState of MSI feature Tools_Legacy_Full has been adjusted to patch configuration.
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature configuration state FailedPatchConfigured for feature Tools_Legacy_Full
2012-08-07 07:11:06 Slp: Sco: Attempting to set feature flag ConfigurationState for machine , feature Tools_Legacy_Full
2012-08-07 07:11:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine

12-08-07 07:12:14 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\ConfigurationState
2012-08-07 07:12:14 Slp: Sco: Attempting to set value SQL_Engine_Core_Inst
2012-08-07 07:12:14 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\ConfigurationState, Name = SQL_Engine_Core_Inst
2012-08-07 07:12:14 Slp: Action "ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Patch_Finalize_finalize" will return false due to the following conditions:
2012-08-07 07:12:14 Slp: Condition "Feature dependency condition for action: ConfigEvent_MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64_Patch_Finalize_finalize The condition tests feature: MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64. There are 2 dependant features. The feature is tested for results: ValidateResult, Result, CleanupResult." did not pass as it returned false and true was expected.
2012-08-07 07:12:14 Slp: Condition is false because the required feature MPT_AGENT_CORE_CNI_sql_engine_core_inst_Cpu64 failed in result Result

Answer 5

Hi TNJMAN,

I posted a bit more detailed about this on my blog at: http://cbtr.net/red8rain/2011/11/15/error-applying-sp1-to-sql-2008-r2/

I hope that would be helpful for you.