Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 23 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
00:26, 11 Jul 2016

Tags

Classifications

Public