Call disconnects automatically

All installation and configuration problems and questions

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

Call disconnects automatically

Postby anoop.kr » Tue Mar 28, 2023 6:40 am

Hi all,
While On-hook agent is enabled, and an incoming call comes, the softphone rings. When we attend the call, it disconnects the calls immediately at the same time agent screen shows one call in queue. After a short while the call comes again and repeats the same process. Everything OK when On-hook is disabled. Please help, will be grateful.
Regards
Anoop.
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby mflorell » Tue Mar 28, 2023 6:52 am

What is the In-Group and/or Campaign "On-Hook CID" setting set to?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call disconnects automatically

Postby anoop.kr » Tue Mar 28, 2023 10:57 pm

Hi thanks for the reply
1. In-Group On-Hook CID = 'CUSTOMER_PHONE_RINGAGENT'
2. Campaign On-Hook CID = I dont see an option for On-Hook CID, but,
CID Group = Diabled
CID group failover = Disabled
Manual Dial CID = Campaign
Extension append CID = N
Thanks and regards
anoop
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby mflorell » Wed Mar 29, 2023 6:42 am

Please indicate the version of Asterisk you are using.

Also indicate the version and build of admin.php.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call disconnects automatically

Postby anoop.kr » Wed Mar 29, 2023 10:17 am

Hi,
Im out of office now, but I can say the asterisk is 16.xx, and the installation is from the latest ISO and zypper update is done, so everything is latest as per the repo.

Regards.
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby anoop.kr » Wed Mar 29, 2023 11:08 pm

Hi,
The asterisk is : 16.30.0-vici
VERSION: 2.14-878a
BUILD: 230312-2212

Regards
anoop
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby mflorell » Thu Mar 30, 2023 6:54 am

Please set the Server's AGI Output to BOTH and post the screenlog.0 logfile output of the call being routed to the agent and hanging up.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Call disconnects automatically

Postby anoop.kr » Fri Mar 31, 2023 11:49 pm

