Submit a ticketCall us

ebook60.pngHow to be a Cisco® ASA ace

Our eBook, Thou Shalt Not Pass…I Think?! can help you overcome the challenges of monitoring and managing Cisco ASA firewalls. This eBook is a great read if you’ve been frustrated with monitoring firewalls, managing ACL configs, and troubleshooting VPN connections.

Get your free eBook.

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: 635 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