Network Management

Resetting CDR sequence numbers in VNQM

How to reset the CDR sequence cluster numbers if you cannot poll CDR or CMR data after an upgrade or reconfiguration of the Cisco Call Manager for VNQM.

First published date

10/15/2018 3:36 PM

Last published date

9/15/2022 9:50 PM

Overview

After a recent upgrade, maintenance, or reconfiguration of Cisco CallManager, VNQM doesn't poll CDR or CMR data.

Product section

VoIP & Network Quality Manager

Cause

There is a change made in CUCM side which made the CDR/CMR sequence number to reset. VNQM will only pull CDR and CMR records with sequence number higher than the previously recorded sequence number. So if the sequence number was reset on the CUCM side, it will definitely have a lower value of the latest  CMR/CDR polled.

Resolution

​​​​*​​​Please Note: These steps will not work on more recent versions. Starting in 2022.3, VNQM no longer uses sequence numbers.

  1. Verify the FTP location where the files are downloaded from.Verify the sequence number of the files of the following format: cdr|cmr_[clustername]_[clusterID]_[timestamp]_[sequencenumber]

  2. Compare the sequence numbers with the contents of the CDRSeqenceNumberToDeleteFrom, CDRSeqenceNumberToDownloadFrom, CMRSeqenceNumberToDeleteFrom, and CMRSeqenceNumberToDownloadFrom columns of the VoipCcmFtpConnectionInfo database table.

  3. If the numbers in the columns are higher than in the files, reset the numbers in the indicated columns to NULL or 0 in the VoipCCMFtpConnectionInfo database table.

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

UPDATE VoipCCMFtpConnectionInfo
SET CDRSeqenceNumberToDeleteFrom = 0, CDRSeqenceNumberToDownloadFrom = 0, CMRSeqenceNumberToDeleteFrom = 0, CMRSeqenceNumberToDownloadFrom = 0