Submit a ticketCall us

WebinarVisual Monitoring Tactics: Getting More Log Search Value from SolarWinds Log & Event Manager with nDepth Webcast

Do things seem to make more sense when they are visualized? Are you an IT professional or security expert with a wish for more cybersecurity tools that provide an intuitive visual experience? Join Alexis Horn and Jamie Hynds from SolarWinds as they demonstrate how the nDepth feature in LEM can help make visualizing log search results a reality.

Register now.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Error displays when upgrading the Orion Platform server

Error displays when upgrading the Orion Platform server

Updated October 4, 2018

Overview

When you upgrade your Orion Platform server, the following error displays: 

2018-09-25 16:54:13,718 [11] ERROR DBConfigProcessor - Error while executing script - 
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for 
the object name 'dbo.EngineProperties' and the index name 'PK_EngineProperties'. 
The duplicate key value is (2, Basic Alert - Actions Enabled).
Could not create constraint or index. See previous errors. The statement has been 
terminated.

Environment

  • NPM 12.x and higher
  • SAM 6.x and higher
  • Orion Platform 2016.x and higher

Cause 

  • Duplicate values in the dbo.EngineProperties table. The wizard is unable to create a UniqueID to insert the records into this table.

Resolution

  1. Backup your Orion Database.
  2. Open Database Manager or another database management tool.
  3. Navigate to:
    dbo.EngineProperties
  4. Sort the table by the PropertryName column.
  5. Remove any duplicate entries where PropertyName is repeated.
  6. Run the configuration wizard again and allow it to complete.
 

 

Last modified

Tags

Classifications

Public