1. This article describes the issue when the Configuration Wizard hangs on some stages and does not go further.

You have followed the below KB and check this article provides basic steps to troubleshoot SolarWinds Orion Configuration Wizard related issues:

• Troubleshoot Configuration Wizard issues

INFO  CwActiveInstanceChecker - Extending expiration for active instance of ConfigWizard on machine MySolarWindsSever (xxx.xxx.xxx.xxx)

ERROR DatabaseHelper - Unable to set active instance for ConfigWizard on machine MySolarWindsSever (xxx.xxx.xxx.xxx)! Reason: The transaction log for database 'SolarWindsOrionSAM' is full due to 'ACTIVE_TRANSACTION'.
System.Data.SqlClient.SqlException (0x80131904): The transaction log for database 'SolarWindsOrionSAM' is full due to 'ACTIVE_TRANSACTION'.

DEBUG SqlHelper - SQL: SELECT CAST((CASE WHEN SERVERPROPERTY('edition') = 'SQL Azure' THEN 1 ELSE 0 END) AS INT)
INFO  CwActiveInstanceChecker - Extending expiration for active instance of ConfigWizard on machine MY_Orion_Poller (xxx.xxx.xxx.xxx)
DEBUG SqlHelper - SQL: SELECT CAST((CASE WHEN SERVERPROPERTY('edition') = 'SQL Azure' THEN 1 ELSE 0 END) AS INT).

This means the error is due to the Configuration Wizard not being able to complete.

• Recent Orion database migration
• SQL Server disks under stress
• Temp DB is filling up
• Low Disk space on the SQL Server
• Database Maintenance issues (Orion database maintenance never completed or have Errors)
• Large Database
• Poor SQL Performance
• SQL Server not configured for correct Memory

• Reboot Orion Server Recommended
• SQL permission role requirements on the SolarWinds Orion Platform
• Why do I need SQL SA level account credentials for Configuration Wizard 
• Recover performance counters that are not working or missing in PerfMon - video
• Stop all SolarWinds Administration service on all polling engines, Webservers, and HA. and run the Configuration Wizard on the Polling Engine. Please make sure by checking all the Polling Engines current service state.
• Clear Information Service Subscriptions in Orion Products
• Right-click on the Configuration Wizard and choose Run as Administrator. 
• Please consult with your DBA to Investigate if there are SUSPENDED or BLOCKED Processes against the SolarWinds Orion database.  (Please make sure you have complete DB backup before Killing the SUSPENDED or BLOCKED ) 
• Please consult your DBA Running SQL Profiler  and filter traffic as below find the query where the configuration wizard is stuck

Filter Profiler Trace To Display Events From Orion Database 

Please consult your DBA ,  to run the SQL profiler and trap the queries and statements either for error debugging or to find performance issues. Limit the tracing to a specific Orion  database.

Here is the step by step instruction to filter the profiler trace to display events from a specific database.

Steps To Filter Profiler Trace For Events From Orion database

1. From the SQL profiler trace window, go to menu Files > Properties.
2. In the Trace Properties window, go to Events Selections tab.
3. Select the check box Show all columns.
4. Press the Columns Filters… button below.
5. In the Filter pop-up window, from the left panel select Orion DatabaseName.
6. From the right panel, under Like tree node, enter the database name and press OK.
7. Then, press Run button to start the trace.

Now the SQL profiler trace window will capture only the configuration wizard events queries from the Orion database 
 

• Check the Orion Database Size and Locating your Orion database properties and storing your DB files set to the single disk array. The disk is under pressure, creating some latency when running the Configuration Wizard. 
• Shrink the size of the Orion Database reduced the size from 60 Gig to 30 Gig (50%)
• Re-boot the SQL Server and manually complete the Database Maintenance; Re-run the Configuration Wizard once again by going to Start > run > All Programs > Solarwinds Orion > Configuration and Auto-Discovery > Configuration Wizard > select all 3 options. 
• Re-boot the Orion Server and re-run the Configuration Wizard once again by going to Start > run > All Programs > Solarwinds Orion > Configuration and Auto-Discovery > Configuration Wizard > select all 3 options. 

This time the Configuration Wizard will be completed successfully. To avoid such issues in the future, see the link:

• Quick Orion database health check guide

CWActiveInstanceChecker - Extending expiration for active instance of ConfigWizard on machine