Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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 MindTouch on Jun 23, 2016

Views: 158 Votes: 0 Revisions: 10

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
21:55, 22 Jun 2016

Tags

Classifications

Public