Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > VoIP & Network Quality Manager (VNQM) > VNQM - Knowledgebase Articles > Resetting CDR sequence numbers

Resetting CDR sequence numbers

Table of contents
No headers

Updated March 11th, 2016

 

Issue:

After a recent upgrade, maintenance or reconfiguration of CCM, there is no CDR or CMR data polled.

 

Solution:

  1. Verify the FTP location where the files are downloaded from.
  2. Verify the sequence number of the files of the following format: cdr|cmr_[clustername]_[clusterID]_[timestamp]_[sequencenumber].
  3. Compare the sequence numbers with the contents of the CDRSequenceNumberToDeleteFrom, CDRSequenceNumberToDownloadFrom, CMRSequenceNumberToDeleteFrom, and CMRSequenceNumberToDownloadFrom columns of the VoipCcmFtpConnectionInfo database table.
  4. 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.
Last modified

Tags

Classifications

Public