Network Management

Windows Group Accounts set as Approvers are no longer able to see Pending Requests with the NCM Approval System

Windows Group Accounts can no longer see requests in the Pending Approval List widget on the NCM Config Summary or Manage Requests pages. The NCM Approval System Setup Wizard shows no accounts for the User Roles for Approvers Levels 1 and 2.

First published date

12/11/2024 4:13 PM

Last published date

6/10/2025 11:12 PM

Overview

Windows Group accounts with NCM roles of Administrator or Engineer set as Approvers in the feature Approval System can no longer view requests in the Pending Approval List Widget on the Config Summary or the Manage Requests pages.

The Approver Lists are empty when going through the Approval System Setup Wizard. This is reflected in the NCM table, "NCM_ApprovalUsers."

It requires at least one account per Approver List Levels (1 and 2).

There are no error messages.

Product section

Network Configuration Manager

Cause

This is a known issue.

When a user from the Windows group re-logs into the SolarWinds Platform, the SolarWinds Platform deletes the user from the accounts table and adds it. All this happens during the login process. That is why a foreign key constraint triggers the deletion of the account from the [NCM_ApprovalUsers] table on each user's re-login.

In the Message Center, you'll see audit events such as:

User _071c72fac4114c36b5b7e1fe74caff17 changed account NASUP\james.fahey (PreviousProperties: AccountID: NASUP\james.fahey GroupInfo: NASUP\nasupport

Resolution

This issue has been addressed in NCM 2025.2. Consider upgrading your environment. If you can't upgrade, please use the workaround below.

 

  1. Log in to the Solar Winds Platform Web Console.
  2. Go to Settings > All Settings > NCM Settings > Setup Wizard.
  3. Navigator to the User Roles and add the domain accounts for Approvers Level 1 and Level 2.
  4. Connect to the SolarWinds Platform server and open Database Manager from the SolarWinds Platform folder of the start menu.
  5. Select Add Orion Server, then expand the SQL server and SolarWindsOrion database in bold.
  6. Right-click the database and select New Query.
  7. Paste the query below to the window on the right and click Execute 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.

ALTER TABLE [dbo].[NCM_ApprovalUsers] DROP CONSTRAINT [FK_NCM_ApprovalUsers_Accounts]

Note: Any time the Configuration Wizard runs, the key constraint will be applied, and the workaround must be conducted again.