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) > Invalid column name DeletedOn

Invalid column name DeletedOn

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

Views: 977 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