Hi,
Screenlog is attached. It says "No available balance agent found", we have tested it with two agents logged in.
******************************************************************************************************************************************************************
[Apr 1 09:18:34] ERROR[14952][C-00000019]: netsock2.c:303 ast_sockaddr_resolve: getaddrinfo("vicibox-oc", "(null)", ...): Name or service not known
[Apr 1 09:18:34] WARNING[14952][C-00000019]: acl.c:890 resolve_first: Unable to lookup 'vicibox-oc'
[Apr 1 09:18:34]  == Using SIP RTP CoS mark 5
[Apr 1 09:18:34]  > 0x7ff43c02b420 -- Strict RTP learning after remote address set to: 10.41.12.205:32596
[Apr 1 09:18:34]  -- Executing [88000@trunkinbound:1] AGI("SIP/occtrunk-00000012", "agi-DID_route.agi") in new stack
[Apr 1 09:18:34]  -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-DID_route.agi
2023-04-01 09:18:34|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1680320914.35',channel='SIP/occtrunk-00000012',server_ip='10.42.40.63',caller_id_number='08130352804',caller_id_name='08130352804',extension='88000',call_date='2023-04-01 09:18:34',did_id='2',did_route='IN_GROUP';|
2023-04-01 09:18:34|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1680320914.35',channel='SIP/occtrunk-00000012',server_ip='10.42.40.63',caller_id_number='08130352804',caller_id_name='08130352804',extension='88000',call_date='2023-04-01 09:18:34',did_id='2',did_route='IN_GROUP';|
2023-04-01 09:18:34|agi-DID_route.agi|-- CALL LOG : |1|INSERT INTO call_log SET uniqueid='1680320914.35', channel='SIP/occtrunk-00000012', channel_group='DID_INBOUND', server_ip='10.42.40.63', type='SIP', extension='88000', number_dialed='88000', caller_code='08130352804', start_time='2023-04-01 09:18:34', start_epoch='1680320914';|
2023-04-01 09:18:34|agi-DID_route.agi|exiting the DID app, transferring call to 99909*2***DID @ default
[Apr 1 09:18:34]  -- <SIP/occtrunk-00000012>AGI Script agi-DID_route.agi completed, returning 0
[Apr 1 09:18:34]  -- Executing [99909*2***DID@default:1] Answer("SIP/occtrunk-00000012", "") in new stack
[Apr 1 09:18:34]  > 0x7ff43c02b420 -- Strict RTP switching to RTP target address 10.41.12.205:32596 as source
[Apr 1 09:18:34]  -- Executing [99909*2***DID@default:2] AGI("SIP/occtrunk-00000012", "agi-VDAD_ALL_inbound.agi") in new stack
[Apr 1 09:18:34]  -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- accountcode =
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- callerid = 08130352804
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- calleridname = 08130352804
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- callington = 0
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- channel = SIP/occtrunk-00000012
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- context = default
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- dnid = 88000
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- extension = 99909*2***DID
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- language = en
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- priority = 2
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- threadid = 140690395313920
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- type = SIP
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1680320914.35
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi| -- version = 16.30.0-vici
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|AGI Variables: |1680320914.35|SIP/occtrunk-00000012|99909*2***DID|SIP|08130352804|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |OCCINGRP|08130352804-88000|2023-04-01 09:18:34
[Apr 1 09:18:34] WARNING[10993][C-00000019]: file.c:611 filehelper: File /usr/share/asterisk/sounds/sip-silence.gsm detected to have zero size.
[Apr 1 09:18:34]  -- <SIP/occtrunk-00000012> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[Apr 1 09:18:34] WARNING[10993][C-00000019]: file.c:611 filehelper: File /usr/share/asterisk/sounds/sip-silence.gsm detected to have zero size.
[Apr 1 09:18:34]  -- <SIP/occtrunk-00000012> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en')
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|135|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|callerID changed: "Y4010918340000000135 <08130352804>"
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|0|SELECT auto_call_id from vicidial_auto_calls where uniqueid='1680320914.35' and server_ip='10.42.40.63';|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls SET server_ip='10.42.40.63', campaign_id='OCCINGRP', status='LIVE', lead_id='135', uniqueid='1680320914.35', callerid='Y4010918340000000135', channel='SIP/occtrunk-00000012', phone_code='1', phone_number='08130352804', call_time='2023-04-01 09:18:34', call_type='IN', stage='LIVE-0', queue_priority='0' ;|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|1|SELECT count(*) from vicidial_auto_calls where status = 'LIVE' and campaign_id='OCCINGRP';|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|1|UPDATE vicidial_auto_calls SET queue_position='1' WHERE auto_call_id='11';|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log SET lead_id='135', campaign_id='OCCINGRP', call_date='2023-04-01 09:18:34', start_epoch='1680320914', status='QUEUE', phone_code='1', phone_number='08130352804', user='VDCL', processed='N', xfercallid='0', uniqueid='1680320914.35', queue_position='1',called_count='1',list_id='999' ;|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|-- VDCL : |135|0|99|insert to vicidial_closer_log
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|-- ENTER QUEUE VLE insert: |1|
|INSERT INTO vicidial_log_extended set uniqueid='1680320914.35',server_ip='10.42.40.63',call_date='2023-04-01 09:18:34',lead_id = '135',caller_code='Y4010918340000000135',custom_call_id='' ON DUPLICATE KEY UPDATE start_url_processed='N',dispo_url_processed='N',multi_alt_processed='N',noanswer_processed='N',call_date='2023-04-01 09:18:34',caller_code='Y4010918340000000135',custom_call_id='';|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|-- ENTER QUEUE VICC insert: |1|
|INSERT INTO vicidial_inbound_caller_codes set uniqueid='1680320914.35',server_ip='10.42.40.63',call_date='2023-04-01 09:18:34',lead_id = '135',caller_code='Y4010918340000000135',prev_caller_code='08130352804',group_id='OCCINGRP';|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|DID IVR time logged: 2023-04-01 09:18:34|1680320914|1|UPDATE call_log set end_time='2023-04-01 09:18:34',end_epoch='1680320914',length_in_sec=0,length_in_min=' 0.00',extension='Y4010918340000000135' where uniqueid='1680320914.35'|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|5001|0|SELECT vicidial_live_agents.conf_exten,vicidial_live_agents.user,vicidial_live_agents.extension,vicidial_live_agents.server_ip,vicidial_live_inbound_agents.group_weight,ra_user,vicidial_live_agents.campaign_id,on_hook_agent,on_hook_ring_time,vicidial_live_inbound_agents.group_grade,vicidial_live_agents.campaign_grade from vicidial_live_agents, vicidial_live_inbound_agents WHERE vicidial_live_agents.user=vicidial_live_inbound_agents.user and status IN('CLOSER','READY') and lead_id<1 and vicidial_live_inbound_agents.group_id='OCCINGRP' and last_update_time > '20230401091827' and vicidial_live_agents.user NOT IN('','') and ring_callerid='' order by vicidial_live_inbound_agents.calls_today,vicidial_live_inbound_agents.last_call_finish limit 1;|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|ON-HOOK-AGENT UPDATE: |UPDATE vicidial_live_agents set ring_callerid='Y4010918340000000135' where user='5001';|1|Y|0
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|RING-AGENT CALL SENT: |OCCINGRP08130352804|138331*11*Y4010918340000000135*5001*88001|0|15|CUSTOMER_PHONE_INGROUP|| SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|50|60|0|0||0|update of vla table: OCCINGRP|
|INSERT INTO vicidial_manager values('','','2023-04-01 09:18:34','NEW','N','10.42.40.63','','Originate','OCCINGRP08130352804','Exten: 138331*11*Y4010918340000000135*5001*88001','Context: default','Channel: Local/010*042*040*063*88001@default','Priority: 1','Callerid: OCCINGRP08130352804','Timeout: 14000','','','','')|
2023-04-01 09:18:34|09:18:34|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
[Apr 1 09:18:35]  -- Called 010*042*040*063*88001@default
[Apr 1 09:18:35]  -- Executing [010*042*040*063*88001@default:1] Goto("Local/010*042*040*063*88001@default-00000008;2", "default,88001,1") in new stack
[Apr 1 09:18:35]  -- Goto (default,88001,1)
[Apr 1 09:18:35]  -- Executing [88001@default:1] Dial("Local/010*042*040*063*88001@default-00000008;2", "SIP/88001,60,") in new stack
[Apr 1 09:18:35] ERROR[11002][C-0000001a]: netsock2.c:303 ast_sockaddr_resolve: getaddrinfo("vicibox-oc", "(null)", ...): Name or service not known
[Apr 1 09:18:35] WARNING[11002][C-0000001a]: acl.c:890 resolve_first: Unable to lookup 'vicibox-oc'
[Apr 1 09:18:35]  == Using SIP RTP CoS mark 5
[Apr 1 09:18:35]  -- Called SIP/88001
[Apr 1 09:18:35]  -- SIP/88001-00000013 is ringing
[Apr 1 09:18:35]  -- Dial Tiemout Reset on channel SIP/88001-00000013 due to RINGING message
[Apr 1 09:18:35]  -- Local/010*042*040*063*88001@default-00000008;1 is ringing
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 14.75|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.25|51|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 14.5|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.5|52|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 14.25|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.75|53|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 14|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1|54|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:35|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 13.75|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.25|55|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 13.5|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.5|56|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 13.25|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.75|57|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 12.25|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2|58|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:36|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
[Apr 1 09:18:36]  -- Started music on hold, class 'default', on channel 'SIP/occtrunk-00000012'
[Apr 1 09:18:36] WARNING[10993][C-00000019]: file.c:611 filehelper: File /var/lib/asterisk/default/0000_sip-silence.gsm detected to have zero size.
[Apr 1 09:18:36] WARNING[10993][C-00000019]: file.c:611 filehelper: File /var/lib/asterisk/default/0001_conf.gsm detected to have zero size.
[Apr 1 09:18:36]  -- Stopped music on hold on SIP/occtrunk-00000012
[Apr 1 09:18:37]  > 0x7ff47c01aa50 -- Strict RTP learning after remote address set to: 10.40.41.193:4012
[Apr 1 09:18:37]  -- SIP/88001-00000013 answered Local/010*042*040*063*88001@default-00000008;2
[Apr 1 09:18:37]  -- Local/010*042*040*063*88001@default-00000008;1 answered
[Apr 1 09:18:37]  -- Executing [138331*11*Y4010918340000000135*5001*88001@default:1] AGI("Local/010*042*040*063*88001@default-00000008;1", "agi-VDAD_local_optimize.agi,OCCINGRP08130352804") in new stack
[Apr 1 09:18:37]  -- Launched AGI Script /usr/share/asterisk/agi-bin/agi-VDAD_local_optimize.agi
[Apr 1 09:18:37]  -- Channel SIP/88001-00000013 joined 'simple_bridge' basic-bridge <23608dce-015f-48bf-a6c5-ed007eb12f57>
[Apr 1 09:18:37]  -- Channel Local/010*042*040*063*88001@default-00000008;2 joined 'simple_bridge' basic-bridge <23608dce-015f-48bf-a6c5-ed007eb12f57>
[Apr 1 09:18:37]  > 0x7ff47c01aa50 -- Strict RTP switching to RTP target address 10.40.41.193:4012 as source
1680320917.124228
1|cid_channels_recent_010042040063|SHOW TABLES LIKE "cid_channels_recent_010042040063";
SELECT dest_channel FROM cid_channels_recent_010042040063 where (caller_id_name = 'Haseena' or connected_line_name = 'OCCINGRP08130352804' or caller_id_name = 'OCCINGRP08130352804' or connected_line_name = 'Haseena') and ( linkedid = '1680320915.36' or dest_uniqueid = '1680320915.36' or uniqueid = '1680320915.36') and call_date > '2023-04-01 09:16:37'
DBD::mysql::st execute failed: Incorrect file format 'cid_channels_recent_010042040063' at /usr/share/asterisk/agi-bin/agi-VDAD_local_optimize.agi line 110, <STDIN> line 22.
executing: SELECT dest_channel FROM cid_channels_recent_010042040063 where (caller_id_name = 'Haseena' or connected_line_name = 'OCCINGRP08130352804' or caller_id_name = 'OCCINGRP08130352804' or connected_line_name = 'Haseena') and ( linkedid = '1680320915.36' or dest_uniqueid = '1680320915.36' or uniqueid = '1680320915.36') and call_date > '2023-04-01 09:16:37' Incorrect file format 'cid_channels_recent_010042040063' at /usr/share/asterisk/agi-bin/agi-VDAD_local_optimize.agi line 110, <STDIN> line 22.
[Apr 1 09:18:37]  -- <Local/010*042*040*063*88001@default-00000008;1>AGI Script agi-VDAD_local_optimize.agi completed, returning 0
[Apr 1 09:18:37]  -- Executing [138331*11*Y4010918340000000135*5001*88001@default:2] Wait("Local/010*042*040*063*88001@default-00000008;1", "2") in new stack
2023-04-01 09:18:34|09:18:37|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:37|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:37|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:37|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:37|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:37|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 11.25|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:37|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|3|59|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:37|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2023-04-01 09:18:34|09:18:38|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:38|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:38|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:38|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:38|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:38|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 10.25|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:38|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|4|60|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:38|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
[Apr 1 09:18:39]  > 0x7ff43c02b420 -- Strict RTP learning complete - Locking on source address 10.41.12.205:32596
[Apr 1 09:18:39]  -- Executing [138331*11*Y4010918340000000135*5001*88001@default:3] Hangup("Local/010*042*040*063*88001@default-00000008;1", "") in new stack
[Apr 1 09:18:39]  == Spawn extension (default, 138331*11*Y4010918340000000135*5001*88001, 3) exited non-zero on 'Local/010*042*040*063*88001@default-00000008;1'
[Apr 1 09:18:39] WARNING[11001][C-0000001b]: func_hangupcause.c:138 hangupcause_read: Unable to find information for channel
[Apr 1 09:18:39]  -- Executing [h@default:1] AGI("Local/010*042*040*063*88001@default-00000008;1", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16--------------------)") in new stack
[Apr 1 09:18:39]  -- <Local/010*042*040*063*88001@default-00000008;1>AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ----------) completed, returning 0
[Apr 1 09:18:39]  -- Channel Local/010*042*040*063*88001@default-00000008;2 left 'simple_bridge' basic-bridge <23608dce-015f-48bf-a6c5-ed007eb12f57>
[Apr 1 09:18:39]  -- Channel SIP/88001-00000013 left 'simple_bridge' basic-bridge <23608dce-015f-48bf-a6c5-ed007eb12f57>
[Apr 1 09:18:39]  == Spawn extension (default, 88001, 1) exited non-zero on 'Local/010*042*040*063*88001@default-00000008;2'
[Apr 1 09:18:39]  -- Executing [h@default:1] AGI("Local/010*042*040*063*88001@default-00000008;2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----4-----2-----SIP 200 OK)") in new stack
[Apr 1 09:18:39]  -- <Local/010*042*040*063*88001@default-00000008;2>AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... -2-----SIP 200 OK) completed, returning 0
2023-04-01 09:18:34|09:18:39|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:39|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:39|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:39|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:39|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:39|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 9.25|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:39|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|5|61|60|0|0||0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:39|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2023-04-01 09:18:34|09:18:39|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20230401091848|Y4010918340000000135||
[Apr 1 09:18:39] WARNING[10993][C-00000019]: file.c:611 filehelper: File /usr/share/asterisk/sounds/sip-silence.gsm detected to have zero size.
[Apr 1 09:18:39]  -- <SIP/occtrunk-00000012> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[Apr 1 09:18:39] WARNING[10993][C-00000019]: file.c:611 filehelper: File /usr/share/asterisk/sounds/sip-silence.gsm detected to have zero size.
[Apr 1 09:18:39]  -- <SIP/occtrunk-00000012> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[Apr 1 09:18:39] WARNING[10993][C-00000019]: file.c:611 filehelper: File /usr/share/asterisk/sounds/sip-silence.gsm detected to have zero size.
[Apr 1 09:18:39]  -- <SIP/occtrunk-00000012> Playing 'sip-silence.gsm' (escape_digits=) (sample_offset 0) (language 'en')
[Apr 1 09:18:39] WARNING[10993][C-00000019]: file.c:611 filehelper: File /usr/share/asterisk/sounds/generic_hold.gsm detected to have zero size.
[Apr 1 09:18:39]  -- <SIP/occtrunk-00000012> Playing 'generic_hold.gsm' (escape_digits=) (sample_offset 0) (language 'en')
2023-04-01 09:18:34|09:18:40|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'OCCINGRP' and call_time < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0' and agent_only='';|
2023-04-01 09:18:34|09:18:40|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and group_id='OCCINGRP' and call_date < "2023-04-01 09:18:34" and lead_id != '135' and queue_priority >= '0';|
2023-04-01 09:18:34|09:18:40|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '135' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:40|agi-VDAD_ALL_inbound.agi|AGENTDIRECT calls check: 0|||SELECT agent_only FROM vicidial_auto_calls where status = 'LIVE' and campaign_id LIKE "%AGENTDIRECT%" and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:40|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_inbound_callback_queue where icbq_status IN('LIVE','SENDING') and lead_id != '135' and ( (queue_priority > '0') or (queue_priority = '0' and call_date < "2023-04-01 09:18:34") );|
2023-04-01 09:18:34|09:18:40|agi-VDAD_ALL_inbound.agi|RING-AGENT TIMER: 8.25|15|15 SIP/occtrunk-00000012|Y4010918340000000135
2023-04-01 09:18:34|09:18:40|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|6|0|60|0|0|0|0|update of vla table: OCCINGRP|
|UNLOCK TABLES;|
2023-04-01 09:18:34|09:18:40|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
[Apr 1 09:18:40]  -- Started music on hold, class 'default', on channel 'SIP/occtrunk-00000012'
[Apr 1 09:18:40] WARNING[10993][C-00000019]: file.c:611 filehelper: File /var/lib/asterisk/default/0001_conf.gsm detected to have zero size.
[Apr 1 09:18:40] WARNING[10993][C-00000019]: file.c:611 filehelper: File /var/lib/asterisk/default/0000_sip-silence.gsm detected to have zero size.
[Apr 1 09:18:40]  -- Stopped music on hold on SIP/occtrunk-00000012
[Apr 1 09:18:41]  -- <SIP/occtrunk-00000012>AGI Script agi-VDAD_ALL_inbound.agi completed, returning 4
[Apr 1 09:18:41]  == Spawn extension (default, 99909*2***DID, 2) exited non-zero on 'SIP/occtrunk-00000012'
[Apr 1 09:18:41] WARNING[10993][C-00000019]: func_hangupcause.c:138 hangupcause_read: Unable to find information for channel
[Apr 1 09:18:41]  -- Executing [h@default:1] AGI("SIP/occtrunk-00000012", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------------)") in new stack
[Apr 1 09:18:41]  -- <SIP/occtrunk-00000012>AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ----------) completed, returning 0
*************************************************************************************************************************************************************************************************************************************************************
One more question,
Server Time, PHP Time, DB TIme, should all be the same ? In my case the PHP time is 5:30 Hrs behind the other two, and on top of the admin page PHP time is shown (BTW, Im from India GMT+5:30)
Thanks and regards.
anoop.
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby anoop.kr » Sat Apr 01, 2023 3:11 am

