Solarwind NAM upgrade issue 'APM_ApplicationStatus' binding errors.

mnsh_majumder

Has anyone faced issue like this when upgrading to 2023.1 version

Orion Database FAILED

Database configuration failed:
• Error while executing script- Invalid column name 'RecordCount'.
Invalid column name 'Archive'.
Invalid column name 'Archive'.
Invalid column name 'Archive'.
Could not use view or function
Invalid column name 'RecordCount'.
Invalid column name 'Archive'.
Invalid column name 'Archive'.
Invalid column name 'Archive'.
Could not use view or function 'APM_ApplicationStatus' because of binding errors.

High availability pool is disabled.

mnsh_majumder

Vendor resolved it. had to delete some APP tables as we used SAM many years back which left some residue tables. below is the code which vendor used to delete. 

/*
Warning: This script removes ALL APM (SAM) structures and data from the database!

'FN','IF'..scalar valued functions
'TF'..table valued functions
'P'..procedure
'U'..TABLE
'V'..View
*/

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

PS:

• If you face issue while uninstalling any SW app please use this link

Fix problems that block programs from being installed or removed - Microsoft Support

• if you face issue with CLM table please use this code to delete which vendor used to resolve the issue during the same situation:         ALTER TABLE [dbo].[CLM_SelectedCloudRegions] DROP CONSTRAINT [FK_CLM_SelectedCloudRegions_CloudJobSettings]