Incorrect Inbound Summary Hourly Report

[jayudhandha]

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]

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.

[mflorell]

Try upgrading to the most recent svn/trunk version first. This may be an issue with the logs themselves that has already been fixed.

[jayudhandha]

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.

[mflorell]

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

Follow the UPGRADE document instructions.

[jayudhandha]

Hi,

I think I have found the issue

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.

[williamconley]

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.