Submit a ticketCall us

AnnouncementsSystem Monitoring for Dummies

Tired of monitoring failures disrupting the system, application, and service? Learn the key monitoring concepts needed to help you create sophisticated monitoring and alerting strategies that can help you save time and money. Read the eBook.

Get your free eBook.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Database configuration failed : Error while executing script - The index 'Missing_Entity Type' is dependent on Column 'Entity Type'

Database configuration failed : Error while executing script - The index 'Missing_Entity Type' is dependent on Column 'Entity Type'

Created by Juan Carlo del Rosario, last modified by Kevin.Swinson on Nov 09, 2017

Views: 1,514 Votes: 0 Revisions: 9

Updated November 16th, 2015

Overview

The Configuration Wizard fails with the following error after upgrading from NPM v11.0.1 to v11.5.2.

altertable_01.png

Environment

NPM v11.5.2 

Cause 

The Configuration Wizard was not able to successfully run the following query:

cwQUERYmindtouch.png

 

The following error also exists in the ConfigurationWizard.log file.

CWLOGmindtouch.png

Resolution

  1. Go to Database Manager.

  2. Run the following query to drop the dbo.ContainerMemberSnapshots table:

    DROP TABLE dbo.ContainerMemberSnapshots

  3. Re run the Configuration Wizard.

  4. This will recreate the dbo.ContainerMemberSnapshots.

 

 

Last modified

Tags

Classifications

Public