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

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

    • Listing of standard reports and exports

      Introduction This article aims to list and describe the standard reports and exports available in the reporting tool of Nixxis Contact Suite. After the selection of a report, this functionality allows the user to view the report. After the selection ...

    • Administration - Activity - Select Outgoing Activity via Search Mode

      Introduction This article explains the operation of replacing the classic search mode with the "Allow search mode" option, which allows the agent to select the outgoing activity from which the record is searched and numbered. Prerequisites This ...