Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Configuration Manager (NCM) > Upgrade issue "An unsupported version of the SAM Database has been detected on the following databases..."

Upgrade issue "An unsupported version of the SAM Database has been detected on the following databases..."

Created by Jeremy Holmes, last modified by Jane Baylon on Jul 10, 2017

Views: 1,337 Votes: 5 Revisions: 9

Overview

When upgrading to the new versions of products using Orion Core 2016 and the user does not have a current (or any) version of SAM installed but did at one point in time, the Pre-Check will show the following message: 

 

Upgrading is not recommended. Correct the following issues, and run the installer again.

An unsupported version of the SAM Database has been detected on the following databases: NetPerfMon. Continuing will result in the Configuration Wizard failing.

> Click for more details

 

 

The details will state the below. 

 

Database version check (SAM)

________________________________
RESULT: 

The diagnostic test failed or encountered unexpected behavior or configuration.
DISCOVERED: Date/Timestamp
SEVERITY: Blocker
DESCRIPTION:
An unsupported version of the SAM Database has been detected on the following databases: DatabaseName. Continuing will result in the Configuration Wizard failing
RESOLUTION:
Please contact SolarWinds Support who will provide you with the necessary tool to correct this.

Environment

Orion 2015.1 and UP

Cause 

At one point, SAM was installed either as a full version or as an evaluation and the tables are still in the database. 

Resolution

Warning: SolarWinds strongly recommends that you backup your database before doing any work as this will make a permanent change to your database.

  1. Stop all Orion services on all Solarwinds servers.
  2. Log in to SQL Server Management Studio and open the SolarWinds database.
  3. Execute the following script:
    DECLARE @table_object_id int
    DECLARE @table_name varchar(max)
    DECLARE @table_type varchar(max)
    DECLARE @stmt nvarchar(max)
    
    DECLARE table_cursor CURSOR FAST_FORWARD FOR
    SELECT o.object_id, o.name, o.[type]
    FROM sys.objects o
    WHERE o.[type] IN ('FN','TF','V','P','U') AND o.name LIKE 'APM_%' AND o.name NOT LIKE '%APM_Hardware%'
    ORDER BY CASE o.[type] WHEN 'U' THEN 'z' ELSE o.[type] END
    
    OPEN table_cursor
    
    FETCH NEXT FROM table_cursor INTO @table_object_id, @table_name, @table_type
    WHILE @@FETCH_STATUS=0
    
    BEGIN
    SET @stmt = CASE @table_type
    WHEN 'V' THEN 'VIEW'
    WHEN 'P' THEN 'PROCEDURE'
    WHEN 'FN' THEN 'FUNCTION'
    WHEN 'TF' THEN 'FUNCTION'
    ELSE 'TABLE'
    END
    
    SET @stmt = 'DROP '+@stmt+' ['+@table_name+']'
    PRINT @stmt
    EXEC [dbo].sp_executesql @statement = @stmt
    FETCH NEXT FROM table_cursor INTO @table_object_id, @table_name, @table_type
    END
    
    CLOSE table_cursor
    
    DEALLOCATE table_cursor
    
    IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[GetApmDbVersion]') AND xtype in (N'FN', N'IF', N'TF'))
    BEGIN
    DROP FUNCTION GetApmDbVersion
    END
    Note: To copy content without line numbers, hover over the text and click the view source button (View Source). This opens a new window where you can select and copy text without any formatting or line numbering.
  4. Re-run the installer.

 

 

Last modified

Tags

Classifications

Public