Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > Configuration Wizard Error : Error while executing script- Column name or number of supplied values does not match table definition

Configuration Wizard Error : Error while executing script- Column name or number of supplied values does not match table definition

Created by Malik Haider, last modified by Kevin.Swinson on Nov 09, 2017

Views: 182 Votes: 0 Revisions: 11

Updated April 7th, 2016

 

Overview

 

 

You have received the Error while running the Configuration Wizard. 

 

2015-10-26 12:06:31,540 [7] ERROR DBConfigProcessor - Error while executing script - 
Column name or number of supplied values does not match table definition..
 Error details: System.Data.SqlClient.SqlException (0x80131904): 
 Column name or number of supplied values does not match table definition.
   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()
-- related to NodeSplit, we need to redirect limitation relation to NodesData table from table Node (which is now DB view)
UPDATE [dbo].[LimitationTableRelation] SET [ParentTable] = N'dbo.NodesData' 
WHERE [ParentTable] = N'dbo.Nodes' AND [ParentTableColumn] = N'NodeID'

-- new relations - merged-in separately as they are post-20140101 and the table already exists
MERGE INTO 
	[dbo].[LimitationTableRelation] AS target
USING 
(	
	VALUES 
	-- Additional changes were not handled correctly in some update paths -- FB400824
	(N'Core', N'dbo.Nodes', N'NodeID', N'dbo.NodesCustomProperties', N'NodeID', 1, 0), 
	(N'Core', N'dbo.NodesData', N'NodeID', N'dbo.NodesCustomProperties', N'NodeID', 1, 0),

 

Environment

All NPM versions

Resolution

 

Make sure your  DBA have restored the correct  version of DB backup which  have currently installed and running configuration wizard .  Configuration Wizard failing when the re stored DB is higher level of currently installed Orion version .  

Restored the correct version DB and re ran the Configuration Wizard . 

 

Alternatively 

 

Drop  the  table called 

[dbo].[LimitationTableRelation] 

 

through SQL Studio and re ran the Configuration Wizard 

 

 

 

 

Last modified

Tags

Classifications

Public