Page 1 of 2

NO LIVE CALLS WAITING

PostPosted: Tue Jun 19, 2012 4:26 am
by tarundas
Dialer dialed without issues for 2 months ... then suddenly having issue with "NO LIVE CALLS WAITING". Autodialer stops dialing after few hours of dialing. Leads are available and HOPPER is fine. CLI becomes idle and shows no activity. Screen -list command on TELEPHONY SERVER gives the same output as in normal condition. Manual dial is possible during this problem.
Code: Select all
# screen -list
There are screens on:
        2881.ASTfastlog (Detached)
        2783.asterisk   (Detached)
        2879.ASTVDremote        (Detached)
        2873.ASTsend    (Detached)
        2875.ASTlisten  (Detached)
        2778.astshell20120619124711     (Detached)
        2877.ASTVDauto  (Detached)
        2870.ASTupdate  (Detached)
8 Sockets in /var/run/screens/S-root.

Dialer dials normally when I reboot the TELEPHONY SERVER. Once I was not around to restart the TELEPHONY SERVER and agents had to wait for 3 hours before autodialer started dialing again by its own ( without rebooting the server ). TELEPHONY SERVER is not connected to INTERNET so I don't think there is any outside activity involved in this upshot.
What's could be the problem ?

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jun 19, 2012 7:58 am
by rrb555
you repair your database.

check your original recordings folder "ORIG" file size

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jun 19, 2012 2:01 pm
by tarundas
performed mysqlcheck earlier but without any luck
Code: Select all
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

Harddisk space check
Code: Select all
#df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1             456G   82G  351G  19% /
devtmpfs              2.0G  200K  2.0G   1% /dev
tmpfs                 2.0G  4.0K  2.0G   1% /dev/shm
tmpfs                 6.0G     0  6.0G   0% /var/spool/asterisk/monitor

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jun 19, 2012 2:36 pm
by rrb555
use this

