SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unable to upgrade SQL Server 2008 r2 cluster to SQL Server 2012 SP1, failes with Failed to retrieve...


Unable to upgrade SQL Server 2008 r2 cluster to SQL Server 2012 SP1, failes with Failed to retrieve data for this request

Author
Message
evgkib
evgkib
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 18
I don't really understand why it would fail. Sometimes when I start the setup process it is fine, next time it doesn't work. I'm not comfortable continuing with the upgrade it being flaky like this. I'm just wondering what could cause this? Here's the output from the logs:

(01) 2013-09-21 13:40:18 Slp: Running Action: RunRemoteDiscoveryAction
(01) 2013-09-21 13:40:18 Slp: Running discovery on local machine
(01) 2013-09-21 13:40:20 Slp: Discovery on local machine is complete
(01) 2013-09-21 13:40:20 Slp: Running discovery on remote machine: PC1N1
(01) 2013-09-21 13:41:31 Slp: Discovery on PC1N1 failed due to exception
(01) 2013-09-21 13:41:31 Slp: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: The handle is invalid.

at Microsoft.SqlServer.Configuration.Sco.InternalRegistryKey.OpenSubKey(String subkey, RegistryAccess requestedAccess)
at Microsoft.SqlServer.Configuration.Sco.SqlRegistryKey.OpenSubKey(String subkey, RegistryAccess requestedAccess)
at Microsoft.SqlServer.Discovery.DiscoveryUtils.GetLocalMachineSubKey(ServiceContainer ctx, String machineName, RegistryView regView, String regPath, RegistryAccess registryAccess)
at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetInstanceHiveForSqk2kInstance(String machineName, String instanceName, RegistryView regView)
at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.GetSql2kMsiInstanceListInHive(String machineName, RegistryView regView)
at Microsoft.SqlServer.Discovery.DiscoveryEnumObject.LoadSql2kInstanceList(String machineName)
at Microsoft.SqlServer.Discovery.Product.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.ProcessDTbl(DataTable dt, Int32 level)
at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.CollectSqlDiscoveryData(String machineName)
at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.CollectDiscoveryData(String machineName)
at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
(01) 2013-09-21 13:41:31 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction" threw an exception during execution.
(01) 2013-09-21 13:41:31 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Configuration.Sco.SqlRegistryException: The handle is invalid.
(01) 2013-09-21 13:41:31 Slp: Exception type: Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException
(01) 2013-09-21 13:41:31 Slp: Message:
(01) 2013-09-21 13:41:31 Slp: Failed to retrieve data for this request.
(01) 2013-09-21 13:41:31 Slp: HResult : 0x80131500
(01) 2013-09-21 13:41:31 Slp: Data:
(01) 2013-09-21 13:41:31 Slp: HelpLink.ProdName = Microsoft SQL Server
(01) 2013-09-21 13:41:31 Slp: HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
(01) 2013-09-21 13:41:31 Slp: HelpLink.LinkId = 20476
(01) 2013-09-21 13:41:31 Slp: Stack:
(01) 2013-09-21 13:41:31 Slp: at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
(01) 2013-09-21 13:41:31 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.ProcessDTbl(DataTable dt, Int32 level)
(01) 2013-09-21 13:41:31 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.CollectSqlDiscoveryData(String machineName)
(01) 2013-09-21 13:41:31 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.CollectDiscoveryData(String machineName)
(01) 2013-09-21 13:41:31 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
(01) 2013-09-21 13:41:31 Slp: at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)
(01) 2013-09-21 13:41:31 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
(01) 2013-09-21 13:41:31 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)
(01) 2013-09-21 13:41:31 Slp: Inner exception type: Microsoft.SqlServer.Configuration.Sco.SqlRegistryException
(01) 2013-09-21 13:41:31 Slp: Message:
(01) 2013-09-21 13:41:31 Slp: The handle is invalid.
(01) 2013-09-21 13:41:31 Slp:
(01) 2013-09-21 13:41:31 Slp: HResult : 0x84d10006
(01) 2013-09-21 13:41:31 Slp: FacilityCode : 1233 (4d1)
(01) 2013-09-21 13:41:31 Slp: ErrorCode : 6 (0006)
(01) 2013-09-21 13:41:31 Slp: Data:
(01) 2013-09-21 13:41:31 Slp: WatsonData = Microsoft.SqlServer.Configuration.Sco.SqlRegistryException@Win32Error
One interesting fact is, setups always works without an issue when I run it on an active node.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search