Network Management

Configuration Wizard error: Error while executing script-Invalid column name 'AdminEmailVolumes'

This article provides brief information and steps to resolve the following error after migrating your database from the SQL Server 2005 to SQL Server 2008: ERROR ConfigurationProgressScene - Error while executing script-Invalid column name 'AdminEmailVolumes'. Invalid column name 'Service'. Could not use view or function 'EOC_Volume' because of binding errors.

First published date

10/25/2018 6:29 PM

Last published date

12/19/2019 5:34 PM

Overview

This article provides brief information and steps to resolve the following error after migrating your database from Microsoft SQL Server 2005 to SQL Server 2008:

ERROR ConfigurationProgressScene - Error while executing script-Invalid column name 'AdminEmailVolumes'. 
Invalid column name 'Service'. 
Could not use view or function 'EOC_Volume' because of binding errors.

Product section

Enterprise Operations Console

Cause

Error is thrown due to the EOC_Volume view definition having reference to non-existing column (AdminEmailVolumes) which has been dropped in previous versions of EOC.

Resolution

To solve the issue follow steps below:

Open SQL Management Studio.
Expand the Orion EOC database > Views.
Delete the EOC_Volume view.
Re-run the EOC Configuration Wizard.

Disclaimer: Please note, any content posted here 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.

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.