Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Archive > 2018Jan03 - Deletes > Error executing script: Invalid column FreeSpace

Error executing script: Invalid column FreeSpace

Created by Norsolihati Selamat, last modified by Gerald.Prado on Jan 03, 2018

Views: 982 Votes: 0 Revisions: 6

Overview

This article describes the issue when upgrading to NPM version 11.0, the Configuration Wizard displays the following error:

Error executing script: Invalid column FreeSpace

Environment

NPM version 11.0

Cause 

This maybe due to some reason historical tables for datastores that were not created properly. The best course of action would be to drop those and let the Configuration Wizard recreate them.

 

Resolution

  1. Run the following SQL query:
    DROP TABLE VIM_DatastoreStatistics_Detail
    DROP TABLE VIM_DatastoreStatistics_Hourly
    DROP TABLE VIM_DatastoreStatistics_Daily

     
  2. Run the Configuration wizard.

 

Note: Make sure a good database backup has already been done before making direct changes to the database.

 

Last modified

Tags

Classifications

Public