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 Performance Monitor (NPM) > Configuration Wizard Error: Error while executing script- Invalid column name 'PollingSource'

Configuration Wizard Error: Error while executing script- Invalid column name 'PollingSource'

Created by Norsolihati Selamat, last modified by Aileen de Lara_ret on Aug 31, 2016

Views: 977 Votes: 0 Revisions: 5

Overview

The following Configuration Wizard error occurs while executing script:

Invalid column name 'PollingSource'..

Environment

NPM version 11.0.1

 

Cause 

The error occurs when column PollingSource is missing from the table VIM_Hosts

 

Resolution

Create a backup of your database before making direct changes.

 

1. Confirm using the following SQL script if the column exists:
    SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=N'VIM_Hosts' and     COLUMN_NAME=N'PollingSource'

 

2. If it does not exist, (zero returned rows from the above script), add it using the following script:
    ALTER TABLE [VIM_Hosts] ADD [PollingSource] [int] NOT NULL DEFAULT 2

3. Use the script from Step 1 to confirm the column has been added successfully. 

4. Re-run the Configuration Wizard.

 

In case of errors:

a. Collect fresh diagnostics for investigation.
b. Attach the following file from C:\Program Files (x86)\SolarWinds\Orion\VIM\:

VIMDatabaseScheme.dbConfig
 

 

 

Last modified

Tags

Classifications

Public