Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

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