CDR reconciliation

Overview

CDR Reconciliation is a feature in the system which checks that all recordable conversations have been recorded correctly and warns if conversations have been lost. It works by comparing the original CDRs to the system database. The CDR reconciliation offers the following functions:

  • Periodically matches the original CDRs with the database records. If a conversation cannot be found in the Verba system, the service creates a database record in the system and flags it.
  • During the process, the service also compares the duration of the conversation to the length of the media file, and if the difference is bigger than the configured threshold, flags the record. Other media errors are checked during the recording process by the recording service,
  • Conversations that were not completed, such as not answered or busy, are also imported optionally and flagged (for Skype for Bussiness and Cisco only).
  • The service always looks for the CDRs created after the last run of the CDR reconciliation.
  • The reconciliation only works for the recorded extensions/addresses/numbers configured in the Verba database. Only extensions, where the recording mode is set to always-on, are used in the process.
  • Since recorders might insert the database records later (due to a connection issue with the database), the service periodically rechecks imported records and delete the ones where a matching recorded conversation is found.
  • The service can send system alerts if Lost  Conversations are identified. 
  • The standard search interface offers the ability to list conversations which were not recorded (but the reconciliation process inserted them), or conversations where the recorder detected media processing error(s)
  • Specific reports are available in the reporting tool for Lost Conversations. The reports can be generated automatically and sent via email.
  • The feature is available on:
    • Microsoft Lync 2010, 2013
    • Microsoft Skype for Business 2015, 2019
    • Cisco Unified Communications Manager 8.5 and later
    • Symphony XML
  • The system only processes voice/video conversations.
  • This feature increases the load on CDR databases and consequently may have a performance impact. Another side effect is, that users will be able to find Lost Conversations in the Web UI and not answered or established conversations too.

Before turning on this feature, please consult your system administrator to discuss the possible load on your CDR databases. Make sure your users are aware of this feature, and they understand the impact on the system. Once this feature is turned on, users will be able to find not only not recorded conversations, but not answered / not established conversations as well.

If you want to eliminate false alarms or unnecessary imports, consider testing all call scenarios before rolling out the feature.

The configuration for Lync/SfB and Cisco systems is different.

For the SfB CDR configuration, refer to the Configuring Lync - SfB CDR Reconciliation article.

For the Cisco CDR configuration, refer to the Configuring Cisco CDR Reconciliation article.

For Symphony CDR reconciliation, refer to Symphony Instant Messages - Files - CDRs.

The configuration of the CDR Reconciliation was changed in Verba version 9.0. The settings need to be manually moved from the server configuration to the import policy configuration when upgrading systems from earlier releases. Before an upgrade, save your current CDR connection configuration and re-implement it in an Import policy after the upgrade.

Finding not recorded or incorrect conversations

If CDR reconciliation is enabled, the system can identify not recorded conversations or conversations with incorrect media. The system hides these records by default; the web application has to be configured to display not recorded conversations. Please refer to the previous section for more information.

You can use the standard search feature to list these type of conversations. If you navigate to Search / Advanced Search Options / Recording audit, you can find the following options:

TypeDescription
Recorded conversationsConversations recorded properly, without any errors.
Recorded conversations with incorrect media

Conversations with media errors. The system can identify the following media errors:

  • No media
  • Length mismatch
  • RTP loss
  • RTP duplication
  • SRTP decryption error
  • Decoding error
  • Media mixing error

You can search for a specific type of error by using the Conversation detail record fields option and selecting the Media Check field.

The system uses thresholds (server level settings) to identify and mark recordings with media errors. If a certain type of error occurs more than the configured threshold, the recorder will automatically mark the recording.

Not recorded conversation due to errorConversations which were not recorded at all, but the system should have recorded them. These type of conversations also include conversations where the recorder has managed to insert a database record, but it was unable to record the media.
Not answered conversations

The CDR import process can be configured to import CDRs for not answered / established conversations. Refer to the CDR database connection parameters for more information on the configurations. The system can identify the following conversation types:

  • Canceled
  • Busy
  • Not found
  • Error

You can search for a specific type of code by using the Conversation detail record fields option and selecting the End Cause field.

Alerting on not recorded or incorrect conversations

When the system is running the reconciliation policy and it finds out that certain calls were not recorded (missing from the Verba database), an alert is raised showing the missing recordings. For more information on the alert, see CDR Importer Service: RecordFailure Alert.

Reporting not recorded or incorrect conversations

If you want to create reports periodically and send them in an email, you can use the new report templates available for CDR reconciliation:

Monitoring the reconciliation process

The CDR Importer service creates a task entry for each periodic run. These tasks can be monitored at System / Background Task page.

Â