Hi,
In my php.ini file, the timezone is correct.

Regards
anoop
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby jamiemurray » Sat Apr 01, 2023 5:56 am

Set the the ingroup CID to RA_AGENT_PHONE and retest
Skype: live:support_71847 | Tel: (US) +1 646 647 8850 (CA) +1 613 900 6456 (MX) +52 55 9990 3550 (UK) +44 1324 285022 (ES) +34 922 937 384
Managed Hosting - No tech skills required | VoIP Termination & DID numbering | https://jmurraysolutions.com
jamiemurray
 
Posts: 172
Joined: Fri Jan 11, 2013 4:12 pm
Location: Tenerife, Canary Islands

Re: Call disconnects automatically

Postby anoop.kr » Sat Apr 01, 2023 6:13 am

Hei,
Thaks for the reply, I guess you mean to say "On-Hook CID" in INGROUP Settings, if so I did as you advised but the issue persists.

Regards.
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby jamiemurray » Sat Apr 01, 2023 7:46 am

Was this a manual install or via Vicibox?

Going through your screenlog again, I notice there's a db query failing on the pickup of the remote extension where the channels are matched for bridging.

Does the db user defined in /etc/astguiclient.conf have permission to create tables?
Skype: live:support_71847 | Tel: (US) +1 646 647 8850 (CA) +1 613 900 6456 (MX) +52 55 9990 3550 (UK) +44 1324 285022 (ES) +34 922 937 384
Managed Hosting - No tech skills required | VoIP Termination & DID numbering | https://jmurraysolutions.com
jamiemurray
 
