VicidialStillCallsWhenThereAren'tAgentsAvailables----SOLVED

All installation and configuration problems and questions

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

VicidialStillCallsWhenThereAren'tAgentsAvailables----SOLVED

Postby omar » Mon Feb 05, 2007 4:30 pm

I don't know if this situation is correct or not, but this is what happen:
1. In any autodialing method the agent click on the resume button
2. The deal's phone rings and everything goes ok
3. If the deal answer the phone, the call goes to one agent and everything goes well
4. BUT after the conversation between agent and deal, if the deal hangup his/her phone first and the agent don't touch anything in his/her screen. The vicidial dials another number, especially makes a lot of call if the hopper level is set to high values. And after few seconds on the agent's screen appears a light blue screen, with this message:
Code: Select all
customer has hang up: IAX2/ip-address:4569-1
Go Back
Finish and disposition Call


And the vicidial continues making calls. But at this time the deals that answer those calls hear:
I am sorry that's a not valid extension, please try again

Is this normal?

Thanks
Last edited by omar on Wed Feb 07, 2007 4:40 pm, edited 1 time in total.
omar
 
Posts: 77
Joined: Wed Dec 13, 2006 2:05 pm

Postby mflorell » Mon Feb 05, 2007 5:32 pm

Did you apply the cli-concise patch to Asterisk before compiling it?

What is the Asterisk CLI output of "show channels concise"?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Yes, I did

Postby omar » Mon Feb 05, 2007 6:51 pm

mflorell wrote:Did you apply the cli-concise patch to Asterisk before compiling it?

What is the Asterisk CLI output of "show channels concise"?


Yes, I did. I applied the patch
Code: Select all
# wget http://www.eflo.net/files/cli_chan_concise_delimiter.patch
# patch -p1 < ./cli_chan_concise_delimiter.patch
# File to patch: cli.c

The Asterisk CLI ouput of "show channels concise" is:

1. First: When the agent and the deal are in a regular call
Code: Select all
localhost*CLI> show channels concise
IAX2/64.61.93.109:4569-1!default!8600051!1!Up!MeetMe!8600051!!!3!6!(None)
Zap/pseudo-176123036!unused!s!1!Rsrvd!(None)!!!!3!!(None)
SIP/agt300-09ff76e0!default!8600051!1!Up!MeetMe!8600051!!!3!204!(None)


2. Second: When the deal hangup first and it's ringing another phone number but there aren't any available agents
Code: Select all
localhost*CLI> show channels concise
IAX2/64.61.93.109:4569-2!!s!1!Ringing!AppDial!(Outgoing Line)!1800240110!!3!!(None)
Local/00015013125880@default-0536,2!default!00015013125880!2!Ring!Dial!IAX2/username:password@64.61.93.109:4569/15013125880|55|o!1800240110!!3!3!(None)
Local/00015013125880@default-0536,1!default!s!1!Down!(None)!!1800240110!!3!!(None)
Zap/pseudo-176123036!unused!s!1!Rsrvd!(None)!!!!3!!(None)
SIP/agt300-09ff76e0!default!8600051!1!Up!MeetMe!8600051!!!3!371!(None)
HTT*CLI>