Code: Select all
du -h /var/spool/asterisk/monitorDONE/

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jun 19, 2012 3:35 pm
by tarundas
Code: Select all
# du -h /var/spool/asterisk/monitorDONE/
4.0K    /var/spool/asterisk/monitorDONE/FTP
12G     /var/spool/asterisk/monitorDONE/MP3
4.0K    /var/spool/asterisk/monitorDONE/FTP2
4.0K    /var/spool/asterisk/monitorDONE/GSM
4.0K    /var/spool/asterisk/monitorDONE/OGG
4.0K    /var/spool/asterisk/monitorDONE/GSW
9.4G    /var/spool/asterisk/monitorDONE/ORIG
21G     /var/spool/asterisk/monitorDONE/

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jun 19, 2012 3:41 pm
by mcargile
I had a client who had a similar problem recently. Their vicidial_manager table had been converted to a memory table, and they were running out of RAM. The reboot flushed the memory table so that is why it would start working again. Switching it to a memory table does improve performance, but if you do not have enough ram and you are doing heavy outbound dialing it can fill up.

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jun 19, 2012 4:13 pm
by tarundas
I can see a vicidial_manager table in the database. 4GB RAM on TELEPHONY SERVER, 25 agents dialing at 1.5 ratio
Code: Select all
mysql> show tables;
+-----------------------------------+
| Tables_in_asterisk                |
+-----------------------------------+
| call_log                          |
| call_log_archive                  |
| callcard_accounts                 |
| callcard_accounts_details         |
| callcard_log                      |
| conferences                       |
| contact_information               |
| dialable_inventory_snapshots      |
| groups_alias                      |
| inbound_numbers                   |
| live_channels                     |
| live_inbound                      |
| live_inbound_log                  |
| live_sip_channels                 |
| park_log                          |
| parked_channels                   |
| phone_favorites                   |
| phones                            |
| phones_alias                      |
| recording_log                     |
| server_performance                |
| server_updater                    |
| servers                           |
| system_settings                   |
| twoday_call_log                   |
| twoday_recording_log              |
| twoday_vicidial_agent_log         |
| twoday_vicidial_closer_log        |
| twoday_vicidial_log               |
| twoday_vicidial_xfer_log          |
| user_call_log                     |
| vicidial_admin_log                |
| vicidial_agent_log                |
| vicidial_agent_log_archive        |
| vicidial_agent_skip_log           |
| vicidial_agent_sph                |
| vicidial_api_log                  |
| vicidial_auto_calls               |
| vicidial_call_menu                |
| vicidial_call_menu_options        |
| vicidial_call_notes               |
| vicidial_call_notes_archive       |
| vicidial_call_times               |
| vicidial_callbacks                |
| vicidial_campaign_agents          |
| vicidial_campaign_cid_areacodes   |
| vicidial_campaign_dnc             |
| vicidial_campaign_hotkeys         |
| vicidial_campaign_server_stats    |
| vicidial_campaign_stats           |
| vicidial_campaign_stats_debug     |
| vicidial_campaign_statuses        |
| vicidial_campaigns                |
| vicidial_campaigns_list_mix       |
| vicidial_carrier_log              |
| vicidial_carrier_log_archive      |
| vicidial_closer_log               |
| vicidial_closer_log_archive       |
| vicidial_conf_templates           |
| vicidial_conferences              |
| vicidial_cpd_log                  |
| vicidial_custom_cid               |
| vicidial_daily_max_stats          |
| vicidial_did_agent_log            |
| vicidial_did_agent_log_archive    |
| vicidial_did_log                  |
| vicidial_did_ra_extensions        |
| vicidial_dnc                      |
| vicidial_drop_rate_groups         |
| vicidial_extension_groups         |
| vicidial_filter_phone_groups      |
| vicidial_filter_phone_numbers     |
| vicidial_grab_call_log            |
| vicidial_hopper                   |
| vicidial_inbound_dids             |
| vicidial_inbound_group_agents     |
| vicidial_inbound_groups           |
| vicidial_ivr                      |
| vicidial_lead_filters             |
| vicidial_lead_recycle             |
| vicidial_lead_search_log          |
| vicidial_lead_search_log_archive  |
| vicidial_list                     |
| vicidial_list_alt_phones          |
| vicidial_list_pins                |
| vicidial_list_update_log          |
| vicidial_lists                    |
| vicidial_lists_fields             |
| vicidial_live_agents              |
| vicidial_live_inbound_agents      |
| vicidial_log                      |
| vicidial_log_archive              |
| vicidial_log_extended             |
| vicidial_log_extended_archive     |
| vicidial_log_noanswer             |
| vicidial_log_noanswer_archive     |
| vicidial_manager                  |
| vicidial_manual_dial_queue        |
| vicidial_music_on_hold            |
| vicidial_music_on_hold_files      |
| vicidial_nanpa_prefix_codes       |
| vicidial_outbound_ivr_log         |
| vicidial_outbound_ivr_log_archive |
| vicidial_override_ids             |
| vicidial_pause_codes              |
| vicidial_phone_codes              |
| vicidial_postal_codes             |
| vicidial_process_trigger_log      |
| vicidial_process_triggers         |
| vicidial_qc_codes                 |
| vicidial_remote_agent_log         |
| vicidial_remote_agents            |
| vicidial_screen_labels            |
| vicidial_scripts                  |
| vicidial_server_carriers          |
| vicidial_server_trunks            |
| vicidial_shifts                   |
| vicidial_state_call_times         |
| vicidial_stations                 |
| vicidial_status_categories        |
| vicidial_statuses                 |
| vicidial_territories              |
| vicidial_timeclock_audit_log      |
| vicidial_timeclock_log            |
| vicidial_timeclock_status         |
| vicidial_tts_prompts              |
| vicidial_url_log                  |
| vicidial_user_closer_log          |
| vicidial_user_groups              |
| vicidial_user_log                 |
| vicidial_user_territories         |
| vicidial_user_territory_log       |
| vicidial_users                    |
| vicidial_voicemail                |
| vicidial_xfer_log                 |
| vicidial_xfer_presets             |
| vicidial_xfer_stats               |
| vtiger_rank_data                  |
| vtiger_rank_parameters            |
| vtiger_vicidial_roles             |
| web_client_sessions               |
+-----------------------------------+
141 rows in set (0.00 sec)

Re: NO LIVE CALLS WAITING

PostPosted: Wed Jun 27, 2012 2:42 pm
by tarundas
A fresh installation of complete setup did not help ... facing the same issue ... autodialer stops dialing whenever it wishes ..
Hardware is faulty? ...Manual dialing is possible so I am not giving much thought to it.
This particular version of vici is to blame ? ... damn! I don't even wanna think of it ... reInstillation is a PITA
Or it has to do with Server Load ? ... is it possible that server(s) crosses the load limit for a moment or two and autodialer stops dialing and never starts even when the load comes down to normal ?
Matt, will you shed some light on this ?

Re: NO LIVE CALLS WAITING

PostPosted: Wed Jun 27, 2012 2:45 pm
by rrb555
check
Code: Select all
htop