Posts: 172
Joined: Fri Jan 11, 2013 4:12 pm
Location: Tenerife, Canary Islands

Re: Call disconnects automatically

Postby anoop.kr » Sat Apr 01, 2023 9:18 am

Hi
Its an installation done from the official iso.
Rest of the details I shall update later as im out of office.
Thanks and regards
Anoop
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby anoop.kr » Mon Apr 03, 2023 6:36 am

HI,
The db user defined is cron.
MariaDB [(none)]> show grants for cron;
+--------------------------------------------------------------------------------------------------------------+
| Grants for cron@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, RELOAD ON *.* TO `cron`@`%` IDENTIFIED BY PASSWORD '*A4B6157319038724E3560894F7F932C8886EBFCF' |
| GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON `asterisk`.* TO `cron`@`%` |
+--------------------------------------------------------------------------------------------------------------+

Regards
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby jamiemurray » Mon Apr 03, 2023 7:25 am

I ran a few tests on a system locally, but I can't replicate your error even with incorrect settings.

Code: Select all
SELECT dest_channel FROM cid_channels_recent_010042040063 where (caller_id_name = 'Haseena' or connected_line_name = 'OCCINGRP08130352804' or caller_id_name = 'OCCINGRP08130352804' or connected_line_name = 'Haseena') and ( linkedid = '1680320915.36' or dest_uniqueid = '1680320915.36' or uniqueid = '1680320915.36') and call_date > '2023-04-01 09:16:37'
DBD::mysql::st execute failed: Incorrect file format 'cid_channels_recent_010042040063' at /usr/share/asterisk/agi-bin/agi-VDAD_local_optimize.agi line 110, <STDIN> line 22.