3. Third: When the deal answer and hears: I am sorry that is not a valid extension, please try again
Code: Select all
localhost*CLI> show channels concise
IAX2/64.61.93.109:4569-2!default!i!2!Up!(None)!!!!3!18!(None)
Zap/pseudo-176123036!unused!s!1!Rsrvd!(None)!!!!3!!(None)
SIP/agt300-09ff76e0!default!8600051!1!Up!MeetMe!8600051!!!3!418!(None)
localhost*CLI>
    -- Timeout on IAX2/64.61.93.109:4569-2
  == CDR updated on IAX2/64.61.93.109:4569-2
    -- Executing Goto("IAX2/64.61.93.109:4569-2", "#|1") in new stack
    -- Goto (default,#,1)
    -- Executing Playback("IAX2/64.61.93.109:4569-2", "invalid") in new stack
    -- Playing 'invalid' (language 'en')
    -- Executing Hangup("IAX2/64.61.93.109:4569-2", "") in new stack
  == Spawn extension (default, #, 2) exited non-zero on 'IAX2/64.61.93.109:4569-2'
    -- Executing DeadAGI("IAX2/64.61.93.109:4569-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/64.61.93.109:4569-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--HVcauses--PRI-----NODEBUG-----16---------------) completed, returning 0
    -- Hungup 'IAX2/64.61.93.109:4569-2'


Thanks mflorell
omar
 
Posts: 77
Joined: Wed Dec 13, 2006 2:05 pm

Postby mflorell » Tue Feb 06, 2007 1:01 am

Can you post agiout logfile output from when this happens?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

agiout logfile output

Postby omar » Tue Feb 06, 2007 12:08 pm

mflorell wrote:Can you post agiout logfile output from when this happens?


Here is the agiout logfile output, when the system calls another deal, and there aren't any availables agents. And the deals hear: I am sorry that is not a valid extension, please try again
Code: Select all
2007-02-06 12:41:29|agi-VDADtransfer.agi|Perl Environment Dump:
2007-02-06 12:41:29|agi-VDADtransfer.agi|0|8365
2007-02-06 12:41:29|agi-VDADtransfer.agi|callerID changed: V0206124120000000117
2007-02-06 12:41:29|agi-VDADtransfer.agi|AGI Environment Dump:
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- accountcode =
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callerid = 1800240110
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- calleridname = V0206124120000000117
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callingani2 = 0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callingpres = 0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callingtns = 0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callington = 0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- channel = Local/00015013129559@default-a68c,1
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- context = default
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- dnid = unknown
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- extension = 8365
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- language = en
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- priority = 2
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- rdnis = unknown
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- type = Local
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- uniqueid = 1170780080.5
2007-02-06 12:41:29|agi-VDADtransfer.agi|AGI Variables: |1170780080.5|Local/00015013129559@default-a68c,1|8365|Local|V0206124120000000117|V0206124120000000117|2|
2007-02-06 12:41:29|agi-VDADtransfer.agi|+++++ VDAD START : |117|2007-02-06 12:41:29|1.2.14|2|
2007-02-06 12:41:29|agi-VDADtransfer.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2
2007-02-06 12:41:29|agi-VDADtransfer.agi|Perl Environment Dump:
2007-02-06 12:41:29|agi-VDADtransfer.agi|0|8365
2007-02-06 12:41:29|agi-VDADtransfer.agi|callerID changed: V0206124120000000117
2007-02-06 12:41:29|agi-VDADtransfer.agi|AGI Environment Dump:
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- accountcode =
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callerid = unknown
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- calleridname = V0206124120000000117
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callingani2 = 0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callingpres = 0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callingtns = 0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- callington = 0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- channel = IAX2/64.61.93.109:4569-2
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- context = default
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- dnid = unknown
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- extension = 8365
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- language = en
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- priority = 3
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- rdnis = unknown
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- type = IAX2
2007-02-06 12:41:29|agi-VDADtransfer.agi| -- uniqueid = 1170780080.5
2007-02-06 12:41:29|agi-VDADtransfer.agi|AGI Variables: |1170780080.5|IAX2/64.61.93.109:4569-2|8365|IAX2|V0206124120000000117|V0206124120000000117|3|
2007-02-06 12:41:29|agi-VDADtransfer.agi|+++++ VDAD START : |117|2007-02-06 12:41:29|1.2.14|3|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD : |1|update of vac table: V0206124120000000117
|UPDATE vicidial_auto_calls set uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2',status='LIVE',stage='LIVE-0' where callerid='V0206124120000000117' order by call_time desc limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('1170780080.5','117','TESTCAMP','2007-02-06 12:41:29','1170780089','QUEUE','1','5013129559','VDAD','N')|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD : |117|117|insert to vicidial_log: 1170780080.5
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:29|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.5' and campaign_id = 'TESTCAMP' and call_time < "2007-02-06 12:41:20" and lead_id != '117';|
2007-02-06 12:41:29|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: TESTCAMP|192.168.2.5
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='117',uniqueid='1170780080.5', channel='IAX2/64.61.93.109:4569-2', callerid='V0206124120000000117' where status = 'READY' and server_ip='192.168.2.5' and campaign_id='TESTCAMP' and last_update_time > '19691231195955' order by last_call_finish limit 1;|
2007-02-06 12:41:29|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-02-06 12:41:35|agi-VDADtransfer.agi||SELECT voicemail_ext FROM vicidial_campaigns where campaign_id = 'TESTCAMP' limit 1;|
2007-02-06 12:41:35|agi-VDADtransfer.agi|exiting the VDAD app, transferring call to 85026666666666
2007-02-06 12:41:35|agi-VDADtransfer.agi|--    VDAD vac record deleted: |1|TESTCAMP|
2007-02-06 12:41:35|agi-VDADtransfer.agi||UPDATE vicidial_log set status='DROP',end_epoch='1170780095',length_in_sec='5' where uniqueid = '1170780080.5';|
2007-02-06 12:41:35|agi-VDADtransfer.agi|--    VDAD vicidial_log update: |1|1170780080.5
2007-02-06 12:41:35|agi-VDADtransfer.agi||UPDATE vicidial_list set status='DROP' where lead_id = '117';|
2007-02-06 12:41:35|agi-VDADtransfer.agi|--    VDAD vicidial_list update: |1|117
omar
 
Posts: 77
Joined: Wed Dec 13, 2006 2:05 pm

Postby mflorell » Tue Feb 06, 2007 12:23 pm

What is your dial level/dial method set to?

The other issue of the "invalid extension" is a bug and has been fixed in SVN.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Auto dial method settings and the SVN version

Postby omar » Tue Feb 06, 2007 2:06 pm

mflorell wrote:What is your dial level/dial method set to?

The other issue of the "invalid extension" is a bug and has been fixed in SVN.


These are the settings for the autodial method:
    Dial Method: ADAPT_HARD_LIMIT
    Auto Dial Level: 1.1
    Available Only Tally: N
    Drop Percentage Limit: 1%
    Maximum Adapt Dial Level: 1.1
    Latest Server Time: 2200
    Adapt Intensity Modifier: 0 - Balanced
    Dial Level Difference Target: 0 --- 0 Balanced
    Concurrent Transfers: AUTO


Now, I installed the SVN relase, but the problem is almost the same, the only diference is that the deal now doesn't hear "I am sorry, that's a not valid extension, please try again". Now he hears a busy signal

PD.
I am not sure to use the SVN relase, because is a beta version (2.0.3b1.5) and I don't think that this version is stable for a production environment
omar
 
Posts: 77
Joined: Wed Dec 13, 2006 2:05 pm

Postby mflorell » Tue Feb 06, 2007 3:48 pm

Change "Available Only Tally" to Y and the dialer will only dial for agents that are waiting for a call.

the SVN codebase from today is running in production right now on over 160-seats at a call center I maintain. It is stable.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

The same with different settings

Postby omar » Tue Feb 06, 2007 5:43 pm

mflorell wrote:Change "Available Only Tally" to Y and the dialer will only dial for agents that are waiting for a call.

the SVN codebase from today is running in production right now on over 160-seats at a call center I maintain. It is stable.


The problem is the same, I tried with different settings in the autodialing method (including "Available Only Tally" to Y) and the result is the same:
Here is what I have in the real time screen, when the deal hangup first, and the vicidial calls another number, without any available agents. And the agent in the call now has a light blue screen

1. FIRST: RINGING
Code: Select all
1 calls being placed  1 calls ringing      0 calls waiting for agents
2 agents logged in    1 agents in calls   0 agents waiting    1 paused agents


2. SECOND: CALL DROPPED
Code: Select all
1 calls being placed  0 calls ringing      1 calls waiting for agents
2 agents logged in    1 agents in calls   0 agents waiting    1 paused agents


Or is this behavior normal :?:
:shock:
omar
 
Posts: 77
Joined: Wed Dec 13, 2006 2:05 pm

Postby mflorell » Wed Feb 07, 2007 10:33 am

Looks like you found a bug.

I've fixed it in SVN in the AST_VDauto_dial.pl script.

Thanks!
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby omar » Wed Feb 07, 2007 1:03 pm

mflorell wrote:Looks like you found a bug.

I've fixed it in SVN in the AST_VDauto_dial.pl script.

Thanks!

Thanks to you

But I upgraded a new version of the SVN (2.0.3b2.5) from a old SVN (2.0.3b1.5). But now any agents can't log in to a campaign (with the old and new agents). I checked the User Groups and everythings is ok. But when an agents wants to log in, they always have Sorry, you are not allowed to login to this campaign: TESTCAMP
This what I did when I upgraded from 2.0.3b1.5 to 2.0.3b2.5
I deleted the /usr/src/astguiclient directory, then
Code: Select all
# mkdir /usr/src/astguiclient
# cd /usr/src/astguiclient
# svn checkout svn://205.201.151.21:43690/agc_2-X
# cd agc_2-X/trunk/
# perl install.pl (manual installation)


I think, I will reinstall everything again
:cry:
or What do you recommend?
omar
 
Posts: 77
Joined: Wed Dec 13, 2006 2:05 pm

Postby enjay » Wed Feb 07, 2007 1:13 pm

make sure you the user group the agents belong to are allowed to log into that campaign (user groups).
enjay
 
Posts: 806
Joined: Mon Jun 19, 2006 12:40 pm
Location: Utah

Postby omar » Wed Feb 07, 2007 1:53 pm

enjay wrote:make sure you the user group the agents belong to are allowed to log into that campaign (user groups).


User Groups:
Group: Agents
Description: TestAgents
ALL-CAMPAIGNS - USERS CAN VIEW ANY CAMPAIGN (checked)

Users ---> Add a new user:
User Number: 7777
password: test
Full name: TestUser
User level: 1
User Group: Agents
Phone login: (empty)
Phone Pass: (empty)

And the extrange thing is: After I created an agent, and if I want to modify some value, the Vicidial can't. For example I want to change Vicidial Recording from 1 to 0, but the vicidial can't. The only thing that What I can do is DELETE THIS USER
:shock:
omar
 
Posts: 77
Joined: Wed Dec 13, 2006 2:05 pm

Postby mflorell » Wed Feb 07, 2007 3:37 pm

post results of this query:(replace 6666 with the user ID you login to the admin.php page with)

SELECT * from vicidial_users where user='6666';


Also, post the build of the admin.php script you are using.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby omar » Wed Feb 07, 2007 3:47 pm

mflorell wrote:post results of this query:(replace 6666 with the user ID you login to the admin.php page with)

SELECT * from vicidial_users where user='6666';


Also, post the build of the admin.php script you are using.


Code: Select all
mysql> SELECT * from vicidial_users where user='6666';
+---------+------+------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+
| user_id | user | pass | full_name | user_level | user_group | phone_login | phone_pass | delete_users | delete_user_groups | delete_lists | delete_campaigns | delete_ingroups | delete_remote_agents | load_leads | campaign_detail | ast_admin_access | ast_delete_phones | delete_scripts | modify_leads | hotkeys_active | change_agent_campaign | agent_choose_ingroups | closer_campaigns | scheduled_callbacks | agentonly_callbacks | agentcall_manual | vicidial_recording | vicidial_transfers | delete_filters | alter_agent_interface_options | closer_default_blended | delete_call_times | modify_call_times | modify_users | modify_campaigns | modify_lists | modify_scripts | modify_filters | modify_ingroups | modify_usergroups | modify_remoteagents | modify_servers | view_reports |
+---------+------+------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+
|       1 | 6666 | 1234 | Admin     |          9 | ADMIN      |             |            | 1            | 1                  | 1            | 1                | 1               | 1                    | 1          | 1               | 1                | 1                 | 1              | 1            | 0              | 1                     | 1                     |                  | 1                   | 0                   | 0                | 1                  | 1                  | 1              | 1                             | 0                      | 1                 | 1                 | 1            | 1                | 1            | 1              | 1              | 1               | 1                 | 1                   | 1              | 1            |
+---------+------+------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+
1 row in set (0.01 sec)



and the build of the admin.php is:
VERSION: 2.0.85 BUILD: 70206-1323
omar
 
Posts: 77
Joined: Wed Dec 13, 2006 2:05 pm

Postby mflorell » Wed Feb 07, 2007 4:14 pm

You missed updates in the upgrade_2.0.3.sql file.

In this table specifically you are missing the vicidial_recording_override field at the end.

Make sure you have run all of the SQL statements in that file or other things might now work.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

SOLVED

Postby omar » Wed Feb 07, 2007 4:38 pm

mflorell wrote:You missed updates in the upgrade_2.0.3.sql file.

In this table specifically you are missing the vicidial_recording_override field at the end.

Make sure you have run all of the SQL statements in that file or other things might now work.


MFLORELL you're great

OK, The main problem was solved. The vicidial don't call when there aren't agents availables. How? With the new release of the SVN (VERSION 2.0.3b2.5)

The second problem of this topic was solved too. How? With a little unusual upgrade from 2.0.3b1.5 to 2.0.3b2.5

Code: Select all
mysql
use asterisk
\. /path/from/root/extras/upgrade_2.0.3.sql
quit
omar
 
Posts: 77
Joined: Wed Dec 13, 2006 2:05 pm

Exact the same problem

Postby eijal » Mon Mar 05, 2007 5:27 pm

I have the exact same problem, when the deal hangs up first, vicidial is making calls when there aren't agents availables. These are my settings:

- ASTERISK
asterisk-1.2.4
zaptel-1.2.12
libpri-1.2.4
timer: ztdummy

- VICIDIAL
relase 2.0.3b4.5
.../agc/vicidial.php version: 2.0.122 BUILD: 70226-1252
I applied the cli-concise patch

- AUTODIAL
Dial Method: ADAPT_HARD_LIMIT
Auto Dial Level: 1
Available Only Tally: N
Drop Percentage Limit: 1%
Maximum Adapt Dial Level: 1.2
Latest Server Time: 2100
Adapt Intensity Modifier: 0 - Balanced
Dial Level Difference Target: 0 --- 0 Balanced
Concurrent Transfers: AUTO

The Asterisk CLI ouputs of "show channels concise" are:
1. When is ok the call
Code: Select all
IAX2/64.61.93.109:4569-1!default!8600051!1!Up!MeetMe!8600051!!!3!6!(None)
Zap/pseudo-1536364337!default!s!1!Rsrvd!(None)!!!!3!!(None)
SIP/agt300-0079c050!default!8600051!1!Up!MeetMe!8600051!!!3!1992!(None)

2. When the vicidial calls another phone number when there aren't availables agents
Code: Select all
IAX2/64.61.93.109:4569-6!!s!1!Ringing!AppDial!(Outgoing Line)!8002401109!!3!!(None)
Local/38414797562574@default-85a4,2!default!38414797562574!2!Ring!Dial!IAX2/user:pass@64.61.93.109:4569/14797562574|55|o!8002401109!!3!5!(None)
Local/38414797562574@default-85a4,1!default!s!1!Down!(None)!!8002401109!!3!!(None)
Zap/pseudo-1536364337!default!s!1!Rsrvd!(None)!!!!3!!(None)
SIP/agt300-0079c050!default!8600051!1!Up!MeetMe!8600051!!!3!2210!(None)


And the agiout file when this happen is:
Code: Select all
2007-03-05 18:09:42|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:09:42|agi-VDADtransfer.agi|0|8365
2007-03-05 18:09:42|agi-VDADtransfer.agi|callerID changed: V0305180925000000004
2007-03-05 18:09:42|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callerid = 8002401109
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- calleridname = V0305180925000000004
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- channel = Local/38414797562574@default-85a4,1
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- priority = 2
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- type = Local
2007-03-05 18:09:42|agi-VDADtransfer.agi| -- uniqueid = 1173132565.75
2007-03-05 18:09:42|agi-VDADtransfer.agi|AGI Variables: |1173132565.75|Local/38414797562574@default-85a4,1|8365|Local|V0305180925000000004|V0305180925000000004|2|
2007-03-05 18:09:42|agi-VDADtransfer.agi|+++++ VDAD START : |4|2007-03-05 18:09:42|1.2.14|2|
2007-03-05 18:09:42|agi-VDADtransfer.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2
2007-03-05 18:09:43|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:09:43|agi-VDADtransfer.agi|0|8365
2007-03-05 18:09:43|agi-VDADtransfer.agi|callerID changed: V0305180925000000004
2007-03-05 18:09:43|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callerid = unknown
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- calleridname = V0305180925000000004
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- channel = IAX2/64.61.93.109:4569-6
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- priority = 3
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- type = IAX2
2007-03-05 18:09:43|agi-VDADtransfer.agi| -- uniqueid = 1173132565.75
2007-03-05 18:09:43|agi-VDADtransfer.agi|AGI Variables: |1173132565.75|IAX2/64.61.93.109:4569-6|8365|IAX2|V0305180925000000004|V0305180925000000004|3|
2007-03-05 18:09:43|agi-VDADtransfer.agi|+++++ VDAD START : |4|2007-03-05 18:09:43|1.2.14|3|
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where callerid='V0305180925000000004';|
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where callerid='V0305180925000000004' and status IN('LIVE','XFER');|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD : |1|update of vac table: V0305180925000000004
|UPDATE vicidial_auto_calls set uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6',status='LIVE',stage='LIVE-0' where callerid='V0305180925000000004' order by call_time desc limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('1173132565.75','4','AGENTES','2007-03-05 18:09:43','1173132583','QUEUE','1','4797562574','VDAD','N')|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD : |4|4|insert to vicidial_log: 1173132565.75
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where server_ip='192.168.2.6' and campaign_id = 'AGENTES' and last_update_time > '20070305180938';|
2007-03-05 18:09:43|agi-VDADtransfer.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:43|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:09:25" and lead_id != '4';|
2007-03-05 18:09:43|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='4',uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6', callerid='V0305180925000000004' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305180938' order by last_call_finish limit 1;|
2007-03-05 18:09:43|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:09:48|agi-VDADtransfer.agi||SELECT voicemail_ext FROM vicidial_campaigns where campaign_id = 'AGENTES' limit 1;|
2007-03-05 18:09:48|agi-VDADtransfer.agi|--    VDAD call_hungup timout: |VH0305180948||IAX2/64.61.93.109:4569-6|insert to vicidial_manager
2007-03-05 18:09:48|agi-VDADtransfer.agi|--    VDAD vac record deleted: |1|AGENTES|
2007-03-05 18:09:48|agi-VDADtransfer.agi||UPDATE vicidial_log set status='DROP',end_epoch='1173132588',length_in_sec='5' where uniqueid = '1173132565.75';|
2007-03-05 18:09:48|agi-VDADtransfer.agi|--    VDAD vicidial_log update: |1|1173132565.75
2007-03-05 18:09:48|agi-VDADtransfer.agi||UPDATE vicidial_list set status='DROP' where lead_id = '4';|
2007-03-05 18:09:48|agi-VDADtransfer.agi|--    VDAD vicidial_list update: |1|4
2007-03-05 18:09:48|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:09:48|agi-VDADtransfer.agi|0|8365
2007-03-05 18:09:48|agi-VDADtransfer.agi|callerID changed: V0305180925000000004
2007-03-05 18:09:48|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callerid = unknown
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- calleridname = V0305180925000000004
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- channel = IAX2/64.61.93.109:4569-6
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- priority = 4
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- type = IAX2
2007-03-05 18:09:48|agi-VDADtransfer.agi| -- uniqueid = 1173132565.75
2007-03-05 18:09:48|agi-VDADtransfer.agi|AGI Variables: |1173132565.75|IAX2/64.61.93.109:4569-6|8365|IAX2|V0305180925000000004|V0305180925000000004|4|
2007-03-05 18:09:48|agi-VDADtransfer.agi|+++++ VDAD START : |4|2007-03-05 18:09:48|1.2.14|4|
2007-03-05 18:09:48|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where callerid='V0305180925000000004';|
2007-03-05 18:09:48|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where callerid='V0305180925000000004' and status IN('LIVE','XFER');|
2007-03-05 18:09:48|agi-VDADtransfer.agi|--    VDAD : |0E0|update of vac table: V0305180925000000004
|UPDATE vicidial_auto_calls set uniqueid='1173132565.75', channel='IAX2/64.61.93.109:4569-6',status='LIVE',stage='LIVE-0' where callerid='V0305180925000000004' order by call_time desc limit 1;|
2007-03-05 18:09:48|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-05 18:09:48|agi-VDADtransfer.agi|WWWWWWWW VDAD XFER WAIT: |0||IAX2/64.61.93.109:4569-6|V0305180925000000004|1173132565.75|
2007-03-05 18:14:05|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:14:05|agi-VDADtransfer.agi|0|8365
2007-03-05 18:14:05|agi-VDADtransfer.agi|callerID changed: V0305181342000000009
2007-03-05 18:14:05|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callerid = 8002401109
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- calleridname = V0305181342000000009
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- channel = Local/38414797708939@default-31f1,1
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- priority = 2
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- type = Local
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- uniqueid = 1173132822.90
2007-03-05 18:14:05|agi-VDADtransfer.agi|AGI Variables: |1173132822.90|Local/38414797708939@default-31f1,1|8365|Local|V0305181342000000009|V0305181342000000009|2|
2007-03-05 18:14:05|agi-VDADtransfer.agi|+++++ VDAD START : |9|2007-03-05 18:14:05|1.2.14|2|
2007-03-05 18:14:05|agi-VDADtransfer.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 2
2007-03-05 18:14:05|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:14:05|agi-VDADtransfer.agi|0|8365
2007-03-05 18:14:05|agi-VDADtransfer.agi|callerID changed: V0305181342000000009
2007-03-05 18:14:05|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callerid = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- calleridname = V0305181342000000009
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- channel = IAX2/64.61.93.109:4569-4
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- priority = 3
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- type = IAX2
2007-03-05 18:14:05|agi-VDADtransfer.agi| -- uniqueid = 1173132822.90
2007-03-05 18:14:05|agi-VDADtransfer.agi|AGI Variables: |1173132822.90|IAX2/64.61.93.109:4569-4|8365|IAX2|V0305181342000000009|V0305181342000000009|3|
2007-03-05 18:14:05|agi-VDADtransfer.agi|+++++ VDAD START : |9|2007-03-05 18:14:05|1.2.14|3|
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where callerid='V0305181342000000009';|
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where callerid='V0305181342000000009' and status IN('LIVE','XFER');|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD : |1|update of vac table: V0305181342000000009
|UPDATE vicidial_auto_calls set uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4',status='LIVE',stage='LIVE-0' where callerid='V0305181342000000009' order by call_time desc limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('1173132822.90','9','AGENTES','2007-03-05 18:14:05','1173132845','QUEUE','1','4797708939','VDAD','N')|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD : |9|9|insert to vicidial_log: 1173132822.90
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where server_ip='192.168.2.6' and campaign_id = 'AGENTES' and last_update_time > '20070305181400';|
2007-03-05 18:14:05|agi-VDADtransfer.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:05|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = 'AGENTES' and call_time < "2007-03-05 18:13:42" and lead_id != '9';|
2007-03-05 18:14:05|agi-VDADtransfer.agi|--    VDAD get agent: |0E0|update of vla table: AGENTES|192.168.2.6
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4', callerid='V0305181342000000009' where status = 'READY' and server_ip='192.168.2.6' and campaign_id='AGENTES' and last_update_time > '20070305181400' order by last_call_finish limit 1;|
2007-03-05 18:14:05|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-05 18:14:10|agi-VDADtransfer.agi||SELECT voicemail_ext FROM vicidial_campaigns where campaign_id = 'AGENTES' limit 1;|
2007-03-05 18:14:10|agi-VDADtransfer.agi|--    VDAD call_hungup timout: |VH0305181410||IAX2/64.61.93.109:4569-4|insert to vicidial_manager
2007-03-05 18:14:10|agi-VDADtransfer.agi|--    VDAD vac record deleted: |1|AGENTES|
2007-03-05 18:14:10|agi-VDADtransfer.agi||UPDATE vicidial_log set status='DROP',end_epoch='1173132850',length_in_sec='5' where uniqueid = '1173132822.90';|
2007-03-05 18:14:10|agi-VDADtransfer.agi|--    VDAD vicidial_log update: |1|1173132822.90
2007-03-05 18:14:10|agi-VDADtransfer.agi||UPDATE vicidial_list set status='DROP' where lead_id = '9';|
2007-03-05 18:14:10|agi-VDADtransfer.agi|--    VDAD vicidial_list update: |1|9
2007-03-05 18:14:10|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-05 18:14:10|agi-VDADtransfer.agi|0|8365
2007-03-05 18:14:10|agi-VDADtransfer.agi|callerID changed: V0305181342000000009
2007-03-05 18:14:10|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- accountcode =
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callerid = unknown
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- calleridname = V0305181342000000009
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- callington = 0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- channel = IAX2/64.61.93.109:4569-4
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- context = default
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- extension = 8365
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- language = en
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- priority = 4
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- type = IAX2
2007-03-05 18:14:10|agi-VDADtransfer.agi| -- uniqueid = 1173132822.90
2007-03-05 18:14:10|agi-VDADtransfer.agi|AGI Variables: |1173132822.90|IAX2/64.61.93.109:4569-4|8365|IAX2|V0305181342000000009|V0305181342000000009|4|
2007-03-05 18:14:10|agi-VDADtransfer.agi|+++++ VDAD START : |9|2007-03-05 18:14:10|1.2.14|4|
2007-03-05 18:14:10|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_live_agents where callerid='V0305181342000000009';|
2007-03-05 18:14:10|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where callerid='V0305181342000000009' and status IN('LIVE','XFER');|
2007-03-05 18:14:10|agi-VDADtransfer.agi|--    VDAD : |0E0|update of vac table: V0305181342000000009
|UPDATE vicidial_auto_calls set uniqueid='1173132822.90', channel='IAX2/64.61.93.109:4569-4',status='LIVE',stage='LIVE-0' where callerid='V0305181342000000009' order by call_time desc limit 1;|
2007-03-05 18:14:10|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.2.6' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-05 18:14:10|agi-VDADtransfer.agi|WWWWWWWW VDAD XFER WAIT: |0||IAX2/64.61.93.109:4569-4|V0305181342000000009|1173132822.90|


Please help, I am having a lot of DROP calls :(
eijal
 
Posts: 186
Joined: Thu Feb 08, 2007 6:34 pm

SOLVED SOLVED

Postby eijal » Mon Mar 05, 2007 7:25 pm

SOLVED SOLVED!!!!
In the autodialing setting I put:
Available Only Tally: Y
And now the vicidial doesn't call when there aren't availables agents
Thanks Matt
:lol:
eijal
 
Posts: 186
Joined: Thu Feb 08, 2007 6:34 pm


Return to Support

Who is online

Users browsing this forum: Bing [Bot], hanidhakwani and 91 guests