Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > Invalid column name DeletedOn

Invalid column name DeletedOn

Created by Jane Baylon, last modified by Alexander Aguilar on Dec 15, 2016

Views: 1,197 Votes: 0 Revisions: 4

Updated: July 18, 2016

Overview

This article describes the issue when you receive this error message in the Configuration Wizard which fails due to invalid columns in IPAM table. Sample error in Configuration Wizard log shown below:

2016-07-14 13:33:02,396 [10] ERROR ConfigurationProgressScene - Error while executing script- Invalid column name 'DeletedOn'.
SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- Invalid column name 'DeletedOn'.
   at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.ExecuteSqlBatch(IDbConnection connection, String sqlQuery, ConfigurationLogDelegate configLog)
   at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.Process(IDbConnection connection, ConfigurationProgressDelegate progress, String scriptFile, ConfigurationLogDelegate logger)
   at SolarWinds.ConfigurationWizard.Plugin.Common.ModuleHelper.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate logger, String dbStructureFile, String dbConfigFile, String initialWebConfigFile)
   at SolarWinds.ConfigurationWizard.Plugin.IPAM.IPAMMainPlugin.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLog

Environment

  • NPM 11.5.x
  • IPAM 4.x

 

Cause 

This is due to invalid columns in the IPAM tables.

 

Resolution

Note: Before doing any work on your database please make sure that you have a current backup as this will make a permanent change to your database. 

  1. Open SQL Management Studio and connect to your Orion database.
  2. Run the query simultaneously:

DROP TABLE IPAM_CONFLICT

DROP TABLE IPAM_CONFLICTDATA

  1. Click Execute Query.

 

 

Last modified

Tags

Classifications

Public