Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Enterprise Operations Console (EOC) > Error while executing script - Invalid column name 'CRCAlignErrorsThisHour'

Error while executing script - Invalid column name 'CRCAlignErrorsThisHour'

Created by Malik Haider, last modified by MindTouch on Jun 23, 2016

Views: 34 Votes: 1 Revisions: 5

Overview

This article describes the issue when you receive the following error when running the Configuration Wizard for EOC:
 

Error while executing script- Invalid column name CRCAlignErrorsThisHour

 

 

 

The configuration error shows the log error below:

 

2016-04-11 12:24:43,630 [5] DEBUG DBStructureProcessor - } ConfigurateDatabase exited
2016-04-11 12:24:43,630 [1] INFO  ConfigurationProgressScene - Configuring core EOC database.
2016-04-11 12:24:44,772 [5] ERROR DBConfigProcessor - Error while executing script - Invalid column name 'CRCAlignErrorsThisHour'.
Invalid column name 'CRCAlignErrorsToday'.
Invalid column name 'DuplexMode'.
Invalid column name 'LateCollisionsThisHour'.
Invalid column name 'LateCollisionsToday'..
2016-04-11 12:24:44,772 [5] ERROR DBConfigProcessor - Failing Sql command:

-- 
-- C:\Projects\EOC\Current_19012015\Dev\Main\EOC\Src\Config\SqlScripts\Post\RefreshViews.sql
-- 

sp_refreshview 'EOC_Interface'
2016-04-11 12:24:44,772 [1] ERROR ConfigurationProgressScene - Error while executing script- Invalid column name 'CRCAlignErrorsThisHour'.
Invalid column name 'CRCAlignErrorsToday'.
Invalid column name 'DuplexMode'.
Invalid column name 'LateCollisionsThisHour'.
Invalid column name 'LateCollisionsToday'.
2016-04-11 12:25:03,533 [1] DEBUG EOCWorkflowController - Database component EOC Database needs reconfiguring: 
2016-04-11 12:25:03,533 [1] DEBUG EOCWorkflowController - Website component EOC Website needs reconfiguring: 
2016-04-11 12:25:03,533 [1] DEBUG EOCWorkflowController - Service component SolarWinds EOC Information Service needs reconfiguring: 
2016-04-11 12:25:03,533 [1] DEBUG EOCWorkflowController - Service component SolarWinds EOC Services Host needs reconfiguring: 

Environment

EOC version 1.6

Cause 

This issue is caused by an old database that was restored.

Resolution

  1. Open EOC Database with SQL Studio.
  2. Expand Views > Select dbo.EOC_Interface. 
  3. Click Delete.

 

  4. Re-run the Configuration Wizard.

Last modified
19:25, 22 Jun 2016

Tags

Classifications

Public