Applications Systems

Orion Configuration Wizard Error while executing script- Invalid column name 'WarningPolls', 'WarningPollsInterval', 'CriticalPolls' and 'CriticalPollsInterval'

This article provides resolution when the Configuration Wizard fails after a SAM installation. Error is shown as: Error while executing script- Invalid column name 'WarningPolls', 'WarningPollsInterval', 'CriticalPolls' and 'CriticalPollsInterval'

First published date

11/9/2021 3:29 AM

Last published date

11/20/2021 3:29 AM

Overview

This article describes the issue in Orion when you receive this Configuration Wizard errors as below:

Database configuration - Components FAILED

Services configuration failed:
Error while executing script- Invalid column name 'WarningPolls'.
Invalid column name 'WarningPollsInterval'.
Invalid column name 'CriticalPolls'.
Invalid column name 'CriticalPollsInterval'.

Product section

Server Application Monitor

Cause

This is due to the Orion database containing previous SAM installation where table APM_DynamicEvidenceColumnSchema are missing columns for 'WarningPolls', 'WarningPollsInterval', 'CriticalPolls' or 'CriticalPollsInterval'.

Resolution

NOTE: Create a backup of your database before making direct changes.

Confirm using the following SQL script if the column exists in APM_DynamicEvidenceColumnSchema
If it does not exist, drop the table using SQL script below:

DROP TABLE APM_DynamicEvidenceColumnSchema

3. If script returns an error similar to these:

Cannot DROP TABLE 'dbo.APM_DynamicEvidenceColumnSchema' because it is being referenced by object
'APM_MultiValueAlertsDataInternal'.

Run script below to drop 'APM_MultiValueAlertsDataInternal' view, then proceed to running script in Step 2.

DROP VIEW APM_MultiValueAlertsDataInternal

4. Re-run the Configuration Wizard.

In case of errors:

Collect fresh diagnostics for investigation.

-- 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.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.