Error Count Drop & answer today realtime Repport Inbound_man

[voipvici]

Dear,
we noticed that the drops / answers today counters of the real time report are not correct, the configuration of the status, voicemail server active, check database are passed and validated
we dont know the cause of the sudden multiplication by 2 of these 2 counters
I re-produced the same error on another server with upgrade to svn 3529 , with inbound test calls



Revision: 3521
Asterisk 11.22.0-vici
Centos 7

[carpenox]

what do u mean by "not correct" ? are you talking about at the top of the hour? or are your stats not resetting from the day before?

[voipvici]

Thank you for reply , I noticed that there is an aliatory multiplication of the values ​​by 2

this is an exp 1 day production

Realtime Data (inbound only):
-----------------------------

CALLS TODAY: 150
DROPS TODAY: 54.000
ANSWERS TODAY: 128


Inbound Report : <---------- correct
------------------

Time range: 2021-10-22 00:00:00 to 2021-10-22 23:59:59

---------- TOTALS
Total calls routed: 150
Answered Calls: 119

---------- DROPS
Total DROP Calls: 29

[carpenox]

try running a mysqlcheck you may have corrupt tables

[voipvici]

Dear, i already done all that, also the different settings as:
-Timeclock End Of Day
- Active Voicemail Server
- Rebuild conf files

[voipvici]

Doing test on other server with SVN upgrade (SVN Version: 3531 , DB Schema Version: 1646) same error the value drops & answers today is multiplied by 2

Realtime repport:
----------------------
CALLS TODAY: 16 TMA 1: 156.25% Average Hold time for Answered Calls: 8 TIME: 2021-10-23 21:49:25
DROPS TODAY: 16.000 TMA 2: 168.75% Average Hold time for Dropped Calls: 8
ANSWERS TODAY: 16 (Agent non-pause time / Answers) Average Hold time for All Calls: 16
DROP PERCENT: 100.00% PRODUCTIVITY: 0.54


Inbound Report:------------> correct
Time range: 2021-10-23 00:00:00 to 2021-10-23 23:59:59

---------- TOTALS
Total calls routed: 16
Average Call Length for routed Calls: 13 seconds
Answered Calls: 8 50%


---------- DROPS
Total DROP Calls: 8 50% drop/answered: 100%
Average hold time for DROP Calls: 12 seconds

[voipvici]

Any help ! plz , i still have the pb the drop & answer counter (x 2) multiplied by 2

MariaDB [asterisk]> SELECT `calls_today` , `drops_today` , `answers_today`
-> FROM `vicidial_campaign_stats`
-> WHERE `campaign_id` = 'testingroup'
-> LIMIT 0 , 30;
+-------------+-------------+---------------+
| calls_today | drops_today | answers_today |
+-------------+-------------+---------------+
| 5 | 4.000 | 6 |
+-------------+-------------+---------------+
1 row in set (0.01 sec)

[voipvici]

Plz Can any one check if it's something's wrong with this query

/usr/share/astguiclient/AST_VDadapt.pl:3820:
$stmtA = "UPDATE vicidial_campaign_stats SET calls_today='$VCScalls_today[$i]',answers_today='$VCSanswers_today[$i]',drops_today='$VCSdrops_today[$i]',drops_today_pct='$VCSdrops_today_pct[$i]',drops_answers_today_pct='$VCSdrops_answers_today_pct[$i]',calls_hour='$VCScalls_hour[$i]',answers_hour='$VCSanswers_hour[$i]',drops_hour='$VCSdrops_hour[$i]',drops_hour_pct='$VCSdrops_hour_pct[$i]',calls_halfhour='$VCScalls_halfhour[$i]',answers_halfhour='$VCSanswers_halfhour[$i]',drops_halfhour='$VCSdrops_halfhour[$i]',drops_halfhour_pct='$VCSdrops_halfhour_pct[$i]',calls_fivemin='$VCScalls_five[$i]',answers_fivemin='$VCSanswers_five[$i]',drops_fivemin='$VCSdrops_five[$i]',drops_fivemin_pct='$VCSdrops_five_pct[$i]',calls_onemin='$VCScalls_one[$i]',answers_onemin='$VCSanswers_one[$i]',drops_onemin='$VCSdrops_one[$i]',drops_onemin_pct='$VCSdrops_one_pct[$i]',agent_non_pause_sec='$VCSagent_nonpause_time[$i]',agent_calls_today='$VCSagent_calls_today[$i]',agent_pause_today='$VCSagent_pause_today[$i]',agent_wait_today='$VCSagent_wait_today[$i]',agent_custtalk_today='$VCSagent_custtalk_today[$i]',agent_acw_today='$VCSagent_acw_today[$i]',answering_machines_today='$VCSam_today[$i]',agenthandled_today='$VCSagenthandled_today[$i]',park_calls_today='$VCSpark_calls_today[$i]',park_sec_today='$VCSpark_sec_today[$i]',$VSCupdateSQL where campaign_id='$campaign_id[$i]';";


/usr/share/astguiclient/AST_VDadapt.pl_origin:3955:
$stmtA = "UPDATE vicidial_campaign_stats vcs, vicidial_campaigns vc SET vcs.drops_answers_today_pct='$DRdrops_answers_today_pct' where vcs.campaign_id=vc.campaign_id and vc.drop_rate_group='$DRgroup[$dr]';";

/usr/share/astguiclient/AST_VDadapt.pl:6283:
$stmtA = "UPDATE vicidial_campaign_stats SET calls_today='$iVCScalls_today[$p]',answers_today='$iVCSanswers_today[$p]',drops_today='$iVCSdrops_today[$p]',drops_today_pct='$iVCSdrops_today_pct[$p]',drops_answers_today_pct='$iVCSdrops_answers_today_pct[$p]',hold_sec_stat_one='$answer_sec_pct_rt_stat_one_PCT[$p]',hold_sec_stat_two='$answer_sec_pct_rt_stat_two_PCT[$p]',hold_sec_answer_calls='$hold_sec_answer_calls[$p]',hold_sec_drop_calls='$hold_sec_drop_calls[$p]',hold_sec_queue_calls='$hold_sec_queue_calls[$p]',park_calls_today='$iVCSpark_calls_today[$p]',park_sec_today='$iVCSpark_sec_today[$p]',$VSCupdateSQL where campaign_id='$group_id[$p]';";