Recordings not showing up in Recording Search Tool

Recordings not showing up in Recording Search Tool

This situation happens because the Nixxis Application server was abruptly stopped or restarted without first stopping the CRAppServer Service gracefully or the CrAppServer Service has crashed
 
Procedure:
 
If the CrReportingTool is not installed, install it
- Download deprecated tools from update.nixxis.net : http://update.nixxis.net/Tools/DeprecatedNixxisTools.zip
- Unblock the zip file and extract its contents. 
- Copy CrReportingTool.exe to C:\Nixxis\CrAppServer\reporting 
- Then copy all DLL files from CrAppServer folder to the reporting folder as well.
 
Run the CrReportingTool
 
Click on Read Info and look for the values in section “Current values”
 
If you encounter error messages it means that the CrRecording Tool is unable to read the binary control files, click on OK to the error messages




Start SQL Server Management Studio
 
Run the following queries:
 
  1. select top 5 * from ContactRouteReport..OUT_Contact order by DateTimeValue desc
  2.  
  3. select top 5 * from ContactRouteReport..in_Contact order by DateTimeValue desc
 
If you do only inbound you can skip the OUT_contact line and similarly if you do only outbound you can skip the in_contact line.
This to check the last entries in compiled by the reportserver. 
You should see a DateTimeValue that corresponds to the latest calls made.
 
  1. select top 50  * from eventserver..events order by UTCDateTime desc
 
The database EventServer contains all raw data, you can check if it is storing data to the latest event by running the above query.
You can run this query alongside the above queries for comparison.



If you see a DateTimeValue less than what it is supposed to be, note down the latest DateTime recorded.

Then run the following query, adjusting the date and time to be within 1 minute from the recorded time.

 

  1. Select * from eventserver..events
  2. where UTCDateTime >'2017-07-26 15:17:00'
  3. and UTCDateTime <'2017-07-26 15:18:00'
  4. order by UTCDateTime desc

 




Look for the events closest to the last event compiled. In the case in the screenshot, I chose an event right after the time of the last compiled event.

 

Note down the value of field Ident.

 

 

Go back to the CrReportingTool.

 

On the right-side, in section “New values”, enter the Event Ident you wrote down




Hit save and close the tool

 

Restart CrAppServer service

 

Given the volume of statistical data, it might a few minutes (or hours) for the reports/stats to recompile from the event server.

 

Then run the reports again to test.



    • Related Articles

    • How to enable search via http relay

      This document shows a sample configuration to implement to allow the search of recording files on Media server via HTTP relay. Port 80 or other designated server port need to be opened to allow the traffic. lighttpd configuration File to modify: ...

    • Recording Modes

      Introduction The purpose of this article is to provide information on how to setup the different recording modes available in Nixxis Contact Suite. 1. Recording settings in config files RecordingMode in Http.config's admin section is a combination of ...

    • Quality Monitoring Tool - User Interface V3.x

      Access to the interface Once you are in the cockpit, choose via the module selector, the Quality Monitoring Tool When the quality monitoring tool is open, you will find 4 different choices. The first is again the module selector which will allow you ...

    • Technical Parameters - Answering Machine Detection

      Introduction This article provides an overview of the AMD (Answering Machine Detection) settings in Nixxis Contact Suite. It explores the technical parameters and customisation options available for optimising AMD settings based on specific ...

    • Adding files with reminder dates - V3.0 - EN

      Introduction This article aims to describe the functionalities for adding files with specific callback dates. Step 1 : Datetime format fields On the campaign, you must have a field in datetime format. Step 2 : Import files In the import file, you ...