Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

NPM Upgrade Issue 11.5 to 11.5.3

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.

Find more posts tagged with

Accepted answers

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.

All comments

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.

rlaplante

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.

rlaplante

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

janene16

That is awesome news! cool