Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

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: 38 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