Submit a ticketCall us

AnnouncementsTHWACKcamp 2018 is here

2018 is the seventh year for THWACKcamp™, and once again we’ll be live October 17 – 18 with packed session tracks covering everything from network monitoring and management, to change control, application management, storage, cloud and DevOps, security, automation, virtualization, mapping, logging, and more.

Register for online sessions.

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,438 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