Error Count Drop & answer today realtime Repport Inbound_man

All installation and configuration problems and questions

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

Error Count Drop & answer today realtime Repport Inbound_man

Postby voipvici » Fri Oct 22, 2021 12:49 pm

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
SVN: 3521 | Asterisk 11.22.0-vici | Centos 7 | DB Schema Version: 1645 | Version: 2.14b0.5
voipvici
 
Posts: 6
Joined: Fri Oct 22, 2021 9:36 am

Re: Error Count Drop & answer today realtime Repport Inbound

Postby carpenox » Fri Oct 22, 2021 2:38 pm

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?
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Error Count Drop & answer today realtime Repport Inbound

Postby voipvici » Fri Oct 22, 2021 2:44 pm

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
SVN: 3521 | Asterisk 11.22.0-vici | Centos 7 | DB Schema Version: 1645 | Version: 2.14b0.5
voipvici
 
Posts: 6
Joined: Fri Oct 22, 2021 9:36 am

Re: Error Count Drop & answer today realtime Repport Inbound

Postby carpenox » Fri Oct 22, 2021 3:08 pm

try running a mysqlcheck you may have corrupt tables
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Error Count Drop & answer today realtime Repport Inbound

Postby voipvici » Sat Oct 23, 2021 5:20 am

Dear, i already done all that, also the different settings as:
-Timeclock End Of Day
- Active Voicemail Server
- Rebuild conf files
SVN: 3521 | Asterisk 11.22.0-vici | Centos 7 | DB Schema Version: 1645 | Version: 2.14b0.5
voipvici
 
Posts: 6
Joined: Fri Oct 22, 2021 9:36 am

Re: Error Count Drop & answer today realtime Repport Inbound

Postby voipvici » Sat Oct 23, 2021 3:54 pm

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
SVN: 3521 | Asterisk 11.22.0-vici | Centos 7 | DB Schema Version: 1645 | Version: 2.14b0.5
voipvici
 
Posts: 6
Joined: Fri Oct 22, 2021 9:36 am

Re: Error Count Drop & answer today realtime Repport Inbound

Postby voipvici » Sun Oct 24, 2021 4:30 am

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)
SVN: 3521 | Asterisk 11.22.0-vici | Centos 7 | DB Schema Version: 1645 | Version: 2.14b0.5
voipvici
 
Posts: 6
Joined: Fri Oct 22, 2021 9:36 am

Re: Error Count Drop & answer today realtime Repport Inbound

Postby voipvici » Sun Oct 24, 2021 5:35 am

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]';";
SVN: 3521 | Asterisk 11.22.0-vici | Centos 7 | DB Schema Version: 1645 | Version: 2.14b0.5
voipvici
 
Posts: 6
Joined: Fri Oct 22, 2021 9:36 am


Return to Support

Who is online

Users browsing this forum: Majestic-12 [Bot] and 88 guests