Configuration Wizard stuck at Overall 4.9% Database at 20% due to large NCM_ShadowRuleDetectionAclStatistics table

The Configuration Wizard is stuck at this stage without any progress for 2 hours.

Steps to check:

1. ConfigurationWizard.log repeatedly extends expiration
   • 2026-02-24 07:24:49,630 [17] DEBUG SqlHelper - SQL: SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
     
   • 2026-02-24 07:24:49,646 [17] INFO  CwActiveInstanceChecker - Extending expiration for active instance of ConfigWizard on machine I010101 (10.210.52.202)
2. Run Procmon on MPE, no suspended / pending activities
   •   
3. Login to SSMS > Activity Monitor > Search for Task State = Suspended
   •  
4. Find problematic query

   • ---

     -- Data\85_1_NCM_InsertMissingSRDResultsForAllACLs.sql
     ----

     INSERT INTO [dbo].[NCM_ShadowRuleDetectionAclStatistics] (ConfigId, [AccessListName], [FullyShadowedCount], [PartiallyShadowedCount], [FullyRedundantCount], [PartiallyRedundantCount])
     SELECT [ConfigId],
            [AccessListName],
            -2 AS [FullyShadowedCount],
            -2 AS [PartiallyShadowedCount],
            -2 AS [FullyRedundantCount],
            -2 AS [PartiallyRedundantCount]
     FROM
       (SELECT [ConfigId],
               [Name] AS [AccessListName]
        FROM [dbo].[NCM_ConfigAccessLists] AS SOURCE
        EXCEPT SELECT [ConfigId],
                      [AccessListName]
        FROM [dbo].[NCM_ShadowRuleDetectionAclStatistics] AS Dest) AS MissingRules

5. Killing the suspended process will end the Configuration Wizard
   •  
6. Manually run the SQL Query and it doesn't complete even after 8 minutes.
   • 

A suspended SQL query populating the [dbo].[NCM_ShadowRuleDetectionAclStatistics] table, which has grown excessively large.

1. Truncate the [dbo].[NCM_ShadowRuleDetectionAclStatistics].  
   • This database table stores one row per config + access list. It is populated when SRD runs on downloaded configs (during NCM download/analysis jobs).
   • This database table can be safely truncated
2. Execute the query to truncate the database table

   • -- 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.
     
     TRUNCATE TABLE [dbo].[NCM_ShadowRuleDetectionAclStatistics]

3. Re-run the Configuration Wizard.