Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Configuration Manager (NCM) > NCM - Knowledgebase Articles > Configuration Wizard ERROR - Error while executing script- Invalid column name 'UserName'

Configuration Wizard ERROR - Error while executing script- Invalid column name 'UserName'

Updated: October 5, 2017

Overview

This article provides a fix for an error that occurs after upgrading to NCM 7.6 from a previous version.

Environment

  • Upgrade to NCM 7.6 from previous versions of NCM

Cause 

There is a bug while creating the following new NCM_Firmware tables and view:

NCM_FirmwareOperationsView (view)

NCM_FirmwareDefinitions

NCM_FirmwareOperationNodes

NCM_FirmwareOperations

NCM_FirmwareUpgradeImages

NCM_FirmwareUpgradeMachineTypes

 

The view and tables should be empty. Do not use the following resolution if tables above are not blank and open up a support ticket.

Resolution

1. Navigate to SQL server and open SQL management studio. 

2. Select the Orion database.

3 Drop/Delete the following tables and view from the Orion database:
NCM_FirmwareOperationsView (view)

NCM_FirmwareDefinitions

NCM_FirmwareOperationNodes

NCM_FirmwareOperations

NCM_FirmwareUpgradeImages

NCM_FirmwareUpgradeMachineTypes

 

Example drop view script procedure:

a. Right-click database --> Select 'New Query'

b. Enter the following query :

DROP VIEW [dbo].[NCM_FirmwareOperationsView]
GO

c. Execute Query


Example drop table script procedure:

a. Right-click database --> Select 'New Query'

b. Enter the following query:

DROP TABLE [dbo].[NCM_FirmwareOperationNodes]
GO

c. Execute Query

 

4. Reinstall NCM 7.6. The error should not occur.

 

 

Last modified

Tags

Classifications

Internal Use Only