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 > 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 on Aug 31, 2016

Views: 26 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
22:11, 30 Aug 2016

Tags

Classifications

Public