IPAM scanning is stuck in queue and not running

Checking the IPAM Settings > Subnet Scans > View scan job status seeing Subnets Status stuck in queue/overdue.



-and/or-

Checking the Manage Subnets & IP Addresses, there are IP addresses getting stuck on Used, Available, Reserved, or Transient Status.

1. RDP to the affected SolarWinds Server (Main Polling Engine or Additional Polling Engine).
2. Perform the steps in the article Repair a failing Job Engine and Collector Components.
3. If the issue still persists, shut down all SolarWinds Services again in the SolarWinds Platform Service Manager, then proceed to the next steps.
4. Launch the Database Manager.
5. Please ensure that you have a current Database Backup.
6. Right-click on the SolarWinds Orion Database.
7. Select New Query.
8. Execute the query below to clear the IPAM Scan Job Status since the IP Status entries are from a previous Scan Job that is no longer updating or got stuck:

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

8. Restart all SolarWinds Services in the SolarWinds Platform Service Manager.
9. Recreate the Scan Job and make sure that the Status is now updating properly.