"Database configuration failed" after NPM 12.2 to 12.4 upgrade

Configuration Wizard fails with the following message after updating NPM 12.2 to 12.4 with an offline installer:

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.
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.
The statement has been terminated.

About to submit a support case, yet wanted to check if there is a known fix. Seeing these two related posts on the forums:

"NPM Upgrade Issue 11.5 to 11.5.3" - same error message but don't see how the issue was resolved.
"SolarWinds Orion Platform 2016.1 Hotfix 3 - Worldwide Map" - same error that 2016.1 HF3 supposedly fixes - yet unclear what to do with my botched install.

Thanks for any hints.

Find more posts tagged with

orion upgrade

solarwind installation

Accepted answers

neomatrix1217

I would look into this in the database and see if there are duplicate view ID's

UPDATE dbo.Resources
SET ResourceTitle = N'Top XX VMs by Underallocated vCPUs'
WHERE ResourceTitle = N'Top XX VMs by Underallocated CPU'
AND (ResourceFile = '~/Orion/VIM/resources/VManSprawl/TopXXVMCpuUnderallocated.ascx' OR ResourceFile = '/Orion/VIM/resources/VManSprawl/TopXXVMCpuUnderallocated.ascx')
END

All comments

neomatrix1217

Have you seen this KB

Error while executing script- Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=…

akhasheni

Have not - will check it out - thank you!

akhasheni

Doesn't look like this KB applies to my case:

See no duplicate "viewkey" entries (out of 122 total) - pasted into a Google Sheet, checked for duplicates.
See no two primary pollers in any of the places the article suggest checking.

neomatrix1217

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

nerengm

Same issue going from 12.3 to 2019.4...any advice on how to move past this error?

dharmbodh

@akhasheni

Hello ,

How you resolved this issue as i am getting same error.please help.

akhasheni

I believe @neomatrix1217's posts about duplicate view IDs and how to find / remove them resolved this for me - but can't remember now, and can't find that KB article he linked to...