Error while executing script message during Configuration Wizard

10/19/2022 4:27 PM

2/8/2025 6:45 AM

This issue typically occurs when running the configuration wizard during Orion 2022.x upgrade. Running the Configuration Wizard shows the error below:


Orion Database FAILED
Database configuration failed:
• Error while executing script- Invalid object name 'dbo.SEUM_WebUserPermissions'.


Sample Image:



Orion Database FAILED
Database configuration failed:
• Error while executing script- Invalid column name "Unmanged".

Sample Image:


 

Orion Platform

Remnants of previously installed products in the database.

The function needs to be recreated. 

1. Please remove all SEUM tables.
2. Execute the script to Drop the function

   • -- 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 FUNCTION [dbo].[GetSEUMDbVersion];

3. Please go ahead and execute the script to Create a new function.

   • -- 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.
     
     CREATE FUNCTION [dbo].[GetSEUMDbVersion]()
     RETURNS int
     AS BEGIN RETURN 5 
     END;

4. Re-run the Configuration Wizard, and it should now be complete.