Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > IP Address Manager (IPAM) > IPAM - Knowledgebase Articles > Error when running Configuration wizard. Error Subquery returned more than 1 value

Error when running Configuration wizard. Error Subquery returned more than 1 value

Table of contents

Updated January 11, 2017

Overview

Configuration wizard displays the following error when you run the IPAM 4.6 upgrade:

2017-12-28 14:01:35,584 [11] DEBUG DBConfigProcessor - Processing C:\Program Files (x86)\SolarWinds\Orion\IPAM\IPAMTables.dbConfig DB config file...
2017-12-28 14:01:37,850 [11] ERROR DBConfigProcessor - 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..
 Error details: System.Data.SqlClient.SqlException (0x80131904): 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 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehav
Failing Sql command:

-- 
-- C:\Projects\IPAM\Current\Sources\Src\Config\SQL Scripts\Migrate\EngineIdMigration.sql
-- 
IF (  dbo.IPAM_GetDbVersion() < 22 )
BEGIN
-- DHCP migrating
 WITH DhcpGroupEngine AS(
SELECT IG.GroupId ,COALESCE(N.EngineID, (SELECT EngineId FROM Engines E WHERE ServerType='Primary')) as EngineId
FROM dbo.IPAM_Group IG LEFT JOIN dbo.IPAM_DhcpScopeDetails DSD ON IG.GroupId=DSD.GroupId LEFT JOIN dbo.Nodes N ON DSD.NodeId=N.NodeID 
WHERE GroupType = 0x200 OR GroupType=0x40 OR GroupType=0x8
)
UPDATE dbo.IPAM_Group SET EngineId = DhcpGroupEngine.EngineId FROM DhcpGroupEngine WHERE dbo.IPAM_Group.GroupId=DhcpGroupEngine.GroupId AND IPAM_Group.EngineId IS NULL;

-- DNS zone migrating 
WITH DnsGroupEngine AS(
SELECT IG.GroupId, N.EngineID FROM IPAM_DnsZoneDetails ID JOIN dbo.IPAM_Group IG ON ID.GroupId = IG.GroupId 
JOIN dbo.Nodes N ON ID.NodeId=N.NodeID)
UPDATE dbo.IPAM_Group SET EngineId=DGE.EngineId FROM DnsGroupEngine DGE WHERE IPAM_Group.GroupId=DGE.GroupId AND IPAM_Group.EngineId IS NULL;
END

Environment

  • IPAM 4.6

Detail

The error may be caused by invalid entries in the Engines table. Check the Engines table and verify if all the entries are valid. Delete unwanted ones and re-run the Configuration wizard.
Make sure you create a backup of the database.

 

 

 

Last modified

Tags

Classifications

Public