Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

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: 1,740 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