let us know the output

Re: NO LIVE CALLS WAITING

PostPosted: Wed Jun 27, 2012 3:05 pm
by tarundas
yes I used 'htop' during the problem many times and found the load normal ...maybe it crosses the limit before the problem starts for a second or two and triggers the problem ? Any such possibility ?

Re: NO LIVE CALLS WAITING

PostPosted: Thu Jun 28, 2012 3:16 pm
by rrb555
hmm that is strange.. can you delete all recordings under ORIG files, repair database, restart and test it again.

I had this problem I think few years ago and the problem I think with the server is having too many recordings under ORIG folder. I have a normal hard disk that i think started the problem, maybe it is not running in optimal performance.

I am trying the SSD and seems nice. u could try that one,

I hope i can be of any help

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 6:29 am
by tarundas
Replaced Telephony server hard disk (doubted there could be bad sectors ), replaced Web server (more powerful), reinstalled all three servers, this time without SVN... BUT NO LUCK ... It does not matter how many agents ...it can happen with 2 agents only and it can happen with 20 agents....it can happen within 5 minutes of rebooting or can survive for 3 hours. It's becoming a nightmare now.

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 7:08 am
by rrb555
try using a single server. 20 agents can withstand a single quad core server

Also, how do upload your leads?

explain in detail on how u run ur campaign

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 7:19 am
by DomeDan
in your first post, the screen ASTVDadapt is not there. (its this script: /usr/share/astguiclient/AST_VDadapt.pl)
are you using ratio or adapt when autodialing?

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 7:26 am
by tarundas
There are two screens running in my DB server including ASTVDadapt ...
Code: Select all
There are screens on:
        3236.ASTVDadapt (Detached)
        3238.ASTVDautoFILL      (Detached)
2 Sockets in /var/run/screens/S-root.


I am using RATIO 1.2 ... 1.5 at top

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 7:34 am
by DomeDan
Ok, then I'm out of thoughts, but answer rrb555 who wrote a post just before mine:

rrb555 wrote:try using a single server. 20 agents can withstand a single quad core server

Also, how do upload your leads?

explain in detail on how u run ur campaign

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 8:15 am
by tarundas
The guy who uploads leads does it in following format...
phonecode,(91) phonenumner,(10 digits) name, city, state. Uploads CSV file without headers.

Campaign
Dial Prefix: 9
Omit Phone Code: Y

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 8:22 am
by rrb555
when u say phone 91, does u change the field "phone code override" under admin_listloader_fourth_gen.php ?

check this. convert leads file to text tab delimited.
Note: raw file should be in excel format, if in csv convert file first to excel (.xls or .xlsx) then to text tab delimited

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 8:39 am
by tarundas
No, no phone code override, only List ID override in vicidial/new_listloader_superL.php

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 8:46 am
by rrb555
wow really I think what i said is the recommended one. Maybe try that one?

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 02, 2012 9:15 am
by tarundas
Did you mean tab delimited text ? Ok, I will try that

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jul 03, 2012 8:55 am
by tarundas
Well, tab delimited text lead format did not help.
Today, for the first time I set the Dial Method to ADAPT_TAPERED and it survived for 5 hours ... then suddenly in the CLI I got following messages rolling on ..
Code: Select all
[Jul  3 18:21:37] WARNING[22981]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600072@default-7bad,2
[Jul  3 18:21:37] WARNING[22834]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600072@default-8f15,2
[Jul  3 18:21:37] WARNING[22650]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600072@default-f30a,2
... ... ...
... ... ...


And the autodialer stopped calling.

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jul 03, 2012 4:09 pm
by tarundas
Are you listening William ?

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jul 03, 2012 4:35 pm
by DomeDan
Nice a real trace to the issue, I googled it and found:
http://www.vicidial.org/VICIDIALforum/v ... hp?t=24379
gmcust3 wrote:In one of the forum posting .. someone also faced the same problem ... also when I restart mysql.. calls get start... but I have to ask my agents to log off and login..

U can also see

http://goautodial.org/boards/3/topics/356

which leads to this:
gm.cust3 wrote:DELETE FROM vicidial_auto_calls where channel IS NULL

Once I run this Sql, All starts again.

But why calls are getting stucked and Status comes as XFER ?


try that, if its work and you would like to fix the problem then write to gmcust3 and check if you two have anything in common
maybe its a providor issue?

Re: NO LIVE CALLS WAITING

