4 Replies Latest reply on Jun 22, 2016 4:05 PM by janene16

    NPM Upgrade Issue 11.5 to 11.5.3

    rlaplante@bhfs.com

      When running the configuration wizard after upgrading to 11.5.3.62 full

      Database configuration failed:

      • Error while executing script- Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression.

      The statement has been terminated.

       

      SolarWinds TAC Case # 1005463 is open but I am wondering if this has been seen else were by anyone with a fix.  The first SW TAC reply did not resolve the issue, though I think they headed off an issue with the SAM update step soon after this case is resolved.

        • Re: NPM Upgrade Issue 11.5 to 11.5.3
          janene16

          Can you go to path: C:\ProgramData\Solarwinds\Logs\Orion\ConfigurationWizard.log and paste here what the most recent log says?

           

          It may have been due to duplicate views, and not the APM templates so we'll need to confirm.

            • Re: NPM Upgrade Issue 11.5 to 11.5.3
              rlaplante@bhfs.com

              I ran CW to update the logs and grabbed the entries from the end of that so the data should be current.

               

               

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

              -- Deleting Virtualization Manager Alerts resource (moved from Storage to Virtualization Summary subview in)

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

              DECLARE @websiteVersion int

              SELECT @websiteVersion = CAST((SELECT [SettingValue] FROM [dbo].[WebSettings] WHERE [SettingName] = 'Virtualization.Website.Version') AS int)

               

               

              IF (@websiteVersion < 11)

              BEGIN

                SET @resourceFile = '/Orion/VIM/Resources/VManStorage/VManAlerts.ascx'

               

               

                DELETE FROM dbo.Resources

                WHERE ViewID = (SELECT ViewID FROM [dbo].[Views] WHERE ViewKey = 'ESX Host Storage Details')

                AND ResourceFile = @resourceFile

               

               

                DELETE FROM dbo.Resources

                WHERE ViewID = (SELECT ViewID FROM [dbo].[Views] WHERE ViewKey = 'Hyper-V Host Storage Details')

                AND ResourceFile = @resourceFile

               

               

                DELETE FROM dbo.Resources

                WHERE ViewID = (SELECT ViewID FROM [dbo].[Views] WHERE ViewKey = 'Virtual Machine Storage Details')

                AND ResourceFile = @resourceFile

               

               

                DELETE FROM dbo.Resources

                WHERE ViewID = (SELECT ViewID FROM [dbo].[Views] WHERE ViewKey = 'Host Storage Details')

                AND ResourceFile = @resourceFile

               

               

                DELETE FROM dbo.Resources

                WHERE ViewID = (SELECT ViewID FROM [dbo].[Views] WHERE ViewKey = 'VIM Virtual Machine Storage Details')

                AND ResourceFile = @resourceFile

              END

              2016-06-22 13:24:07,421 [15] ERROR ConfigurationProgressScene - Error while executing script- Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

              The statement has been terminated.

              SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

              The statement has been terminated.

                 at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.ExecuteSqlBatch(IDbConnection connection, String sqlQuery, ConfigurationLogDelegate configLog)

                 at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.Process(IDbConnection connection, ConfigurationProgressDelegate progress, String scriptFile, ConfigurationLogDelegate logger)

                 at SolarWinds.ConfigurationWizard.Plugin.Common.ModuleHelper.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate logger, String dbStructureFile, String dbConfigFile, String initialWebConfigFile)

                 at SolarWinds.ConfigurationWizard.Plugin.VIM.VIMPlugin.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)

                 at SolarWinds.ConfigurationWizard.Plugin.VIM.VIMPlugin.DoConfigure(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)

                 at SolarWinds.ConfigurationWizard.Plugin.Common.OrionConfigPlugin.SolarWinds.ConfigurationWizard.Common.IOrionConfigPlugin.DoConfig(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)

                 at SolarWinds.ConfigurationWizard.Host.Presentation.CommonConfiguration.ConfigurationProgressScene.DoConfigForComponent(IOrionConfigHost host, Int32 componentId)

              2016-06-22 13:24:07,421 [15] INFO  OipClient - Tracking event: ConfigurationWizard - ConfigurationProgressScene - UpdateFailureText: •  Error while executing script- Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

              The statement has been terminated.

              - False - 0

               

              Found this further up before a huge section of licensing msgs that were not telling me much.

              • Re: NPM Upgrade Issue 11.5 to 11.5.3
                rlaplante@bhfs.com

                Thank you very much!  Led me right to the issue.

                 

                DELETE FROM dbo.Resources
                WHERE ViewID = (SELECT ViewID FROM [dbo].[Views] WHERE ViewKey = 'Virtual Machine Storage Details')
                AND ResourceFile = @resourceFile

                ###### results fine ViewID  160 and 214 but ResourceFile does not match