Submit a ticketCall us
Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > 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

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

Updated September 11 2018

Overview

While doing an NPM upgrade, you may see below error message:

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.

 

Environment

Orion Core related 

Cause 

* There are duplicate entries in the views table.

(Specifically ViewKey field in Views Table)

 

* There may be two primary pollers in the database left from an incomplete / failed migration.

Resolution

1, DELETE FROM Views WHERE ViewID = "of duplicate view"

(If delete is not possible, you can update or rename the Duplicate ViewKey)

 

2, To determine the duplicate ViewKey:

Run below query

SELECT viewkey, COUNT(ViewKey) from Views where ViewKey is not null group by ViewKey

Column1 should only have 1

 

3, You will need to update the duplicate ViewKey:

Click Enable table editing

Rename the ViewKey that has duplicate

(E.G Virtualization Summary > Backup Virtualization Summary)

 

4, Re-run the Configuration Wizard

 

For two primary pollers:

1, Open the Database Manager as an administrator.

2, Open the Engines, OrionServers, Websites, and NodesData Tables.

(Enable table editing and delete the row containing the older duplicate primary poller in the Engines, OrionServers, Websites tables).

 

3, Verify that the Nodes in the NodesData have the same EngineID as the remaining primary poller.

 

4, Re-run the Configuration Wizard.

 

 

 

Last modified

Tags

Classifications

Public