I have the exact same problem, when the deal hangs up first, vicidial is making calls when there aren't agents availables. These are my settings:
- ASTERISK
asterisk-1.2.4
zaptel-1.2.12
libpri-1.2.4
timer: ztdummy
- VICIDIAL
relase 2.0.3b4.5
.../agc/vicidial.php version: 2.0.122 BUILD: 70226-1252
I applied the cli-concise patch
- AUTODIAL
Dial Method: ADAPT_HARD_LIMIT
Auto Dial Level: 1
Available Only Tally: N
Drop Percentage Limit: 1%
Maximum Adapt Dial Level: 1.2
Latest Server Time: 2100
Adapt Intensity Modifier: 0 - Balanced
Dial Level Difference Target: 0 --- 0 Balanced
Concurrent Transfers: AUTO
The Asterisk CLI ouputs of "show channels concise" are:
1. When is ok the call
- Code: Select all
IAX2/64.61.93.109:4569-1!default!8600051!1!Up!MeetMe!8600051!!!3!6!(None)
Zap/pseudo-1536364337!default!s!1!Rsrvd!(None)!!!!3!!(None)
SIP/agt300-0079c050!default!8600051!1!Up!MeetMe!8600051!!!3!1992!(None)
2. When the vicidial calls another phone number when there aren't availables agents
- Code: Select all
IAX2/64.61.93.109:4569-6!!s!1!Ringing!AppDial!(Outgoing Line)!8002401109!!3!!(None)
Local/38414797562574@default-85a4,2!default!38414797562574!2!Ring!Dial!IAX2/user:pass@64.61.93.109:4569/14797562574|55|o!8002401109!!3!5!(None)
Local/38414797562574@default-85a4,1!default!s!1!Down!(None)!!8002401109!!3!!(None)
Zap/pseudo-1536364337!default!s!1!Rsrvd!(None)!!!!3!!(None)
SIP/agt300-0079c050!default!8600051!1!Up!MeetMe!8600051!!!3!2210!(None)
And the agiout file when this happen is:
- Code: Select all
2007-03-05 18:09:42|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:09:42|agi-VDADtransfer.agi|0|8365
2007-03-05 18:09:42|agi-VDADtransfer.agi|callerID changed: V0305180925000000004
2007-03-05 18:09:42|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callerid = 8002401109
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- calleridname = V0305180925000000004
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- channel = Local/38414797562574@default-85a4,1
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- priority = 2
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- type = Local
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- uniqueid = 1173132565.75
2007-03-05 18:09:42|agi-VDADtransfer.agi|AGI Variables: |1173132565.75|Local/38414797562574@default-85a4,1|8365|Local|V0305180925000000004|V0305180925000000004|2|
2007-03-05 18:09:42|agi-VDADtransfer.agi|+++++ VDAD START : |4|2007-03-05 18:09:42|1.2.14|2|
2007-03-05 18:09:42|agi-VDADtransfer.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2
2007-03-05 18:09:43|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:09:43|agi-VDADtransfer.agi|0|8365
2007-03-05 18:09:43|agi-VDADtransfer.agi|callerID changed: V0305180925000000004
2007-03-05 18:09:43|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callerid = unknown
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- calleridname = V0305180925000000004
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- channel = IAX2/64.61.93.109:4569-6
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- priority = 3
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- type = IAX2
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- uniqueid = 1173132565.75
2007-03-05 18:09:43|agi-VDADtransfer.agi|AGI Variables: |1173132565.75|IAX2/64.61.93.109:4569-6|8365|IAX2|V0305180925000000004|V0305180925000000004|3|
2007-03-05 18:09:43|agi-VDADtransfer.agi|+++++ VDAD START : |4|2007-03-05 18:09:43|1.2.14|3|
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where callerid='V0305180925000000004';|
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where callerid='V0305180925000000004' and status IN('LIVE','XFER');|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD : |1|update of vac table: V0305180925000000004
|UPDATE vicidial_auto_calls set uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6',status='LIVE',stage='LIVE-0' where callerid='V0305180925000000004' order by call_time desc limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('1173132565.75','4','AGENTES','2007-03-05 18:09:43','1173132583','QUEUE','1','4797562574','VDAD','N')|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD : |4|4|insert to vicidial_log: 1173132565.75
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where server_ip='192.168.2.6' and campaign_id = 'AGENTES' and last_update_time > '20070305180938';|
2007-03-05 18:09:43|agi-VDADtransfer.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:48|agi-VDADtransfer.agi||SELECT voicemail_ext FROM vicidial_campaigns where campaign_id = 'AGENTES' limit 1;|
2007-03-05 18:09:48|agi-VDADtransfer.agi|-- VDAD call_hungup timout: |VH0305180948||IAX2/64.61.93.109:4569-6|insert to vicidial_manager
2007-03-05 18:09:48|agi-VDADtransfer.agi|-- VDAD vac record deleted: |1|AGENTES|
2007-03-05 18:09:48|agi-VDADtransfer.agi||UPDATE vicidial_log set status='DROP',end_epoch='1173132588',length_in_sec='5' where uniqueid = '1173132565.75';|
2007-03-05 18:09:48|agi-VDADtransfer.agi|-- VDAD vicidial_log update: |1|1173132565.75
2007-03-05 18:09:48|agi-VDADtransfer.agi||UPDATE vicidial_list set status='DROP' where lead_id = '4';|
2007-03-05 18:09:48|agi-VDADtransfer.agi|-- VDAD vicidial_list update: |1|4
2007-03-05 18:09:48|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:09:48|agi-VDADtransfer.agi|0|8365
2007-03-05 18:09:48|agi-VDADtransfer.agi|callerID changed: V0305180925000000004
2007-03-05 18:09:48|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callerid = unknown
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- calleridname = V0305180925000000004
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- channel = IAX2/64.61.93.109:4569-6
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- priority = 4
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- type = IAX2
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- uniqueid = 1173132565.75
2007-03-05 18:09:48|agi-VDADtransfer.agi|AGI Variables: |1173132565.75|IAX2/64.61.93.109:4569-6|8365|IAX2|V0305180925000000004|V0305180925000000004|4|
2007-03-05 18:09:48|agi-VDADtransfer.agi|+++++ VDAD START : |4|2007-03-05 18:09:48|1.2.14|4|
2007-03-05 18:09:48|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where callerid='V0305180925000000004';|
2007-03-05 18:09:48|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where callerid='V0305180925000000004' and status IN('LIVE','XFER');|
2007-03-05 18:09:48|agi-VDADtransfer.agi|-- VDAD : |0E0|update of vac table: V0305180925000000004
|UPDATE vicidial_auto_calls set uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6',status='LIVE',stage='LIVE-0' where callerid='V0305180925000000004' order by call_time desc limit 1;|
2007-03-05 18:09:48|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-05 18:09:48|agi-VDADtransfer.agi|WWWWWWWW VDAD XFER WAIT: |0||IAX2/64.61.93.109:4569-6|V0305180925000000004|1173132565.75|
2007-03-05 18:14:05|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:14:05|agi-VDADtransfer.agi|0|8365
2007-03-05 18:14:05|agi-VDADtransfer.agi|callerID changed: V0305181342000000009
2007-03-05 18:14:05|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callerid = 8002401109
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- calleridname = V0305181342000000009
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- channel = Local/38414797708939@default-31f1,1
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- priority = 2
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- type = Local
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- uniqueid = 1173132822.90
2007-03-05 18:14:05|agi-VDADtransfer.agi|AGI Variables: |1173132822.90|Local/38414797708939@default-31f1,1|8365|Local|V0305181342000000009|V0305181342000000009|2|
2007-03-05 18:14:05|agi-VDADtransfer.agi|+++++ VDAD START : |9|2007-03-05 18:14:05|1.2.14|2|
2007-03-05 18:14:05|agi-VDADtransfer.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2
2007-03-05 18:14:05|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:14:05|agi-VDADtransfer.agi|0|8365
2007-03-05 18:14:05|agi-VDADtransfer.agi|callerID changed: V0305181342000000009
2007-03-05 18:14:05|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callerid = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- calleridname = V0305181342000000009
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- channel = IAX2/64.61.93.109:4569-4
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- priority = 3
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- type = IAX2
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- uniqueid = 1173132822.90
2007-03-05 18:14:05|agi-VDADtransfer.agi|AGI Variables: |1173132822.90|IAX2/64.61.93.109:4569-4|8365|IAX2|V0305181342000000009|V0305181342000000009|3|
2007-03-05 18:14:05|agi-VDADtransfer.agi|+++++ VDAD START : |9|2007-03-05 18:14:05|1.2.14|3|
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where callerid='V0305181342000000009';|
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where callerid='V0305181342000000009' and status IN('LIVE','XFER');|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD : |1|update of vac table: V0305181342000000009
|UPDATE vicidial_auto_calls set uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4',status='LIVE',stage='LIVE-0' where callerid='V0305181342000000009' order by call_time desc limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('1173132822.90','9','AGENTES','2007-03-05 18:14:05','1173132845','QUEUE','1','4797708939','VDAD','N')|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD : |9|9|insert to vicidial_log: 1173132822.90
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where server_ip='192.168.2.6' and campaign_id = 'AGENTES' and last_update_time > '20070305181400';|
2007-03-05 18:14:05|agi-VDADtransfer.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:10|agi-VDADtransfer.agi||SELECT voicemail_ext FROM vicidial_campaigns where campaign_id = 'AGENTES' limit 1;|
2007-03-05 18:14:10|agi-VDADtransfer.agi|-- VDAD call_hungup timout: |VH0305181410||IAX2/64.61.93.109:4569-4|insert to vicidial_manager
2007-03-05 18:14:10|agi-VDADtransfer.agi|-- VDAD vac record deleted: |1|AGENTES|
2007-03-05 18:14:10|agi-VDADtransfer.agi||UPDATE vicidial_log set status='DROP',end_epoch='1173132850',length_in_sec='5' where uniqueid = '1173132822.90';|
2007-03-05 18:14:10|agi-VDADtransfer.agi|-- VDAD vicidial_log update: |1|1173132822.90
2007-03-05 18:14:10|agi-VDADtransfer.agi||UPDATE vicidial_list set status='DROP' where lead_id = '9';|
2007-03-05 18:14:10|agi-VDADtransfer.agi|-- VDAD vicidial_list update: |1|9
2007-03-05 18:14:10|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:14:10|agi-VDADtransfer.agi|0|8365
2007-03-05 18:14:10|agi-VDADtransfer.agi|callerID changed: V0305181342000000009
2007-03-05 18:14:10|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callerid = unknown
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- calleridname = V0305181342000000009
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- channel = IAX2/64.61.93.109:4569-4
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- priority = 4
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- type = IAX2
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- uniqueid = 1173132822.90
2007-03-05 18:14:10|agi-VDADtransfer.agi|AGI Variables: |1173132822.90|IAX2/64.61.93.109:4569-4|8365|IAX2|V0305181342000000009|V0305181342000000009|4|
2007-03-05 18:14:10|agi-VDADtransfer.agi|+++++ VDAD START : |9|2007-03-05 18:14:10|1.2.14|4|
2007-03-05 18:14:10|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where callerid='V0305181342000000009';|
2007-03-05 18:14:10|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where callerid='V0305181342000000009' and status IN('LIVE','XFER');|
2007-03-05 18:14:10|agi-VDADtransfer.agi|-- VDAD : |0E0|update of vac table: V0305181342000000009
|UPDATE vicidial_auto_calls set uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4',status='LIVE',stage='LIVE-0' where callerid='V0305181342000000009' order by call_time desc limit 1;|
2007-03-05 18:14:10|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-05 18:14:10|agi-VDADtransfer.agi|WWWWWWWW VDAD XFER WAIT: |0||IAX2/64.61.93.109:4569-4|V0305181342000000009|1173132822.90|
Please help, I am having a lot of DROP calls