This article discusses an issue that can occur when VNQM is not pulling any of the Call Detail Records (CDR) or Call Management Records (CMR) data for Cisco Unified Call Managers from the FTP\SFTP server even when the files are present on the server and the FTP\SFTP server shows VNQM logging into the client. The steps in this article only pertain to when the Job ID is not refreshing for CDR\CMR collection.
VNQM 4.0 and later
The issue occurs because the registered Job ID in the database has been corrupted or invalid and is constantly being recycled through the job engine. The Job ID will remain in the voipccmftpconnectioninfo table and not be purged out when the next poll interval comes through.
select currentjobid, currentjobstarttimeutc from voipccmftpconnectioninfo
update voipccmftpconnectioninfo set currentjobid = null
update voipccmftpconnectioninfo set currentjobstarttimeutc = null