Submit a ticketCall us
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,077 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