PostPosted: Wed Jul 04, 2012 9:31 am
by tarundas
Thank you DomeDan ... I appreciate your effort..
Seems like having the same issues as gmcust3. Autodialer starts dialing again by running the following SQL query
Code: Select all
DELETE FROM vicidial_auto_calls where channel IS NULL

But that happens only if I run the query within a minute or so once the problem is visible. Delays up to 5 -7 minutes does not do much help. Running this query through an Event scheduler on every 60 seconds gave me some relief but not much, if effected rows are higher in number within that minute autodialer stops dialing and only a reboot of Telephony server resolves the issue.
Running this query is a patchwork anyway, a treatment not the cure. Good for the time being though. Question is why is this happening?
I have written to gmcust3, hopping for his reply.

Re: NO LIVE CALLS WAITING

PostPosted: Wed Jul 04, 2012 9:51 am
by rrb555
tarundas wrote:Well, tab delimited text lead format did not help.
Today, for the first time I set the Dial Method to ADAPT_TAPERED and it survived for 5 hours ... then suddenly in the CLI I got following messages rolling on ..
Code: Select all
[Jul  3 18:21:37] WARNING[22981]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600072@default-7bad,2
[Jul  3 18:21:37] WARNING[22834]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600072@default-8f15,2
[Jul  3 18:21:37] WARNING[22650]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600072@default-f30a,2
... ... ...
... ... ...


And the autodialer stopped calling.


Seems like I also experienced this issue last January 2012

viewtopic.php?f=8&t=22744

Re: NO LIVE CALLS WAITING

PostPosted: Wed Jul 04, 2012 9:55 am
by williamconley
identify one of the leads that gets stuck in the autocalls and validate the information in it. if it has (for instance) the wrong number of digits and cannot be dialed because there is no matching dialplan, this could explain the problem. try re-setting that lead and dialing it while watching the asterisk command line to see what dial plan lines execute and where the process goes awry.

but if you are experiencing frame write errors, it is more likely a networking issue.

Re: NO LIVE CALLS WAITING

PostPosted: Wed Jul 04, 2012 10:00 am
by rrb555
but if you are experiencing frame write errors, it is more likely a networking issue.


this is really a networking issue. with my issue last January 2012 viewtopic.php?f=8&t=22744 , I found out that one of the NIC is faulty

Re: NO LIVE CALLS WAITING

PostPosted: Wed Jul 04, 2012 2:15 pm
by tarundas
Thank you everybody. Tomorrow I will replace the network card and post back.
I am using 'D-Link DGE-528T Gigabit Ethernet Adapter', I have couple of extra brand new cards of same make and model, I will replace the present card with one of them. Hope this model is fully compatible with my version of Linux kernel 2.6.34.10-0.4-pae. At least D-Link claims on box that it is compatible with 2.6.x Linux kernal.

Edit: I did not do SVN on my last re-installation (the third) so present VERSION: 2.2.1-237 and BUILD: 100510-2015

Re: NO LIVE CALLS WAITING

PostPosted: Thu Jul 05, 2012 1:39 pm
by tarundas
Sorry, I am late ... I had to attend a party.
Well, replacing dialer network cards did not help, a new proxy server did not help either. But I think I found some definite clue today almost at the end of the shift. I will write about it tomorrow after final observation.
Thank you

Re: NO LIVE CALLS WAITING

PostPosted: Fri Jul 06, 2012 9:58 am
by williamconley
networking issues are rarely "network card". they are more often related to poor wiring or a bad network diagram or a router/switch somewhere in the path. sometimes they are even malicious software of simple overload.

use wireshark and/or other network packet analyzers to see if you can "find" the dropping packets and work from there.

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 09, 2012 5:18 am
by tarundas
Sorry again for being late … was enjoying my weekend first time in three weeks.

5th July:
It’s 19th day. While entering into the office I noticed pity in receptionist’s voice when she said good morning even without looking at her. I went to the terrace… smoked like a train… smoking normally has a great effect on me, calming me and helping me to think. It didn't do much good this day. Haven’t I tried everything, even those that doesn't make any sense? Nothing worked. To be perfectly honest dudes …I have faced issues before but for some reason this one has me in a state of panic! It’s the same feeling when I get on a plane, or even worse, when I look down from the high building.
Don't worry, I'll get over it. I'll try to approach the situation with determination, confidence... Like a man! I want my mommy!!!!

I was stuck with William’s idea that day “it is more likely a networking issue” ... But what does that mean in real life –LOL. Ok, if it means test every visible network component in this place, THEN SO BE IT!
Next time the error started rolling on the CLI I picked up the error message ….
Code: Select all
[Jul  5 15:39:39] WARNING[3508]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600063@default-e92c,2