This is what's failing on the answer of the ring extension.

Basically this part of the code is trying to find the channel the agent is on so it can be put in the conference.
The channel discovery fails and the call therefore drops.

One thing I note here, although it doesn't appear to be the cause, your Onhook CID is not set to RA_AGENT_PHONE, without it the onhook agent wouldn't connect to the conference correctly anyway.

The file format error could be because the table is crashed on the database, you may want to run a check and repair, then:

1. Repeat the call and have the onhook agent answer it.
2. Check screenlog for the line where the DB query fails.
3. Run the query manually on the DB and grab the result/error that appears and put it here.
Skype: live:support_71847 | Tel: (US) +1 646 647 8850 (CA) +1 613 900 6456 (MX) +52 55 9990 3550 (UK) +44 1324 285022 (ES) +34 922 937 384
Managed Hosting - No tech skills required | VoIP Termination & DID numbering | https://jmurraysolutions.com
jamiemurray
 
Posts: 172
Joined: Fri Jan 11, 2013 4:12 pm
Location: Tenerife, Canary Islands

Re: Call disconnects automatically

Postby anoop.kr » Mon Apr 03, 2023 11:11 pm

Dear Jamie Murray,
I am very much indebted to you, as your observation is correct and I followed you, the table was indeed corrupt, I repaired the table (mysql> REPAIR TABLE 'cid_channels_recent_010042040063' USE_FRM) and it is now working.
Again thanks a lot.
Regards from India
Anoop.
anoop.kr
 
Posts: 28
Joined: Tue Mar 07, 2023 6:47 am

Re: Call disconnects automatically

Postby jamiemurray » Tue Apr 04, 2023 4:20 pm

I'm glad for you!

Good on you for posting back to confirm it's resolved :D
Skype: live:support_71847 | Tel: (US) +1 646 647 8850 (CA) +1 613 900 6456 (MX) +52 55 9990 3550 (UK) +44 1324 285022 (ES) +34 922 937 384
Managed Hosting - No tech skills required | VoIP Termination & DID numbering | https://jmurraysolutions.com
jamiemurray
 
Posts: 172
Joined: Fri Jan 11, 2013 4:12 pm
Location: Tenerife, Canary Islands


Return to Support

Who is online

Users browsing this forum: No registered users and 66 guests