inbound Problem

All installation and configuration problems and questions

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

inbound Problem

Postby nekder » Fri May 16, 2008 12:48 pm

im trying to make work the inbound calls now, but i can make it work right....

the calls are sent to queue and there are agents wating for calls too, but the call never reach the agent...

i think this can be a regular problem... i hope

this is what i got from the CLI:

-- Executing Ringing("IAX2/vicidialnow-5", "") in new stack
-- Executing Wait("IAX2/vicidialnow-5", "1") in new stack
-- Stopped music on hold on IAX2/vicidialnow-2
-- Executing Answer("IAX2/vicidialnow-5", "") in new stack
-- Executing AGI("IAX2/vicidialnow-5", "agi-VDAD_ALL_inbound.agi|CIDLOOKUPRC-----LB-----INBOUNDCI-----8000-----Closer-----park----------999-----1-----CI01_I") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi
== Spawn extension (default, 8000, 4) exited non-zero on 'IAX2/vicidialnow-2'
-- Executing DeadAGI("IAX2/vicidialnow-2", "agi://127.0.0.1:4577/call_log") in new stack
-- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
-- Executing DeadAGI("IAX2/vicidialnow-2", "agi://127.0.0.1:4577/VD_hangup--HVcauses--PRI-----NODEBUG-----16---------------)") in new stack
-- AGI Script agi://127.0.0.1:4577/VD_hangup--HVcause ... ----------) completed, returning 0
-- Hungup 'IAX2/vicidialnow-2'
-- Started music on hold, class 'default', on channel 'IAX2/vicidialnow-5'
-- Stopped music on hold on IAX2/vicidialnow-5


thanks for all
regards.
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby mflorell » Fri May 16, 2008 4:21 pm

astGUIclient version?

please post some output from the agiout logfile for the agi-VDAD_ALL_inbound process after setting AGI Output to BOTH on the server.
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby nekder » Mon May 19, 2008 9:11 am

astguiclient version 2.0.4


how do i set AGI Output to both??

anyway, this is the output for /var/log/astguiclient/agiout.2008-05-19