Looked for SESSION ID 8600063 in Real Time Report and found the STATION ID, the guy was on a manual call. I saw autodialer was slowing down its pace, I understood it was going to stop within few seconds. Logged into DB and ran gmcust3’s savior SQL query a few times in panic. The very first time I ran it I found around 350 rows were affected. Autodialer took its pace but agents were not getting calls. Warnings were still rolling on the CLI almost 50 in a second. I wanted to hit that guy in the nose … but… hang on a second...doesn't he look stronger than me? No problem, haven’t I read ‘computer is mightier than the sword’? …yeah, I can kick him out of this campaign …AND SO I DID…in Matt’s language it’s ‘EMERGENCY LOG AGENT OUT’. Voila …warnings stopped and agents started to get calls. Why I did not do that in all those days??? I stood up and yelled like Tarzan, female members of the room thought this was a little amusing. I turned to them and said, “Common sense is a wonderful thing...Use it”.

A SWITCH GONE WILD!!!!!!!!!

Found some strange behavior of that switch. There were two ports that caused the warnings on CLI when manual calls were being made, the third port, doesn’t generate any warning on CLI but was causing vicidial_auto_calls table to fill up with NULL channels …a lot of them, over 100 in few seconds and causing autodialer to slow down and eventually stop it in the span of two minutes.

6th July
Replaced that switch .... and I am the happiest man in this world.

If it wasn't for this forum, I'd be foaming at the mouth, surrounded by rubber walls and wearing a long sleeved jacket by now! Thanks to everyone here for helping to keep me sane.... Well, as sane as I'll ever be.

Thing that remains a mystery: Why only manual calls were affected ?

Bottom Line: A Rolling stone gathers no moss, a rolling error does ;)

PS: Light travels faster than sound. That's why some people appear bright, until you hear them speak.

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 09, 2012 5:37 am
by DomeDan
Haha, Amusing post-back! :D

Re: NO LIVE CALLS WAITING

PostPosted: Mon Jul 09, 2012 10:04 am
by williamconley
You really need to cut back on the caffeine, man. LOL

Re: NO LIVE CALLS WAITING

PostPosted: Tue Jul 17, 2012 10:32 pm
by davesdatasystems
Smokes and coffee has helped me make it through many rough IT days.

Re: NO LIVE CALLS WAITING

PostPosted: Fri Jul 20, 2012 12:29 pm
by GaD
Jaja! 90% of the IT people I know can also say that! Those that don't smoke are few, those that don't drink coffee are VERY rare and those that don't do either one (like myself) are almost extinct! ...I hope I don't end up in a museum! :)

Re: NO LIVE CALLS WAITING

PostPosted: Mon Sep 17, 2012 4:58 pm
by praveenj79
Hi I have seen this no live call issue when any agent try to refresh his login window continuously the the dialer stop dialing.

i use script to clear and after that dialing start.

cd /usr/share/astguiclient/


./AST_reset_mysql_vars.pl

till date i could not find a solution for it if any one have guide me.

Re: NO LIVE CALLS WAITING

PostPosted: Fri Nov 27, 2015 3:20 pm
by vishalsss11
HI.

I have faced the same issue, and its been 7 days like you i have also changed almost everything but the solution was shocking....

this may sound crazy but it worked..now i am running a happy outbound campaign ..

After trying everything i noticed my agents talking to each other that how much they are enjoying of sitting ideal at work.They use to press shift enter ad ctrl together thats y the dialler use to take a lod on it. i removed the keyboard and anyways to work on Vicidial keyboard is hardly required i gave them on screen keyboard so that they cannot press those three keys together.. Do the same bro,,, m usre u might be laughing but this is the fact vicidial team should work on this bug fix...i hope it will help you. M definaely sure it would work.. if it does not dont blame me i am just tring to help,, but it worked for me tq

Regards
Vishal

Re: NO LIVE CALLS WAITING

PostPosted: Fri Nov 27, 2015 5:18 pm
by praveenj79
Thanks my friend I know this was due to agents as you have found it put it in asterisk bug tracker or Vicidialnow bug tracker that will help support to fix this issue once for all

Re: NO LIVE CALLS WAITING

PostPosted: Mon Aug 22, 2022 11:28 am
by indrajeetbanerjee
I am also facing exactly same problem in last 3weeks. I am still facing it without any solution. I am using vicibox 7, tried 8, and 10 also. No improvement. Any idea guys?