Network Management

Configuration Wizard Error while executing script- Invalid object name 'dbo.Cortex_Documents'

ERROR TaskAdapter - Error running task Orion.ConfigureDatabase Orion Database SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- Invalid object name 'dbo.Cortex_Documents'.

First published date

10/25/2022 3:41 PM

Last published date

10/25/2022 3:41 PM

Overview

While upgrading from 2020.2.5 to 2022.3 (HCO), you me see following error during Configuration Wizard run when it reaches 21.1% (DB config stage).
image.png
Following error is noted in CW log. 
2022-10-25 12:19:49,957 [17] ERROR TaskAdapter - Error running task Orion.ConfigureDatabase Orion Database
SolarWinds.ConfigurationWizard.Common.ConfigurationException: Error while executing script- Invalid object name 'dbo.Cortex_Documents'.
   at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.ExecuteSqlBatch(IDbConnection connection, String sqlQuery, ConfigurationLogDelegate configLog)
   at SolarWinds.ConfigurationWizard.Plugin.Common.DBConfigProcessor.Process(IDbConnection connection, ConfigurationProgressDelegate progress, String scriptFile, ConfigurationLogDelegate logger)

 

Product section

Orion Platform

Cause

Solarwinds Application is pointed to wrong/broken DB

Resolution

Please verify that Solarwinds is pointing to the correct DB by checking dbo.Cortex_Versions & dbo.Cortex_Documents tables exists or not.
Re-run the Configuration wizard and choose the right DB
If the DB is corrupted/Broken, then you may need to create a new DB and use that instead during Config Wizard.