Configuration Wizard fails with an error "Column name 'ProviderGroupID' in table 'dbo.SRM_Providers' is specified more than once"

11/6/2023 8:08 AM

11/7/2025 4:45 PM

This occurs when following error occurs after running Configuration Wizard during upgrade:

Error while executing script - Column names in each table must be unique. Column name 'ProviderGroupID' in table 'dbo.SRM_Providers' is specified more than once.

Network Performance Monitor

This is caused when there are no SRM modules previously installed in the environment

• Remote to the Main SolarWinds Platform server
• Open Database Manager
• Proceeded to delete SRM tables using below query:

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

declare @cmd varchar(4000)
declare cmds cursor for 
select 'drop table [' + Table_Name + ']'
from INFORMATION_SCHEMA.TABLES
where Table_Name like 'SRM_%' and TABLE_TYPE like '%TABLE%'


open cmds
while 1=1
begin
    fetch cmds into @cmd
    if @@fetch_status != 0 break
    exec(@cmd)
end
close cmds;
deallocate cmds


declare cmds cursor for 
select 'drop view [' + Table_Name + ']'
from INFORMATION_SCHEMA.TABLES
where Table_Name like 'SRM_%' and TABLE_TYPE like '%VIEW%'


open cmds
while 1=1
begin
    fetch cmds into @cmd
    if @@fetch_status != 0 break
    exec(@cmd)
end
close cmds;
deallocate cmds


DROP FUNCTION dbo.GetSrmDbVersion



DECLARE @menuItemId int

IF EXISTS(SELECT 1 FROM dbo.MenuItems WHERE Link LIKE '/Orion/SRM/ProfilerIframe.aspx%')
BEGIN
    SET @menuItemId = (SELECT MenuItemID FROM dbo.MenuItems WHERE Title = 'Storage Main Console')
    DELETE FROM dbo.MenuItems WHERE MenuItemID = @menuItemId
    DELETE FROM dbo.MenuBars WHERE MenuItemID = @menuItemId

   SET @menuItemId = (SELECT MenuItemID FROM dbo.MenuItems WHERE Title = 'Storage Events')
    DELETE FROM dbo.MenuItems WHERE MenuItemID = @menuItemId
    DELETE FROM dbo.MenuBars WHERE MenuItemID = @menuItemId
END

• Rerun the Configuration Wizard