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 > Enterprise Operations Console (EOC) > 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 Steven Bansil_ret on Jul 11, 2016

Views: 47 Votes: 0 Revisions: 5

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'

 

Configuration Wizard log shows:

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 custom table been added to the EOC table.

Resolution

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

Note: Make sure a good database backup has already been done before making direct changes to the database.

 

 

Last modified

Tags

Classifications

Public