2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|Perl Environment Dump:
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|0|CIDLOOKUPRC-----LB-----INBOUNDCI-----8000-----Closer-----park----------999----$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- accountcode =
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callerid = agente01
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- calleridname = agente01
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callington = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- channel = SIP/agente01-0985aeb8
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- context = default
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- dnid = 8000
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- extension = 8000
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- language = en
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- priority = 4
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- type = SIP
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1211205746.4
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|AGI Variables: |1211205746.4|SIP/agente01-0985aeb8|8000|SIP|Closer|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |INBOUNDCI|Closer-8000|2008-05-19 10:02:27
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list search |01|SELECT lead_id from vicidial_list where phone_numb$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list insert |126|INSERT INTO vicidial_list (entry_date,modify_date$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|callerID changed: Y0519100227000000126
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls (server_ip,campaign_id,status,lead_id,uniqueid,$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,stat$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDCL : |126|insert to vicidial_closer_log
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id $
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', calle$
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby mflorell » Mon May 19, 2008 9:25 am

The output looks chopped off, can you post everything without chomping the end of lines?
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby nekder » Mon May 19, 2008 10:36 am

something like this??
this is the log for today...

this is what you mean with chopped off?
i hope this can help...



2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|Perl Environment Dump:
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|0|CIDLOOKUPRC-----LB-----INBOUNDCI-----8000-----Closer-----park----------999-----1-----CI01_I
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- accountcode =
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callerid = agente01
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- calleridname = agente01
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- callington = 0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- channel = SIP/agente01-0985aeb8
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- context = default
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- dnid = 8000
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- extension = 8000
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- language = en
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- priority = 4
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- type = SIP
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1211205746.4
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|AGI Variables: |1211205746.4|SIP/agente01-0985aeb8|8000|SIP|Closer|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |INBOUNDCI|Closer-8000|2008-05-19 10:02:27
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list search |01|SELECT lead_id from vicidial_list where phone_number='01' order by modify_date limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list insert |126|INSERT INTO vicidial_list (entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,called_since_last_reset,phone_code,phone_number,security_phrase,called_count,gmt_offset_now,comments) values('2008-05-19 10:02:27','20080519100227','INBND','8000','8000','VDCL','999','Y','1','01','INBOUNDCI','1','-5.00','agente01');|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|126|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|callerID changed: Y0519100227000000126
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls (server_ip,campaign_id,status,lead_id,uniqueid,callerid,channel,phone_code,phone_number,call_time,call_type,stage) values('192.168.0.14','INBOUNDCI','LIVE','126','1211205746.4','Y0519100227000000126','SIP/agente01-0985aeb8','1','01','2008-05-19 10:02:27','IN','LIVE-0')|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('126','INBOUNDCI','2008-05-19 10:02:27','1211205747','QUEUE','1','01','VDCL','N')|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDCL : |126|insert to vicidial_closer_log
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|3|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|CHANNEL SIP/agente01-0985aeb8 DOWN 0 360|4 CHECKING AGAIN
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|4|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|6|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|7|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|8|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|9|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|10|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|11|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|12|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|13|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|14|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|15|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|16|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|17|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|18|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|19|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|20|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|21|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|22|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|23|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|24|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|26|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|27|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|28|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|29|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|30|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|31|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|32|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|33|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|34|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|35|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|36|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|37|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|38|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|39|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|40|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|41|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|42|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|43|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|44|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|45|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|46|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|47|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|48|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|49|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|50|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|51|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|52|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|53|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|54|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|55|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|56|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|57|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|58|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|59|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205746.4', channel='SIP/agente01-0985aeb8', callerid='Y0519100227000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100222' order by last_call_finish limit 1;|
2008-05-19 10:02:27|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|Perl Environment Dump:
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|0|CIDLOOKUPRC-----LB-----INBOUNDCI-----8000-----Closer-----park----------999-----1-----CI01_I
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- accountcode =
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callerid = agente01
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- calleridname = agente01
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- callington = 0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- channel = SIP/agente01-0985aeb8
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- context = default
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- dnid = 8000
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- extension = 8000
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- language = en
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- priority = 4
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- type = SIP
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1211205821.5
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|AGI Variables: |1211205821.5|SIP/agente01-0985aeb8|8000|SIP|Closer|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |INBOUNDCI|Closer-8000|2008-05-19 10:03:43
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list search |01|SELECT lead_id from vicidial_list where phone_number='01' order by modify_date limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list found |126|SELECT lead_id from vicidial_list where phone_number='01' order by modify_date limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|126|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|callerID changed: Y0519100343000000126
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls (server_ip,campaign_id,status,lead_id,uniqueid,callerid,channel,phone_code,phone_number,call_time,call_type,stage) values('192.168.0.14','INBOUNDCI','LIVE','126','1211205821.5','Y0519100343000000126','SIP/agente01-0985aeb8','1','01','2008-05-19 10:03:43','IN','LIVE-0')|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('126','INBOUNDCI','2008-05-19 10:03:43','1211205823','QUEUE','1','01','VDCL','N')|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDCL : |126|insert to vicidial_closer_log
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.75|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.25|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_call_finish limit 1;|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:03:43" and lead_id != '126';|
2008-05-19 10:03:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.5|1||update of vla table: INBOUNDCI|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='126',uniqueid='1211205821.5', channel='SIP/agente01-0985aeb8', callerid='Y0519100343000000126', call_server_ip='192.168.0.14' where status IN('CLOSER','READY') and campaign_id IN() and closer_campaigns LIKE "% INBOUNDCI %" and last_update_time > '20080519100338' order by last_cal
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby mflorell » Mon May 19, 2008 3:26 pm

Looks like the call is going to the INBOUNDCI in-group, but it seems that you don't have any active campaigns that have allow_inbound set to Y.

What version of astGUIclient are you using?

Did you follow the instructions in the manager manual tutorials?
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby nekder » Mon May 19, 2008 4:14 pm

yes i did

the inbound campaign name is "CI01_I"

and i add the following to extensions.conf to receive the calls from out side

exten => 8000,1,Ringing ;llamada sonando
exten => 8000,2,Wait(1) ;esperar 1 seg para transfewrir CID desde PRI
exten => 8000,3,Answer ;Contestar
exten => 8000,4,AGI(agi-VDAD_ALL_inbound.agi,CIDLOOKUPRC-----LB-----INBOUNDCI-----8000-----Closer-----park----------999----------1-----CI01_I)
exten => 8000,5,Hangup

is this ok??

and when i the call comes in, i can hear the message "your call is very important to us, please stay on line a you ll be transfer to the next available agent"

but the agent never receive the call...
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby kissas » Mon May 19, 2008 4:44 pm

i'have a similar problem one time and the problem was the time, check the time under vici admin rigth in the corner, and check with mysql time, and the server time.
kissas
 
Posts: 42
Joined: Thu Apr 24, 2008 10:28 am

Postby nekder » Mon May 19, 2008 5:54 pm

yes

i have that problem too some time ago

but this is diferent i think... the times are synchronized
the three of them...

ill keep cheking for news

thanks kissas
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby mflorell » Mon May 19, 2008 6:08 pm

is allow_inbound set to Y in your campaign?
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Op3r » Tue May 20, 2008 7:01 am

and did you created in groups and have the agent logged in to that ingroup?
Get paid for US outbound Toll Free calls. PM me.
Op3r
 
Posts: 1424
Joined: Wed Jun 07, 2006 7:53 pm
Location: Manila

Postby nekder » Tue May 20, 2008 8:38 am

i cant find the Allow_inbound option...

i only have the "Allowed Inbound Groups" checked with the inbound group that i created...

there is something wrong???
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby nekder » Tue May 20, 2008 8:57 am

from the log i got this query

"SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'INBOUNDCI' and call_time < "2008-05-19 10:02:27" and lead_id != '126';"

take a look at "campaign_id = 'INBOUNDCI'"... but INBOUNDCI is the inbound group, not the inbound campaign...
the campaign name is "CI01_I"

maybe i made a mistake on the extension.conf file:

exten => 8000,1,Ringing ;llamada sonando
exten => 8000,2,Wait(1) ;esperar 1 seg para transfewrir CID desde PRI
exten => 8000,3,Answer ;Contestar
exten => 8000,4,AGI(agi-VDAD_ALL_inbound.agi,CIDLOOKUPRC-----LB-----INBOUNDCI-----8000-----Closer-----park----------999----------1-----CI01_I)
exten => 8000,5,Hangup

PS: i check the data on vicidial_auto_calls but i only have a record from an outbound campaign that seems to be stuck...
Last edited by nekder on Tue May 20, 2008 9:04 am, edited 1 time in total.
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby mflorell » Tue May 20, 2008 8:57 am

"Allow Inbound and Blended:" is the field, and it's higher up on the campaign detail screen. But if you have allowed Inbound Groups, then it is most likely selected.

Can you post the contents of the vicidial_live_agents table from when you are having the inbound calling problem?
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby nekder » Tue May 20, 2008 9:17 am

live_agent_id | user | server_ip | conf_exten | extension | status | lead_id | campaign_id | uniqueid | callerid | channel | random_id | last_call_time | last_update_time

164 | 6666 | 192.168.0.14 | 8600051 | SIP/agente01 | CLOSER | 0 | CI01_I | 0.0000000 | 17972830 | 2008-05-20 10:02:56 | 2008-05-20 10:06:36





last_call_finish | closer_campaigns | call_server_ip | user_level |comments | campaign_weight | calls_today

2008-05-20 10:02:56 | INBOUNDCI - | NULL | 9 | | 0 | 0



PS: why i can not see the "allow inbound and blended" field on the campaign settings?? there is something else wrong going on???
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby nekder » Tue May 20, 2008 10:09 am

i have to delete the stucked call on vicidial_auto_calls, and now i have this...


auto_call_id | server_ip | campaign_id | status lead_id | uniqueid callerid | channel | phone_code | phone_number | call_time | call_type | stage | last_update_time | alt_dial




87 | 192.168.0.14 | INBOUNDCI | LIVE | 127 | 1211295760.2000000 | Y0520110241000000127 | SIP/agente01-097a6d38 | 1 | 01 | 2008-05-20 11:02:41 | IN | LIVE-17 | 2008-05-20 11:03:04 | NONE






the campaign_id = INBOUNDCI (the inbound group id)... and i dont know if it is soposed to be like this...
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby mflorell » Tue May 20, 2008 3:09 pm

can you post the values in your vicidial_campaigns table for this campaign?
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby nekder » Tue May 20, 2008 3:55 pm

campaign_id: CI01_I
campaign_name: CI campana de entrada
active: Y
dial_status_a:
dial_status_b:
dial_status_c:
dial_status_d:
dial_status_e:
lead_order: DOWN
park_ext:
park_file_name:
web_form_address:/web-form/DATOS_CI.php
allow_closers: Y
hopper_level: 5
auto_dial_level: 1
next_agent_call: oldest_call_finish
local_call_time: 24hours
voicemail_ext:
dial_timeout: 60
dial_prefix: X
campaign_cid: 0000000000
campaign_vdad_exten: 8365
campaign_rec_exten: 8365
campaign_recording: ONDEMAND
campaign_rec_filename: CAMPAIGN_AGENT_CUSTPHONE_FULLDATE
campaign_script:
get_call_launch: NONE
am_message_exten:
amd_send_to_vmx: N
xferconf_a_dtmf:
xferconf_a_number:
xferconf_b_dtmf:
xferconf_b_number:
alt_number_dialing: Y
scheduled_callbacks: Y
lead_filter_id: NONE
drop_call_seconds: 5
safe_harbor_message: N
safe_harbor_exten: 8307
display_dialable_count: Y
wrapup_seconds: 5
wrapup_message: Wrapup Call
closer_campaigns: INBOUNDCI -
use_internal_dnc: Y
allcalls_delay: 0
omit_phone_code: N
dial_method: RATIO
available_only_ratio_tally: N
adaptive_dropped_percentage: 3
adaptive_maximum_level: 3.0
adaptive_latest_server_time: 2100
adaptive_intensity: 0
adaptive_dl_diff_target: 0
concurrent_transfers: AUTO
auto_alt_dial: NONE
auto_alt_dial_statuses: B N NA DC -
agent_pause_codes_active: Y
campaign_description: campana de entrada
campaign_changedate: 2008-05-20 11:44:29
campaign_stats_refresh: N
campaign_logindate: 2008-05-20 11:44:59
dial_statuses: NEW -
disable_alter_custdata: N
no_hopper_leads_logins: N
list_order_mix: DISABLED
campaign_allow_inbound: N
manual_dial_list_id: NULL
default_xfer_group: ---NONE---
xfer_groups: NULL






PS: i dont understand why campaign_allow_inbound is set to N, i cant find that setting on the campaign detail view... whats wrong??
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby nekder » Tue May 20, 2008 4:11 pm

i change campaign_allow_inbound to yes from de data base and a make it work... but the call is hanged up inmediatly... ill try to figure it out.. but anyway

i still dont understand why this setting is missing
?¿?¿

please help me :S:s
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby nekder » Tue May 20, 2008 4:20 pm

this is the error that a got from CLI now that i can receive inbound calls


Verbosity is at least 3
-- Executing Ringing("SIP/agente01-097bc0c0", "") in new stack
-- Executing Wait("SIP/agente01-097bc0c0", "1") in new stack
-- Executing Answer("SIP/agente01-097bc0c0", "") in new stack
-- Executing AGI("SIP/agente01-097bc0c0", "agi-VDAD_ALL_inbound.agi|CIDLOOKUPRC-----LB-----INBOUNDCI-----8000-----Closer-----park----------999-----1-----TEST_B") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
May 20 17:17:18 NOTICE[27863]: chan_local.c:526 local_alloc: No such extension/context 192*168*000*014*78600051@default creating local channel
May 20 17:17:18 NOTICE[27863]: channel.c:2514 __ast_request_and_dial: Unable to request channel Local/192*168*000*014*78600051@default
-- AGI Script agi-VDAD_ALL_inbound.agi completed, returning 0
May 20 17:17:20 WARNING[27851]: pbx.c:2377 __ast_pbx_run: Channel 'SIP/agente01-097bc0c0' sent into invalid extension '192*168*000*014*8600051' in context 'default', but no invalid handler
-- Executing DeadAGI("SIP/agente01-097bc0c0", "agi://127.0.0.1:4577/call_log") in new stack
-- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
-- Executing DeadAGI("SIP/agente01-097bc0c0", "agi://127.0.0.1:4577/VD_hangup--HVcauses--PRI-----NODEBUG-----0---------------)") in new stack
-- AGI Script agi://127.0.0.1:4577/VD_hangup--HVcause ... ----------) completed, returning 0
== Manager 'sendcron' logged off from 127.0.0.1


the call is hunged up...
now i have two problems... omg
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby mflorell » Tue May 20, 2008 6:13 pm

Looks like you are getting closer, but during setup you did not change 010*010*010*015 to 192*168*000*014 in your extensions.conf.
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby nekder » Wed May 21, 2008 11:15 am

could you please explain me what do mean with that... i try to find those numbers on my extension.conf file, but they seem to be missed...






but even if i can solve the second problem, i will still not be able to set the "allow inbound" option from the campaign settings...

i can not set this option to "yes" from de data base table for ever... there must be something else going on...
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby nekder » Thu May 22, 2008 9:53 am

now is working

i have to add

exten => _192*168*000*014*8600XXX,1,Goto(default,${EXTEN:16},1)
exten => _192*168*000*014*8600XXX*.,1,Goto(default,${EXTEN:16},1)
exten => _8600XXX*.,1,AGI(agi-VDADfixCXFER.agi)

to extension.conf

it works, but there are too much thing that i dont understand

1.- why i have to change the "campaign_allow_inbound" option from the data base, and i couldn´t set this from "vicidial/admin.php"
2.- what is the purpose for agi-VDADfixCXFER.agi? and why i have to change the IP 192*168*000*014* manualy?.
3.-If i change the server ip, do i have to change the IP all over again?

i think that i have too much installation problems and i can not leave things working the way they are.

i will apreciate any comments.

thanks for the help.
nekder
 
Posts: 55
Joined: Mon Jan 21, 2008 2:59 pm

Postby pylinuxian » Thu May 22, 2008 3:34 pm

All these steps are mentioned in the documentation that comes with vicidial .. . you even get a reminder after the install to NOT FORGET to add those lines to your extentions.conf file.
Another thing is that if you look at other proprietary call center software you will find that the setup is much more difficult than with vicidial & even if you knew how to code you don't have the source code ... let alone this :
==============================
Our users have posted a total of 16233 articles
We have 18618 registered users
==============================
which mean you have 18618 chances someone would answer your question.

Its true, things are a little bit trickier at the start & that's because vicidial have only two ways to install, the slackware tutorial (Matt's from scratch bullet proof step by step one) which IMHO lacks one single thing : THE PACKAGES THAT ARE NEEDED BY VICIDIAL, because it only states (choose everything & hit install). so if you go for your own linux distribution, you may have one missing package & your install doesn't work. then the vicidialnow install which is redhat based, those guys could figure out what are the necessary packages because they are experts in Linux so you can guide yourself by thier install.

But the most important thing you should know is that once you do the right install you are ready to go & you have a professional production system in front of you.

This said, Read more of the docs that came with vicidial ... & remember all problems will be gone if you only do the right install.
pylinuxian
 
Posts: 147
Joined: Tue Feb 26, 2008 2:21 pm

Postby seaq » Sat Jun 07, 2008 9:08 am

And BUY the MANAGER and AGENT Manuals.

About the missing option maybe you didn' t look in detail view?
seaq
 
Posts: 86
Joined: Tue Jul 04, 2006 8:27 pm

Postby Op3r » Sun Jun 08, 2008 3:13 pm

Yeah the detail view and the corresponding ? on each of the field?
Get paid for US outbound Toll Free calls. PM me.
Op3r
 
Posts: 1424
Joined: Wed Jun 07, 2006 7:53 pm
Location: Manila

Postby rcphq » Mon Jun 09, 2008 10:22 am

is there a possibility this happens after a upgrade?
after we upgraded some months ago to 2.0.4 we started having similar issues, call gets placed in queue, agent goes free, call doesn't fall in.
rcphq
 
Posts: 42
Joined: Fri Nov 02, 2007 8:54 am


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 229 guests