Exception while configuring plugin Orion Core Services component Orion Database. One or more errors occurred.

While running the configuration wizard, the finishing page is showing the following error:

Database configuration failed:

• Exception while configuring plugin Orion Core Services component Orion Database. One or more errors occurred.

And it can be found in “C:\ProgramData\SolarWinds\Logs\Orion\ConfigurationWizard.log” :

2020-05-14 08:35:35,217 [5] ERROR ConfigurationProgressScene - Exception while configuring plugin Orion Core Services component Orion Database. System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: dbm_UpgradeAllCurTables: dbm_UpgradeCurTable: Error: The new name '***NEW_TABLE_NAME***' is already in use as a object name and would cause a duplicate that is not permitted.  dbm_UpgradeCurTable '***OLD_TABLE_NAME***'

The new table that configuration wizard is attempting to create already exists in the database, and configuration of the table is such that it does not permit duplicates.

***IMPORTANT***
PLEASE MAKE SURE YOU HAVE CREATED A DATABASE BACKUP BEFORE PERFORMING ANY OF THE STEPS FROM THIS ARTICLE.

Please follow these steps:

1. Stop all services using the Orion Service Manager

2. Open Database Manager (Default location: C:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe)

3. Right-click the Orion Database and select “New Query…”

4. Create a duplicate ***NEW_TABLE_NAME*** table by executing the following query:

   1. -- Scripts are not supported under any SolarWinds support program or service.
      -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
      -- disclaims all warranties including, without limitation, any implied warranties
      -- of merchantability or of fitness for a particular purpose. The risk arising
      -- out of the use or performance of the scripts and documentation stays with you.
      -- In no event shall SolarWinds or anyone else involved in the creation,
      -- production, or delivery of the scripts be liable for any damages whatsoever
      -- (including, without limitation, damages for loss of business profits, business
      -- interruption, loss of business information, or other pecuniary loss) arising
      -- out of the use of or inability to use the scripts or documentation.

      SELECT * INTO ***NEW_TABLE_NAME_BACKUP_NAME*** FROM ***NEW_TABLE_NAME***

5. Delete the ***NEW_TABLE_NAME*** table by executing the following query in Database Manager:

   1. -- Scripts are not supported under any SolarWinds support program or service.
      -- Scripts are provided AS IS without warranty of any kind. SolarWinds further
      -- disclaims all warranties including, without limitation, any implied warranties
      -- of merchantability or of fitness for a particular purpose. The risk arising
      -- out of the use or performance of the scripts and documentation stays with you.
      -- In no event shall SolarWinds or anyone else involved in the creation,
      -- production, or delivery of the scripts be liable for any damages whatsoever
      -- (including, without limitation, damages for loss of business profits, business
      -- interruption, loss of business information, or other pecuniary loss) arising
      -- out of the use of or inability to use the scripts or documentation.

      DROP TABLE ***NEW_TABLE_NAME***

6. Start all services using the Orion Service Manager

7. Run the configuration wizard

This article relates to the following article:

• Error while executing script- Error: The new name 'ObsoleteTopologyData' is already in use as a object name would case a duplicate that is not permitted