Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Storage Resource Monitor (SRM) > SRM - Knowledgebase Articles > Database Configuration Failed Error while executing script: Multiple invalid column name errors

Database Configuration Failed Error while executing script: Multiple invalid column name errors

Created by Norsolihati Selamat, last modified by Rodim Suarez_ret on Jul 11, 2016

Views: 967 Votes: 0 Revisions: 6

Overview

Upgrade from SRM 6.1 RC to GA fails with the following error on Cionfiguration Wizard logs:
Database Configuration failed:
Invalid column name 'IOLatencyTotal'
Invalid column name 'IOLatencyRead'
Invalid column name 'IOLatencyWrite'
Invalid column name 'IOLatencyOther'
Invalid column name 'IOLatencyTotal'

Invalid column name 'IOLatencyRead'
Invalid column name 'IOLatencyWrite'
Invalid column name 'IOLatencyOther'

Invalid column name 'IOLatencyTotal'

Invalid column name 'IOLatencyRead'
Invalid column name 'IOLatencyWrite'
Invalid column name 'IOLatencyOther'

Environment

SRM 6.1 RC

Resolution

Note: Make sure to backup your database before doing any changes.

  1. Execute the following SQL script that will enable GA Configuration Wizard to update all DB tables:
    IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[GetSrmDbVersion]') AND xtype in (N'FN', N'IF', N'TF'))
     DROP FUNCTION [dbo].[GetSrmDbVersion]
    GO

    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO

    CREATE FUNCTION [dbo].[GetSrmDbVersion]()
    RETURNS int
    AS
    BEGIN
     RETURN 4 
    END
  2. Rerun the Configuration Wizard.

 

Last modified

Tags

Classifications

Public