Cannot Get "Grab Call In Queue" Working

Posted:
Mon Dec 07, 2009 1:48 am
by benomg
Fantastic job on 2.2 to everyone involved. It has addressed many little issues and has brought the project along way imo.
I'm testing 2.2.0-224, build 91125-0628. I'm trying to get agent grab calls in queue working. Atm when the agent presses "Take Call" they experience about 5 seconds of nothing and the call disappears and the call gets "good bye" in about the same time. Can someone please help? I assume that the feature has worked for others. Has anyone come across this issue?
I have tried INBOUND_MAN, and RATIO, via call menu -> inbound group and straight to inbound group.
The call is picked up fine if agent is already ready or if the agent becomes ready while the call is in queue, just having problems with the "take call" link.
Here's what I can tell you...
The CLI output is:
[Dec 7 17:14:24] -- Executing AGI("IAX2/faktortel-3895", "agi-DID_route.agi") in new stack
[Dec 7 17:14:24] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-DID_route.agi
[Dec 7 17:14:24] -- AGI Script agi-DID_route.agi completed, returning 0
[Dec 7 17:14:24] -- Executing AGI("IAX2/faktortel-3895", "agi-VDAD_inbound_calltime_check.agi|CALLMENU-----YES-----bluedid--------------------") in new stack
[Dec 7 17:14:24] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_inbound_calltime_check.agi
[Dec 7 17:14:24] -- AGI Script agi-VDAD_inbound_calltime_check.agi completed, returning 0
[Dec 7 17:14:24] -- Executing BackGround("IAX2/faktortel-3895", "") in new stack
[Dec 7 17:14:24] -- Executing WaitExten("IAX2/faktortel-3895", "10") in new stack
[Dec 7 17:14:26] == CDR updated on IAX2/faktortel-3895
[Dec 7 17:14:26] -- Executing AGI("IAX2/faktortel-3895", "agi-VDAD_ALL_inbound.agi|CIDLOOKUP-----LB-----customerservice-----bluedid--------------------998-----61-----TESTCAMP") in new stack
[Dec 7 17:14:26] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi
[Dec 7 17:14:28] -- Started music on hold, class 'default', on IAX2/faktortel-3895
[Dec 7 17:14:28] WARNING[18637]: file.c:517 ast_openstream_full: File /var/lib/asterisk/mohmp3/LICENSE-asterisk-moh-opsound-2 does not exist in any format
[Dec 7 17:14:28] WARNING[18637]: res_musiconhold.c:232 ast_moh_files_next: Unable to open file '/var/lib/asterisk/mohmp3/LICENSE-asterisk-moh-opsound-2': No such file or directory
[Dec 7 17:14:28] -- Stopped music on hold on IAX2/faktortel-3895
[Dec 7 17:14:33] -- Started music on hold, class 'default', on IAX2/faktortel-3895
### "Take Call" is clicked
[Dec 7 17:14:42] -- AGI Script agi-VDAD_ALL_inbound.agi completed, returning 0
[Dec 7 17:14:52] -- Timeout on IAX2/faktortel-3895
[Dec 7 17:14:52] == CDR updated on IAX2/faktortel-3895
[Dec 7 17:14:52] -- Executing Playback("IAX2/faktortel-3895", "goodbye") in new stack
[Dec 7 17:14:52] -- Stopped music on hold on IAX2/faktortel-3895
[Dec 7 17:14:52] -- Playing 'goodbye' (language 'en')
[Dec 7 17:14:53] -- Executing Hangup("IAX2/faktortel-3895", "") in new stack
[Dec 7 17:14:53] == Spawn extension (bluedid, t, 2) exited non-zero on 'IAX2/faktortel-3895'
[Dec 7 17:14:53] -- Executing DeadAGI("IAX2/faktortel-3895", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16---------------") in new stack
[Dec 7 17:14:53] -- AGI Script
agi://127.0.0.1:4577/call_log--HVcauses ... ---------- completed, returning 0
[Dec 7 17:14:53] -- Hungup 'IAX2/faktortel-3895'
crd-custom:
""0000000000" <0000000000>","0000000000","1111111111","trunkinbound","IAX2/faktortel-7296","IAX2/faktortel-15862","Dial","IAX2/faktortel/1111111111||tTor","2009-12-07 12:43:19","","2009-12-07 12:43:39","20","0","NO ANSWER","DOCUMENTATION","","1260150199.43",""
"/var/log/asterisk/cdr-custom/Master.csv" 91L, 23105C
Campaign:
campaign_id TESTIN
campaign_name Test Inbound Campaign
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
allow_closers Y
hopper_level 5
auto_dial_level 1
next_agent_call longest_wait_time
local_call_time 24hours
voicemail_ext
dial_timeout 60
dial_prefix 9
campaign_cid 0000000000
campaign_vdad_exten 8368
campaign_rec_exten 8309
campaign_recording ONDEMAND
campaign_rec_filename FULLDATE_CUSTPHONE
campaign_script
get_call_launch NONE
am_message_exten vm-goodbye
amd_send_to_vmx N
xferconf_a_dtmf
xferconf_a_number
xferconf_b_dtmf
xferconf_b_number
alt_number_dialing N
scheduled_callbacks N
lead_filter_id NONE
drop_call_seconds 5
drop_action MESSAGE
safe_harbor_exten 8307
display_dialable_count Y
wrapup_seconds 0
wrapup_message Wrapup Call
closer_campaigns customerservice -
use_internal_dnc N
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 N
campaign_description
campaign_changedate 2009-12-07 16:15:48
campaign_stats_refresh N
campaign_logindate 2009-12-07 16:30:23
dial_statuses NEW -
disable_alter_custdata N
no_hopper_leads_logins Y
list_order_mix DISABLED
campaign_allow_inbound Y
manual_dial_list_id 998
default_xfer_group ---NONE---
xfer_groups
queue_priority 50
drop_inbound_group ---NONE---
qc_enabled N
qc_statuses NULL
qc_lists NULL
qc_shift_id 24HRMIDNIGHT
qc_get_record_launch NONE
qc_show_recording Y
qc_web_form_address NULL
qc_script NULL
survey_first_audio_file US_pol_survey_hello
survey_dtmf_digits 1238
survey_ni_digit 8
survey_opt_in_audio_file US_pol_survey_transfer
survey_ni_audio_file US_thanks_no_contact
survey_method AGENT_XFER
survey_no_response_action OPTIN
survey_ni_status NI
survey_response_digit_map 1-DEMOCRAT|2-REPUBLICAN|3-INDEPENDANT|8-OPTOUT|X-NO RESPONSE|
survey_xfer_exten 8300
survey_camp_record_dir /home/survey
disable_alter_custphone Y
display_queue_count Y
manual_dial_filter NONE
agent_clipboard_copy NONE
agent_extended_alt_dial N
use_campaign_dnc N
three_way_call_cid CAMPAIGN
three_way_dial_prefix
web_form_target vdcwebform
vtiger_search_category LEAD
vtiger_create_call_record Y
vtiger_create_lead_record Y
vtiger_screen_login Y
cpd_amd_action DISABLED
agent_allow_group_alias N
default_group_alias
vtiger_search_dead ASK
vtiger_status_call N
survey_third_digit
survey_third_audio_file US_thanks_no_contact
survey_third_status NI
survey_third_exten 8300
survey_fourth_digit
survey_fourth_audio_file US_thanks_no_contact
survey_fourth_status NI
survey_fourth_exten 8300
drop_lockout_time 0
quick_transfer_button N
prepopulate_transfer_preset N
drop_rate_group DISABLED
view_calls_in_queue ALL
view_calls_in_queue_launch AUTO
grab_calls_in_queue Y
call_requeue_button N
pause_after_each_call Y
no_hopper_dialing N
agent_dial_owner_only NONE
agent_display_dialable_leads Y
web_form_address_two
waitforsilence_options
campaign_id TESTIN
Inbound Group:
group_id customerservice
group_name Customer Service
group_color green
active Y
web_form_address
voicemail_ext
next_agent_call campaign_rank
fronter_display Y
ingroup_script
get_call_launch NONE
xferconf_a_dtmf
xferconf_a_number
xferconf_b_dtmf
xferconf_b_number
drop_call_seconds 360
drop_action MESSAGE
drop_exten 8307
call_time_id 24hours
after_hours_action MESSAGE
after_hours_message_filename vm-goodbye
after_hours_exten 8300
after_hours_voicemail
welcome_message_filename ---NONE---
moh_context default
onhold_prompt_filename generic_hold
prompt_interval 60
agent_alert_exten ding
agent_alert_delay 1000
default_xfer_group ---NONE---
queue_priority 0
drop_inbound_group ---NONE---
ingroup_recording_override DISABLED
ingroup_rec_filename NONE
afterhours_xfer_group ---NONE---
qc_enabled
qc_statuses
qc_shift_id
qc_get_record_launch
qc_show_recording
qc_web_form_address
qc_script
play_place_in_line N
play_estimate_hold_time N
hold_time_option NONE
hold_time_option_seconds 360
hold_time_option_exten 8300
hold_time_option_voicemail
hold_time_option_xfer_group ---NONE---
hold_time_option_callback_filename vm-hangup
hold_time_option_callback_list_id 999
hold_recall_xfer_group ---NONE---
no_delay_call_route N
play_welcome_message ALWAYS
answer_sec_pct_rt_stat_one 20
answer_sec_pct_rt_stat_two 30
default_group_alias
no_agent_no_queue N
no_agent_action MESSAGE
no_agent_action_value nbdy-avail-to-take-call|vm-goodbye
web_form_address_two

Posted:
Mon Dec 07, 2009 4:51 pm
by benomg
Ah of course. I tested a few times and looking at real-time screen the agent is definitely showing as paused after the "take call" is click. While the agent screen does look like it has resumed to take the call.
2009-12-07 17:14:24|agi-DID_route.agi||INSERT INTO vicidial_did_log SET uniqueid='1260166464.128',channel='IAX2/faktortel-3895',server_ip='192.168.0.55',caller_id_number='0000000000',caller_id_name='0000000000',extension='1111111111',call_date='2009-12-07 17:14:24',did_id='2',did_route='CALLMENU';|
2009-12-07 17:14:24|agi-DID_route.agi|-- DID LOG : |1|INSERT INTO vicidial_did_log SET uniqueid='1260166464.128',channel='IAX2/faktortel-3895',server_ip='192.168.0.55',caller_id_number='0000000000',caller_id_name='0000000000',extension='1111111111',call_date='2009-12-07 17:14:24',did_id='2',did_route='CALLMENU';|
2009-12-07 17:14:24|agi-DID_route.agi|exiting the DID app, transferring call to CALLMENU bluedid
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi|Perl Environment Dump:
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi|0|CALLMENU-----YES-----bluedid--------------------
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- accountcode =
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- callerid = 0000000000
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- calleridname = 0000000000
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- callingani2 = 0
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- callingpres = 0
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- callingtns = 0
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- callington = 0
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- channel = IAX2/faktortel-3895
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- context = bluedid
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- dnid = unknown
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- enhanced = 0.0
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- extension = s
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- language = en
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- priority = 1
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- rdnis = unknown
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- request = agi-VDAD_inbound_calltime_check.agi
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- type = IAX2
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi| -- uniqueid = 1260166464.128
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi|AGI Variables: |1260166464.128|IAX2/faktortel-3895|s|IAX2|0000000000|
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi|+++++ INBOUND CALL VDCL STARTED : |CALLMENU|0000000000-|2009-12-07 17:14:24
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi|-- VDCL vac record deleted: |0E0| 1260166464.128|0000000000|
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi||INSERT INTO vicidial_auto_calls (server_ip,campaign_id,lead_id,status,uniqueid,callerid,channel,phone_code,phone_number,call_time,call_type,stage,queue_priority,last_update_time) values('192.168.0.55','CALLMENU','0','IVR','1260166464.128','0000000000','IAX2/faktortel-3895','','0000000000','2009-12-07 17:14:24','IN','IVR-0','','20091207172424')|
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi|-- VAC : |1|1260166464.128|0000000000|s|
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi||INSERT INTO live_inbound_log (uniqueid,channel,server_ip,caller_id,extension,phone_ext,start_time,comment_a,comment_b,comment_d,comment_e) values('1260166464.128','IAX2/faktortel-3895','192.168.0.55','0000000000','s','0000000000','2009-12-07 17:14:24','CALLMENU','bluedid','bluedid','1')|
2009-12-07 17:14:24|agi-VDAD_inbound_calltime_check.agi|-- LIL : |1|1260166464.128|0000000000|s|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|Perl Environment Dump:
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0|CIDLOOKUP-----LB-----customerservice-----bluedid--------------------998-----61-----TESTCAMP
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- accountcode =
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- callerid = 0000000000
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- calleridname = 0000000000
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- callington = 0
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- channel = IAX2/faktortel-3895
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- context = bluedid
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- dnid = unknown
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- extension = 1
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- language = en
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- priority = 1
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- type = IAX2
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1260166464.128
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|AGI Variables: |1260166464.128|IAX2/faktortel-3895|1|IAX2|0000000000|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |customerservice|0000000000-bluedid|2009-12-07 17:14:26
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list search |0000000000|SELECT lead_id from vicidial_list where phone_number='0000000000' order by last_local_call_time desc limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|VDAD vicidial_list found |71277|SELECT lead_id from vicidial_list where phone_number='0000000000' order by last_local_call_time desc limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|71277|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|callerID changed: Y1207171426000071277
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|1|select auto_call_id from vicidial_auto_calls where uniqueid='1260166464.128' and server_ip='192.168.0.55';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|1|UPDATE vicidial_auto_calls SET campaign_id='customerservice',status='LIVE',lead_id='71277',callerid='Y1207171426000071277',channel='IAX2/faktortel-3895',phone_code='61',phone_number='0000000000',call_time='2009-12-07 17:14:26',call_type='IN',stage='LIVE-0',queue_priority='0' WHERE auto_call_id='871';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log SET lead_id='71277', campaign_id='customerservice', call_date='2009-12-07 17:14:26', start_epoch='1260166466', status='QUEUE', phone_code='61', phone_number='0000000000', user='VDCL', processed='N', xfercallid='0', uniqueid='1260166464.128' ;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDCL : |71277|0|16|insert to vicidial_closer_log
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.25|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.5|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.75|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.25|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.5|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.75|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|3|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|CHANNEL IAX2/faktortel-3895 DOWN 0 360|4 CHECKING AGAIN
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|4|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|6|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20091207171442|Y1207171426000071277|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|7|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|CHANNEL IAX2/faktortel-3895 DOWN 0 360|8 CHECKING AGAIN
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|8|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|10|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|11|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|12|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|13|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|14|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|0E0|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|15|0E0|0E0|update of vla table: customerservice|
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='71277',uniqueid='1260166464.128', channel='IAX2/faktortel-3895', callerid='Y1207171426000071277', call_server_ip='192.168.0.55',comments='INBOUND' where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('KEVTEST','TESTIN') and closer_campaigns LIKE "% customerservice %" and last_update_time > '20091207171421' order by campaign_weight desc,last_call_finish limit 1;|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'customerservice' and call_time < "2009-12-07 17:14:26" and lead_id != '71277' and agent_only='';|
2009-12-07 17:14:26|agi-VDAD_ALL_inbound.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '71277' and agent_only='' and ( (queue_priority > '0') or (queue_priority = '0' and call_time < "2009-12-07 17:14:26") );|