Submit a ticketCall us
Home > Success Center > Network Performance Monitor (NPM) > 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,355 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