Qualys Integration runs are stuck in "Wait complete" state

[Scorpion81]

Gentlemen,

We are using Qualys Integration Module with our Now instance. Since the past cpl of weeks, all the Qualys integration runs are in a state "Wait complete" , even though the substate shows to be "success".   Any idea how to troubleshoot this?  What could be the cause of this issue ?  Is there any scheduled job that could be causing this ?

Screenshot for reference:

 

[alexhouse · Accepted solution]

This indicates that all data has been downloaded to the instance, but the import queue still has processing to do before inserting/updating records in ServiceNow. There is a scheduled job that is meant to assign Import Queue Entries to Data Sources to be processed - this job is called "Scheduled Vulnerability Data Source Processor". This job must be enabled for this final processing step to occur, so that is one place to check. If that job is enabled, but the Integration Process records are not moving out of the "Queued" state, something else on the system may be interfering with the import queue. This can sometimes be caused by an a large attachment table that is slow to delete from, as the processing step deletes an attachment each time it assigns a new Import Queue Entry to a Data Source to be processed. 

Further investigation may be required to determine the root cause. 

[Scorpion81]

Thank you for the details. Appreciate your help

[cmcclendon]

So is it safe to say that a clean attachments table should have no entries for Qualys Host Detection Integration runs? I see many old attachments in ours (>5000).

-Chris