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 > Enterprise Operations Console (EOC) > EOC - Knowledgebase Articles > Error while executing script- Invalid column name 'C_WInterface'

Error while executing script- Invalid column name 'C_WInterface'

Created by Norsolihati Selamat, last modified by Laura C on Feb 01, 2018

Views: 679 Votes: 0 Revisions: 6

Overview

This article describes the issue in EOC when you receive this Configuration Wizard errors as below:

Error while executing script- Invalid column name 'C_WInterface'

 

The Configuration Wizard log displays the following:

INFO  ConfigurationProgressScene - Configuring core EOC database.
ERROR DBConfigProcessor - Error while executing script - Invalid column name 'C_WInterface'..
ERROR DBConfigProcessor - Failing Sql command: sp_refreshview 'EOC_Interface'
ERROR ConfigurationProgressScene - Error while executing script- Invalid column name 'C_WInterface'.

 

Environment

EOC version 1.6

 

Cause 

The issue may be due to a custom table having been added to the EOC table.

Resolution

Backup your database before making any direct changes.

  1. Log on to the SQL Server Connect and on to the DB using SQL Studio Management Console.
  2. Expand the EOC Database > Views > Select the View dbo.EOC_Interface.
  3. Right-click the file and select Delete.
  4. Re-run the EOC Configuration Wizard.
 

 

Last modified

Tags

Classifications

Public