Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > Orion Platform 2015.1.2 Configuration Wizard error

Orion Platform 2015.1.2 Configuration Wizard error

Table of contents
Created by Daniel Phillipps, last modified by Jie Y Lee on Dec 13, 2016

Views: 1,286 Votes: 1 Revisions: 6

Overview

This article describes error after installing Orion Core Platform 11.5.2 Hotfix 6. The following error appears: 

Database configuration failed:
 Error while executing script- Cannot create more than one clustered index on table 'dbo.ContainerMemberSnapshots'. Drop the existing clustered index 'IX_ContainerMemberSnapshots_Clustered' before creating another.
Could not create constraint.

Environment

Orion Core Platform version 11.5.2 Hotfix 6

Steps

  1. Install Orion Core Hotfix 6 and run the Configuration Wizard.
  2. Connect to the SQL server with SQL Management Studio.
  3. Browse to the Solarwinds Database, and go to Containermembersnapshots table.
  4. Click the plus sign next to the table.
  5. Click the plus  sign next to Indexes.
  6. Delete the Index you are having a problem with:

 

IX_ContainerMemberSnapshots_Clustered

  7.  Run the Configuration Wizard and reinstall Orion Core 2015.1.2 Hotfix 6.

 

Last modified

Tags

Classifications

Public