Incorrect Inbound Summary Hourly Report

Discussions about development of VICIDIAL and astGUIclient

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Incorrect Inbound Summary Hourly Report

Postby jayudhandha » Tue Aug 08, 2017 7:19 am

Hi All,

I have installed Vicidial 2.14-617a with Asterisk 1.8 and MySql 5.7.

My Vicidial reports are showing some incorrect data. Please find below snapshot for the same. I don't know why it is showing such long values. For some random cases it is fine.

Inbound Summary Hourly Report: |AGENTDIRECT_CHAT|ExistingHOI|ExistingIntl| 2017-08-08 17:37:23

---------- MULTI-GROUP BREAKDOWN:
+------------------------------------------+--------+--------+-----------+---------+-----------+---------+---------+--------+
| | | | | | TOTAL | AVERAGE | MAXIMUM | TOTAL |
| | TOTAL | TOTAL | TOTAL | AVERAGE | QUEUE | QUEUE | QUEUE | ABANDON|
| IN-GROUP | CALLS | ANSWER | TALK | TALK | TIME | TIME | TIME | CALLS |
+------------------------------------------+--------+--------+-----------+---------+-----------+---------+---------+--------+
| AGENTDIRECT_CHAT - Agent Direct Queue fo | 0 | 0 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0 |
| ExistingHOI - For existing queries | 8 | 8 | 0:15:14 | 0:01:54 | 0:00:00 | 0:00:00 | 0:00:00 | 0 |
| ExistingIntl - For existing queries of I | 35 | 31 | 417247:53:21 | 13459:36:34 | 0:17:02 | 0:00:29 | 0:01:49 | 4 |
+------------------------------------------+--------+--------+-----------+---------+-----------+---------+---------+--------+
| TOTALS In-Groups: 3 | 43 | 39 | 417248:08:35 | 10698:40:13 | 0:17:02 | 0:00:24 | 0:01:49 | 4 |
+------------------------------------------+--------+--------+-----------+---------+-----------+---------+---------+--------+

I have observed the incorrect TOTAL TALK and AVERAGE TALK.

Please help me to resolve this.
jayudhandha
 
Posts: 19
Joined: Thu May 07, 2015 1:22 am

Re: Incorrect Inbound Summary Hourly Report

Postby jayudhandha » Tue Aug 08, 2017 8:04 am

While troubleshooting the issue, I have done following things.

1. Go through the AST_CLOSERsummary_hourly.php which is reading the data from vicidial_closer_log table.
2. In that table, Some rows contain incorrect length_in_sec like 1502074857 which seems incorrect.
3. It is doing some below stuff,
select group_name,agent_alert_delay from vicidial_inbound_groups where group_id='$group[$i]'
$agent_alert_delay[$i] = round(MathZDC($row[1], 1000));

This agent_alert_delay is being used further which may be causing the problem.

I don't know I am going on the right path or not.

Please suggest.
jayudhandha
 
Posts: 19
Joined: Thu May 07, 2015 1:22 am

Re: Incorrect Inbound Summary Hourly Report

Postby mflorell » Tue Aug 08, 2017 12:20 pm

Try upgrading to the most recent svn/trunk version first. This may be an issue with the logs themselves that has already been fixed.
mflorell
Site Admin
 
Posts: 17854
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Incorrect Inbound Summary Hourly Report

Postby jayudhandha » Tue Aug 08, 2017 10:54 pm

This issue I am facing in the production environment.

How to upgrade?

Please provide me the steps such that my production flow does not affect.
jayudhandha
 
Posts: 19
Joined: Thu May 07, 2015 1:22 am

Re: Incorrect Inbound Summary Hourly Report

Postby mflorell » Wed Aug 09, 2017 6:42 am

Grab the most recent svn/trunk version of the code (http://wiki.vicidial.org/doku.php?id=svn)

Follow the UPGRADE document instructions.
mflorell
Site Admin
 
Posts: 17854
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Incorrect Inbound Summary Hourly Report

Postby jayudhandha » Thu Aug 10, 2017 12:33 am

Hi,

I think I have found the issue :-D

I have seen the vicidial_log and vicidial_closer_log table and found below issues.

For some entries, My length_in_sec is coming wrong.

start_epoch -> 1502339591 which is 10:03 AM
end_epoch -> 1502339642 which is 10:04 AM
length_in_sec -> 1502331828 which is 7:53 AM

Why there are such wrong entries? If we can solve this, then all reports will get corrected.
jayudhandha
 
Posts: 19
Joined: Thu May 07, 2015 1:22 am

Re: Incorrect Inbound Summary Hourly Report

Postby williamconley » Sat Sep 09, 2017 1:07 am

Which is probably the issue that Mflorell was talking about. Which is an issue that was resolved by upgrading.

did you upgrade?

Note that upgrading is not particularly difficult, nor is it time-consuming.

Read that UPGRADE document.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 19737
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Development

Who is online

Users browsing this forum: No registered users and 8 guests