Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Network Configuration Manager (NCM) > 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

Public