Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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 MindTouch on Jun 23, 2016

Views: 35 Votes: 5 Revisions: 8

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

Upgrading to NCM 7.5, UDT 3.2.4, and VNQM 4.2.4

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
21:33, 22 Jun 2016

Tags

Classifications

Public