none
SQL 2008 R2 upgrade setup does not show the configuration file

    Question

  • Hi,

    I am trying to upgrade my SQL 2008 R2 SP3 SQL server with the hotfix MS15-058 hotfix. The upgrade fails with the below error . This is the passive node of the cluster. When I run the setup and at the Ready to Update screen, I don't see the configuration.ini file being generated either. Can you please assist on this ?

    2017-02-01 00:05:35 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names\OLAP
    2017-02-01 00:05:35 Slp: Sco: Failed to open service handle for service MSOLAP$XXXX
    2017-02-01 00:05:35 Slp: Sco: Failed to open service handle for service ReportServer$XXXX
    2017-02-01 00:05:35 Slp: Attempting to run patch request for instance: XXXX
    2017-02-01 00:06:42 Slp: Error: Failed to run patch request for instance: XXXX (exit code: -568706566)

    Instance XXXXoverall summary:
      Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
      Exit code (Decimal):           -568706566
      Exit facility code:            1562
      Exit error code:               14842
      Exit message:                  Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)
      Start time:                    2017-02-01 12:12:02
      End time:                      2017-02-01 12:13:04
      Requested action:              Patch

    Wednesday, February 1, 2017 7:37 PM

All replies

  • Hi a______RisingStar,

    >> I don't see the configuration.ini file being generated either. 

    From what I can see the patch process doesn’t generate a configuration file, and I wouldn’t consider this as an issue since  /ACTION parameter doesn’t support PATCH as value.

    >>Can you please assist on this?

    Please locate and share the corresponding SQL Server installation log so we can have a better understanding about the issue.

    If you have any other questions, please let me know.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, February 2, 2017 7:48 AM
    Moderator
  • Hi Lin,

    Thanks for checking this. I am unable to attach the log file here, so Im just posting where the error was listed. This is a 2 node cluster and there is no issue with Storage either. I have 4 SQL instances on the cluster which are active on the other node.

    2017-02-01 20:18:50 Slp: Running Action: ValidateFeatureSettings
    2017-02-01 20:18:50 Slp: The configuration object document /Datastore/ProductSettings/Sku/Public was found in the datastore.
    2017-02-01 20:18:50 Slp: The configuration object document /Datastore/InputSettings/FeatureSpecific/SlpInputSettings was found in the datastore.
    2017-02-01 20:18:51 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction" threw an exception during execution.
    2017-02-01 20:18:51 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7) ---> System.Runtime.InteropServices.COMException (0x800700B7): Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Interop.MSClusterLib.ISClusResource.get_Disk()
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Configuration.Cluster.ClusterPhysicalDisk.get_Partitions()
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterDiskPublicConfigObject.IsPathOnSharedDisk(String path)
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings.ValidateNotOnSharedDisk(ValidationState vs, String directoryName, String bindingKey, String errorMessage)
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings.Validate_InstallSharedDir(ValidationState vs)
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings.ValidateSettings()
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
    2017-02-01 20:18:51 Slp:    --- End of inner exception stack trace ---
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2017-02-01 20:18:51 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2017-02-01 20:18:51 Slp: Received request to add the following file to Watson reporting: C:\Users\TEMP\AppData\Local\Temp\2\tmp5DB3.tmp
    2017-02-01 20:18:51 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2017-02-01 20:18:51 Slp: Inner exceptions are being indented
    2017-02-01 20:18:51 Slp:
    2017-02-01 20:18:51 Slp: Exception type: System.Runtime.InteropServices.COMException
    2017-02-01 20:18:51 Slp:     Message:
    2017-02-01 20:18:51 Slp:         Cannot create a file when that file already exists. (Exception from HRESULT: 0x800700B7)
    2017-02-01 20:18:51 Slp:     Stack:
    2017-02-01 20:18:51 Slp:         at Microsoft.SqlServer.Interop.MSClusterLib.ISClusResource.get_Disk()
    2017-02-01 20:18:51 Slp:         at Microsoft.SqlServer.Configuration.Cluster.ClusterPhysicalDisk.get_Partitions()
    2017-02-01 20:18:51 Slp:         at Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterDiskPublicConfigObject.IsPathOnSharedDisk(String path)
    2017-02-01 20:18:51 Slp:         at Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings.ValidateNotOnSharedDisk(ValidationState vs, String directoryName, String bindingKey, String errorMessage)
    2017-02-01 20:18:51 Slp:         at Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings.Validate_InstallSharedDir(ValidationState vs)
    2017-02-01 20:18:51 Slp:         at Microsoft.SqlServer.Configuration.SetupExtension.SlpInputSettings.ValidateSettings()
    2017-02-01 20:18:51 Slp:         at Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction.ExecuteAction(String actionId)
    2017-02-01 20:18:51 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2017-02-01 20:18:51 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun)
    2017-02-01 20:18:51 Slp: Watson Bucket 1
     Original Parameter Values

    Thursday, February 2, 2017 8:01 PM
  • From what I can see the patch process doesn’t generate a configuration file, and I wouldn’t consider this as an issue since  /ACTION parameter doesn’t support PATCH as value.

    Uh, I believe it does.

    Installing Updates from the Command Prompt

    https://technet.microsoft.com/en-us/library/dd638066(v=sql.105).aspx


    Joie Andrew "Since 1982"

    Thursday, February 2, 2017 9:36 PM