Problem
Customer has large amount of "In Progress" jobs that will never finish.
- project had a location with targets in a /16 subnet
- paused project and created a new location with the addresses separated into many /22 subnets to see if performance would increase
- started new project and now no new jobs are being served.
- select * from history.v_ProjectOverallSummary shows an impossible number of active jobs in the paused project (see screenshot)
- select * from jobs.t_job where TargetStatusID=8 returns over 45k rows
- restarted iQSonar Service on both scan engine servers, no errors and jobs are still not b being served.
- cpu on one server in system performance is at 72% but no new scan target logs are being created.
Solution
From the SSMS open a new query from the systems iQSonarSE database
SELECT * FROM jOBS.t_Queue, Note the JobStatusID is set to -3
Run the following sql to update the JobStatusID to Served/Complete
UPDATE jOBS.t_Queue SET JobStatusID = 1
Following that you will be able to set a rescan of the targets or set up a new Project.
Related articles