vicidial.org

by **scicali** » Wed Aug 24, 2016 11:16 am

Can I play a custom sound during "Drop Call Seconds"?

I see dialplan but Background() and Playback() seems not work: "Drop Call Seconds" time start after play sound

; VICIDIAL_auto_dialer transfer script Load Balanced:
exten => 8368,1,Playback(sip-silence)
exten => 8368,n,Playback(my-custom-sound)
exten => 8368,n,AGI(agi://127.0.0.1:4577/call_log)
exten => 8368,n,AGI(agi-VDAD_ALL_outbound.agi,NORMAL-----LB)
exten => 8368,n,AGI(agi-VDAD_ALL_outbound.agi,NORMAL-----LB)
exten => 8368,n,Hangup()

by **mflorell** » Wed Aug 24, 2016 12:05 pm

Nope, won't work that way, that will just delay routing of the call.

There is currently no option to do what you want to do, other than dropping the call to an in-group immediately and using music-on-hold, but that could lead to load issues depending on your call volume.

by **scicali** » Thu Aug 25, 2016 2:18 am

This can be a new feature?

Italian privacy rules requires a background sound of "talking people" during "Drop Call Seconds".
Customers must understand that the call is from a call center during "Drop Call Seconds".

by **mflorell** » Thu Aug 25, 2016 5:46 am

I would suggest trying dropping the call to an in-group and see how that works for you.

by **williamconley** » Fri Sep 16, 2016 8:25 pm

scicali wrote:This can be a new feature?

Italian privacy rules requires a background sound of "talking people" during "Drop Call Seconds".
Customers must understand that the call is from a call center during "Drop Call Seconds".

As MFlorell says: Set the Drop Call Seconds to Zero ... then set the action to drop the call to an ingroup. Put the audio you want as MOH for that ingroup and set the drop call seconds for that ingroup to the appropriate value for the "real" drop call seconds.

by **scicali** » Tue Sep 20, 2016 9:36 am

I'll try it.. I have to create a group for each campaign.. right?

by **williamconley** » Tue Oct 18, 2016 8:40 pm

scicali wrote:I'll try it.. I have to create a group for each campaign.. right?

Technically, no. But if you want to continue to segregate the calls by campaign, then yes. You could create a single Ingroup, assign it to ALL agents regardless of campaign, etc., but then all the calls would be in one Ingroup and you have essentially lost the ability to control them separately. If that's good for you, you only need one ingroup. 8-)

by **davide.filippi** » Tue Apr 25, 2017 3:49 pm

Hi all
I have the same problem.
I've set
drop call seconds: 0
drop action: in_group
but the audio I choose is listen after 10 seconds

[Apr 25 22:39:04] -- Executing [49639__phone_number_called__@default:1] AGI("Local/49639__phone_number_called__@default-4d02,2", "agi://127.0.0.1:4577/call_log") in new stack
[Apr 25 22:39:04] -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
[Apr 25 22:39:04] -- Executing [49639__phone_number_called__@default:2] Dial("Local/49639__phone_number_called__@default-4d02,2", "sip/39__phone_number_called__@__provider_server_ip__|60|Tto") in new stack
[Apr 25 22:39:04] -- Called 39__phone_number_called__@__provider_server_ip__
[Apr 25 22:39:06] == Parsing '/etc/asterisk/manager.conf': [Apr 25 22:39:06] Found
[Apr 25 22:39:06] == Manager 'sendcron' logged on from 127.0.0.1
[Apr 25 22:39:06] == Manager 'sendcron' logged off from 127.0.0.1
[Apr 25 22:39:11] -- SIP/__provider_server_ip__-00000007 is making progress passing it to Local/49639__phone_number_called__@default-4d02,2
[Apr 25 22:39:18] -- SIP/__provider_server_ip__-00000007 answered Local/49639__phone_number_called__@default-4d02,2
[Apr 25 22:39:18] > Channel Local/49639__phone_number_called__@default-4d02,1 was answered.
[Apr 25 22:39:18] -- Executing [8369@default:1] Playback("Local/49639__phone_number_called__@default-4d02,1", "sip-silence") in new stack
[Apr 25 22:39:18] -- <Local/49639__phone_number_called__@default-4d02,1> Playing 'sip-silence' (language 'en')
[Apr 25 22:39:18] WARNING[26925]: file.c:1297 waitstream_core: Unexpected control subclass '-1'
[Apr 25 22:39:18] -- Executing [h@default:1] DeadAGI("Local/49639__phone_number_called__@default-4d02,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----14-----0") in new stack
[Apr 25 22:39:19] -- Executing [8369@default:2] AGI("SIP/__provider_server_ip__-00000007", "agi://127.0.0.1:4577/call_log") in new stack
[Apr 25 22:39:19] -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
[Apr 25 22:39:19] -- Executing [8369@default:3] AMD("SIP/__provider_server_ip__-00000007", "2000|2000|1000|5000|120|50|4|256") in new stack
[Apr 25 22:39:19] -- AMD: SIP/__provider_server_ip__-00000007 390287189885 (null) (Fmt: 64)
[Apr 25 22:39:19] -- AMD: initialSilence [2000] greeting [2000] afterGreetingSilence [1000] totalAnalysisTime [5000] minimumWordLength [120] betweenWordsSilence [50] maximumNumberOfWords [4] silenceThreshold [256]
[Apr 25 22:39:19] -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... --14-----0 completed, returning 0
[Apr 25 22:39:19] == Spawn extension (default, 49639__phone_number_called__, 2) exited non-zero on 'Local/49639__phone_number_called__@default-4d02,2'
[Apr 25 22:39:19] -- AMD: Changed state to STATE_IN_SILENCE
[Apr 25 22:39:20] -- AMD: Word detected. iWordsCount:1
[Apr 25 22:39:20] == Manager 'sendcron' logged off from 127.0.0.1
[Apr 25 22:39:20] -- AMD: Changed state to STATE_IN_SILENCE
[Apr 25 22:39:21] -- AMD: HUMAN: silenceDuration:1030 afterGreetingSilence:1000
[Apr 25 22:39:21] -- Executing [8369@default:4] AGI("SIP/__provider_server_ip__-00000007", "VD_amd.agi|8369") in new stack
[Apr 25 22:39:21] -- Launched AGI Script /var/lib/asterisk/agi-bin/VD_amd.agi
[Apr 25 22:39:21] -- AGI Script VD_amd.agi completed, returning 0
[Apr 25 22:39:21] -- Executing [8369@default:5] AGI("SIP/__provider_server_ip__-00000007", "agi-VDAD_ALL_outbound.agi|NORMAL-----LB") in new stack
[Apr 25 22:39:21] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_outbound.agi
[Apr 25 22:39:31] -- Playing 'ding' (escape_digits=) (sample_offset 0)
[Apr 25 22:39:33] -- AGI Script agi-VDAD_ALL_outbound.agi completed, returning 0
[Apr 25 22:39:33] -- Executing [90009*TMP_IN**36516242**__phone_number_called__**@default:1] Answer("SIP/__provider_server_ip__-00000007", "") in new stack
[Apr 25 22:39:33] -- Executing [90009*TMP_IN**36516242**__phone_number_called__**@default:2] Dial("SIP/__provider_server_ip__-00000007", "IAX2/ASTloop:Q1g8mevQMXBCYdL@127.0.0.1:40569/990009*TMP_IN**36516242**__phone_number_called__**||to") in new stack
[Apr 25 22:39:33] -- Called ASTloop:Q1g8mevQMXBCYdL@127.0.0.1:40569/990009*TMP_IN**36516242**__phone_number_called__**
[Apr 25 22:39:33] -- Accepting AUTHENTICATED call from 127.0.0.1:
> requested format = alaw,
> requested prefs = (alaw|ulaw|g729),
> actual format = ulaw,
> host prefs = (ulaw),
> priority = mine
[Apr 25 22:39:33] -- Executing [990009*TMP_IN**36516242**__phone_number_called__**@default:1] Answer("IAX2/ASTloop-8291", "") in new stack
[Apr 25 22:39:33] -- Executing [990009*TMP_IN**36516242**__phone_number_called__**@default:2] AGI("IAX2/ASTloop-8291", "agi-VDAD_ALL_inbound.agi|CLOSER-----LB-----CL_TESTCAMP-----7275551212-----Closer-----park----------999-----1") in new sta ck
[Apr 25 22:39:33] -- Call accepted by 127.0.0.1 (format ulaw)
[Apr 25 22:39:33] -- Format for call is ulaw
[Apr 25 22:39:33] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi
[Apr 25 22:39:33] -- IAX2/127.0.0.1:40569-15955 answered SIP/__provider_server_ip__-00000007
[Apr 25 22:39:33] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 25 22:39:34] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 25 22:39:35] -- Playing 'busy_agentw' (escape_digits=) (sample_offset 0)
[Apr 25 22:39:48] -- Started music on hold, class 'busy_agent', on IAX2/ASTloop-8291
[Apr 25 22:39:51] -- Stopped music on hold on IAX2/ASTloop-8291
[Apr 25 22:39:51] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 25 22:39:52] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 25 22:39:53] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 25 22:39:54] -- Playing 'busy_agentw' (escape_digits=) (sample_offset 0)

by **mflorell** » Tue Apr 25, 2017 5:10 pm

In-group setting:

No Delay Call Route -Setting this to Y will remove all wait times and audio prompts and attempt to send the call right to an agent. Does not override welcome message or on hold prompt settings. Default is N.

by **davide.filippi** » Wed Apr 26, 2017 3:33 am

No Delay Call Route is yet set to yes

by **mflorell** » Wed Apr 26, 2017 5:38 am

Have you tried doing it without AMD?

We don't recommend using AMD anyway due to it's inaccuracy rate and that you can have as much as 30% false-positives of humans flagged as machines.

by **davide.filippi** » Wed Apr 26, 2017 8:44 am

You mean with the routing exten 8368?
If so yes and still the voice play after seconds.
Also I've tried with the default music and still same issue

From the answer to the "ding" 11 seconds
-- Playing 'ding' (escape_digits=) (sample_offset 0)

by **mflorell** » Wed Apr 26, 2017 10:21 am

Could you post the agiout logfile output for [Apr 25 22:39:21] to [Apr 25 22:39:31]?

by **davide.filippi** » Wed Apr 26, 2017 11:34 am

Sure.
Can you explain me how?
Consider that the previous log was with exten 8369

by **mflorell** » Wed Apr 26, 2017 11:45 am

it will be in /var/log/astguiclient/ on that dialer

by **davide.filippi** » Wed Apr 26, 2017 12:05 pm

I've found this files
AMD_log.txt action_process.2017-04-23 congest.2017-04-23 listen_process.2017-04-26 update.2017-04-23
FASTagiout.2017-04-24 action_process.2017-04-24 congest.2017-04-24 remoteagent.2017-04-23 update.2017-04-24
FASTagiout.2017-04-25 action_process.2017-04-25 congest.2017-04-25 remoteagent.2017-04-24 update.2017-04-25
FASTagiout.2017-04-26 action_process.2017-04-26 congest.2017-04-26 remoteagent.2017-04-25 update.2017-04-26
MySQLerror.2017-04-26 action_send.2017-04-24 listen.2017-04-23 remoteagent.2017-04-26 vdad-JAM.2017-04-24
action_full.2017-04-24 action_send.2017-04-25 listen.2017-04-24 screenlog.0 vdad-JAM.2017-04-25
action_full.2017-04-25 action_send.2017-04-26 listen.2017-04-25 screenlog.0.2017-04-23---33240 vdad-JAM.2017-04-26
action_full.2017-04-26 agiout.2017-04-24 listen.2017-04-26 screenlog.0.2017-04-24---33241 vdautodial.2017-04-23
action_launch.2017-04-24 agiout.2017-04-25 listen_process.2017-04-23 screenlog.0.2017-04-25---33240 vdautodial.2017-04-24
action_launch.2017-04-25 agiout.2017-04-26 listen_process.2017-04-24 screenlog.0.2017-04-26---33242 vdautodial.2017-04-25
action_launch.2017-04-26 archive listen_process.2017-04-25 update.2017-04-22 vdautodial.2017-04-26

and in FASTagiout.2017-04-25 I found this

...
2017-04-25 22:39:19|VDfastAGI|begin|+++++++++++++++++ FastAGI Start ++++++++++++++++++++++++++++++++++++++++
2017-04-25 22:39:19|VDfastAGI|begin|Perl Environment Dump:
2017-04-25 22:39:19|VDfastAGI|begin|0|--debug
2017-04-25 22:39:19|VDfastAGI|begin|AGI Environment Dump:
2017-04-25 22:39:19|VDfastAGI|begin| -- accountcode =
2017-04-25 22:39:19|VDfastAGI|begin| -- callerid = 390287189885
2017-04-25 22:39:19|VDfastAGI|begin| -- calleridname = V4252239040036516242
2017-04-25 22:39:19|VDfastAGI|begin| -- callingani2 = 0
2017-04-25 22:39:19|VDfastAGI|begin| -- callingpres = 0
2017-04-25 22:39:19|VDfastAGI|begin| -- callingtns = 0
2017-04-25 22:39:19|VDfastAGI|begin| -- callington = 0
2017-04-25 22:39:19|VDfastAGI|begin| -- channel = SIP/80.90.90.254-00000007
2017-04-25 22:39:19|VDfastAGI|begin| -- context = default
2017-04-25 22:39:19|VDfastAGI|begin| -- dnid = unknown
2017-04-25 22:39:19|VDfastAGI|begin| -- enhanced = 0.0
2017-04-25 22:39:19|VDfastAGI|begin| -- extension = 8369
2017-04-25 22:39:19|VDfastAGI|begin| -- language = en
2017-04-25 22:39:19|VDfastAGI|begin| -- network = yes
2017-04-25 22:39:19|VDfastAGI|begin| -- network_script = call_log
2017-04-25 22:39:19|VDfastAGI|begin| -- priority = 2
2017-04-25 22:39:19|VDfastAGI|begin| -- rdnis = unknown
2017-04-25 22:39:19|VDfastAGI|begin| -- request = agi://127.0.0.1:4577/call_log
2017-04-25 22:39:19|VDfastAGI|begin| -- type = SIP
2017-04-25 22:39:19|VDfastAGI|begin| -- uniqueid = 1493152744.26
2017-04-25 22:39:19|VDfastAGI|begin|AGI Variables: |1493152744.26|SIP/80.90.90.254-00000007|8369|SIP|V4252239040036516242|
2017-04-25 22:39:19|VDfastAGI|call_log|Process to run: |agi://127.0.0.1:4577/call_log|call_log|START|
2017-04-25 22:39:19|VDfastAGI|call_log|+++++ CALL LOG START : 2017-04-25 22:39:19
2017-04-25 22:39:19|VDfastAGI|call_log||INSERT INTO call_log (uniqueid,channel,channel_group,type,server_ip,extension,number_dialed,start_time,start_epoch,en$
2017-04-25 22:39:18|VDfastAGI|call_log|0||SELECT result FROM vicidial_cpd_log where callerid='V4252239040036516242' and result NOT IN('Voice','Unknown','???'$
2017-04-25 22:39:18|VDfastAGI|call_log|-- VD_hangup Local DEBUG: |PRI|V4252239040036516242|ANSWER|16|0||
...

by **mflorell** » Wed Apr 26, 2017 2:03 pm

there should be an "agiout.2016-04-25" file in there, and if there isn't you should make sure that you have the server's "AGI Output" set to BOTH, and then try a new call.

by **davide.filippi** » Thu Apr 27, 2017 4:33 am

Actually I have
Inbound settings:
Welcome Message Filename: yourcallisimportant
Play Welcome Message: ALWAYS
On Hold Prompt Interval: 1
On Hold Prompt No Block: N
On Hold Prompt Seconds: 1
No Delay Call Route: Y

Campaign settings
Call drop seconds: 0
Drop Action: INGROUP
Drop Transfer Group: TMP_IN

This is what i get from CLI
[Apr 27 11:23:48] -- Executing [49639_PHONE_NUMBER_@default:1] AGI("Local/49639_PHONE_NUMBER_@default-3440,2", "agi://127.0.0.1:4577/call_log") in new stack
[Apr 27 11:23:48] -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
[Apr 27 11:23:48] -- Executing [49639_PHONE_NUMBER_@default:2] Dial("Local/49639_PHONE_NUMBER_@default-3440,2", "sip/39_PHONE_NUMBER_@_SERVER_PROVIDER_|60|Tto") in new stack
[Apr 27 11:23:58] -- Called 39_PHONE_NUMBER_@_SERVER_PROVIDER_
[Apr 27 11:24:02] == Parsing '/etc/asterisk/manager.conf': [Apr 27 11:24:02] Found
[Apr 27 11:24:02] == Manager 'sendcron' logged on from 127.0.0.1
[Apr 27 11:24:02] == Parsing '/etc/asterisk/manager.conf': [Apr 27 11:24:02] Found
[Apr 27 11:24:02] == Manager 'sendcron' logged on from 127.0.0.1
[Apr 27 11:24:02] == Manager 'sendcron' logged off from 127.0.0.1
[Apr 27 11:24:03] -- SIP/_SERVER_PROVIDER_-00000002 is making progress passing it to Local/49639_PHONE_NUMBER_@default-3440,2
[Apr 27 11:24:03] == Manager 'sendcron' logged off from 127.0.0.1
[Apr 27 11:24:06] -- SIP/_SERVER_PROVIDER_-00000002 answered Local/49639_PHONE_NUMBER_@default-3440,2
[Apr 27 11:24:06] > Channel Local/49639_PHONE_NUMBER_@default-3440,1 was answered.
[Apr 27 11:24:06] -- Executing [8368@default:1] Playback("Local/49639_PHONE_NUMBER_@default-3440,1", "sip-silence") in new stack
[Apr 27 11:24:06] -- <Local/49639_PHONE_NUMBER_@default-3440,1> Playing 'sip-silence' (language 'en')
[Apr 27 11:24:06] WARNING[3968]: file.c:1297 waitstream_core: Unexpected control subclass '-1'
[Apr 27 11:24:06] -- Executing [8368@default:2] AGI("Local/49639_PHONE_NUMBER_@default-3440,1", "agi://127.0.0.1:4577/call_log") in new stack
[Apr 27 11:24:06] -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
[Apr 27 11:24:06] -- Executing [8368@default:3] AGI("Local/49639_PHONE_NUMBER_@default-3440,1", "agi-VDAD_ALL_outbound.agi|NORMAL-----LB") in new stack
[Apr 27 11:24:06] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_outbound.agi
[Apr 27 11:24:06] -- Executing [h@default:1] DeadAGI("Local/49639_PHONE_NUMBER_@default-3440,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----18-----0") in new stack
[Apr 27 11:24:07] == Parsing '/etc/asterisk/manager.conf': [Apr 27 11:24:07] Found
[Apr 27 11:24:07] == Manager 'sendcron' logged on from 127.0.0.1
[Apr 27 11:24:07] == Manager 'sendcron' logged off from 127.0.0.1
[Apr 27 11:24:07] -- AGI Script agi-VDAD_ALL_outbound.agi completed, returning 0
[Apr 27 11:24:07] -- Executing [8368@default:4] AGI("SIP/_SERVER_PROVIDER_-00000002", "agi-VDAD_ALL_outbound.agi|NORMAL-----LB") in new stack
[Apr 27 11:24:07] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_outbound.agi
[Apr 27 11:24:07] -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... --18-----0 completed, returning 0
[Apr 27 11:24:07] == Spawn extension (default, 49639_PHONE_NUMBER_, 2) exited non-zero on 'Local/49639_PHONE_NUMBER_@default-3440,2'
[Apr 27 11:24:08] == Manager 'sendcron' logged off from 127.0.0.1
[Apr 27 11:24:17] -- Playing 'ding' (escape_digits=) (sample_offset 0)
[Apr 27 11:24:18] -- AGI Script agi-VDAD_ALL_outbound.agi completed, returning 0
[Apr 27 11:24:18] -- Executing [90009*TMP_IN**36516242**_PHONE_NUMBER_**@default:1] Answer("SIP/_SERVER_PROVIDER_-00000002", "") in new stack
[Apr 27 11:24:18] -- Executing [90009*TMP_IN**36516242**_PHONE_NUMBER_**@default:2] Dial("SIP/_SERVER_PROVIDER_-00000002", "IAX2/ASTloop:wPg4UDaLBeHvpB4@127.0.0.1:40569/990009*TMP_IN**36516242**_PHONE_NUMBER_**||to") in new stack
[Apr 27 11:24:18] -- Called ASTloop:wPg4UDaLBeHvpB4@127.0.0.1:40569/990009*TMP_IN**36516242**_PHONE_NUMBER_**
[Apr 27 11:24:18] -- Accepting AUTHENTICATED call from 127.0.0.1:
> requested format = alaw,
> requested prefs = (alaw|ulaw|g729),
> actual format = ulaw,
> host prefs = (ulaw),
> priority = mine
[Apr 27 11:24:18] -- Executing [990009*TMP_IN**36516242**_PHONE_NUMBER_**@default:1] Answer("IAX2/ASTloop-10349", "") in new stack
[Apr 27 11:24:18] -- Call accepted by 127.0.0.1 (format ulaw)
[Apr 27 11:24:18] -- Executing [990009*TMP_IN**36516242**_PHONE_NUMBER_**@default:2] AGI("IAX2/ASTloop-10349", "agi-VDAD_ALL_inbound.agi|CLOSER-----LB-----CL_TESTCAMP-----7275551212-----Closer-----park----------999-----1") in new stack
[Apr 27 11:24:18] -- Format for call is ulaw
[Apr 27 11:24:18] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi
[Apr 27 11:24:18] -- IAX2/127.0.0.1:40569-12585 answered SIP/_SERVER_PROVIDER_-00000002
[Apr 27 11:24:18] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 27 11:24:18] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 27 11:24:18] -- Playing 'yourcallisimportant' (escape_digits=) (sample_offset 0)
[Apr 27 11:24:28] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 27 11:24:28] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 27 11:24:28] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 27 11:24:28] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[Apr 27 11:24:28] -- AGI Script agi-VDAD_ALL_inbound.agi completed, returning 0
[Apr 27 11:24:28] -- Executing [192*168*001*220*8600051@default:1] Goto("IAX2/ASTloop-10349", "default|8600051|1") in new stack
[Apr 27 11:24:28] -- Goto (default,8600051,1)
[Apr 27 11:24:28] -- Executing [8600051@default:1] MeetMe("IAX2/ASTloop-10349", "8600051|F") in new stack
[Apr 27 11:24:31] == Parsing '/etc/asterisk/manager.conf': [Apr 27 11:24:31] Found
[Apr 27 11:24:31] == Manager 'sendcron' logged on from 127.0.0.1
[Apr 27 11:24:31] == Spawn extension (default, 8600051, 1) exited non-zero on 'IAX2/ASTloop-10349'
[Apr 27 11:24:31] -- Executing [h@default:1] DeadAGI("IAX2/ASTloop-10349", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------") in new stack
[Apr 27 11:24:31] -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ---------- completed, returning 0
[Apr 27 11:24:31] -- Hungup 'IAX2/ASTloop-10349'
[Apr 27 11:24:31] -- Executing [h@default:1] DeadAGI("SIP/_SERVER_PROVIDER_-00000002", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----24-----13") in new stack
[Apr 27 11:24:31] WARNING[3968]: res_agi.c:2230 deadagi_exec: Running DeadAGI on a live channel will cause problems, please use AGI
[Apr 27 11:24:31] == Parsing '/etc/asterisk/manager.conf': [Apr 27 11:24:31] Found
[Apr 27 11:24:31] == Manager 'sendcron' logged on from 127.0.0.1
[Apr 27 11:24:31] -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... -24-----13 completed, returning 0
[Apr 27 11:24:31] -- Hungup 'IAX2/127.0.0.1:40569-12585'
[Apr 27 11:24:31] == Spawn extension (default, 90009*TMP_IN**36516242**_PHONE_NUMBER_**, 2) exited non-zero on 'SIP/_SERVER_PROVIDER_-00000002'

and this is what i get from agiuot file
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi|Perl Environment Dump:
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi|0|NORMAL-----LB
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi|callerID changed: V4271123470036516242
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi|AGI Environment Dump:
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- accountcode =
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- callerid = 390287189885
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- calleridname = V4271123470036516242
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- callingani2 = 0
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- callingpres = 0
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- callingtns = 0
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- callington = 0
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- channel = Local/49639_phone_number_@default-3440,1
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- context = default
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- dnid = unknown
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- enhanced = 0.0
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- extension = 8368
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- language = en
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- priority = 3
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- rdnis = unknown
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- request = agi-VDAD_ALL_outbound.agi
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- type = Local
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi| -- uniqueid = 1493285028.7
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi|AGI Variables: |1493285028.7|Local/49639_phone_number_@default-3440,1|8368|Local|V4271123470036516242|V4271123470036516242|3|
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi|+++++ VDAD START : |36516242|2017-04-27 11:24:06|1.4.44-vici|3|
2017-04-27 11:24:06|agi-VDAD_ALL_outbound.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 3
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|Perl Environment Dump:
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|NORMAL-----LB
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|callerID changed: V4271123470036516242
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|AGI Environment Dump:
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- accountcode =
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- callerid = unknown
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- calleridname = V4271123470036516242
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- callingani2 = 0
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- callingpres = 0
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- callingtns = 0
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- callington = 0
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- channel = SIP/_SERVER_PROVIDER_-00000002
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- context = default
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- dnid = unknown
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- enhanced = 0.0
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- extension = 8368
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- language = en
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- priority = 4
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- rdnis = unknown
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- request = agi-VDAD_ALL_outbound.agi
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- type = SIP
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi| -- uniqueid = 1493285028.7
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|AGI Variables: |1493285028.7|SIP/_SERVER_PROVIDER_-00000002|8368|SIP|V4271123470036516242|V4271123470036516242|4|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|+++++ VDAD START : |36516242|2017-04-27 11:24:07|1.4.44-vici|4|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_live_agents where callerid='V4271123470036516242';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where callerid='V4271123470036516242' and status IN('LIVE','XFER');|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD : |1|update of vac table: V4271123470036516242
|UPDATE vicidial_auto_calls set uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002',status='LIVE',stage='LIVE-0' where callerid='V4271123470036516242' order by call_time desc limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||UPDATE vicidial_list set status='PU' where lead_id='36516242' and status NOT IN('CBHOLD','CALLBK','CBHOLD','QCFAIL','BAD','PCHK','118','RIC','118','120','120','RIC','RIC','RIC','RIC','132','132','RIC','RIC','RIC','RIC','132','120','118','119','120','RIC','132','RIC','RIC','RIC','RIC','RIC','132','RIC','RIC','118','120','RIC','RIC','132','RIC','118','120','118','RIC','RIC','RIC','RIC','RIC','118','120','118','120','120','118','RIC','RIC','RIC','PCHK','PCHK','RIC','RIC','RIC','118','120','118','120','120','118','RIC','RIC','RIC','RIC','RIC');|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD vicidial_list PU update: |1|1493285028.7|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|Preprocess time: |0.107 (1493285047.574232 - 1493285047.467459)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed,alt_dial,list_id,comments) values('1493285028.7','36516242','TMP','2017-04-27 11:24:07','1493285047','QUEUE','1','_phone_number_','VDAD','N','NONE','1000','0.107')|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD : |36516242|36516242|insert to vicidial_log: 1493285028.7
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD VLE insert: |1|
|INSERT INTO vicidial_log_extended set uniqueid='1493285028.7',server_ip='192.168.1.220',call_date='2017-04-27 11:24:07',lead_id = '36516242',caller_code='V4271123470036516242',custom_call_id='';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 0
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 0.25
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 0.5
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 0.75
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 1
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 1.25
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 1.5
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 1.75
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 2
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 2.25
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 2.5
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 2.75
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 3
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 4
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 5
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 6
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 7
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 8
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||SELECT count(*) FROM vicidial_live_agents where campaign_id = 'TMP' and last_update_time > '20170427112402';|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi||CONCURRENT TRANSFERS AUTO SETTING: 1 (1)|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and campaign_id = 'TMP' and call_time < "2017-04-27 11:23:47";|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where ( (status = 'LIVE') and ( (queue_priority > 50) and (call_type='IN') and (campaign_id IN('TMP_IN')) ) );|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|-- VDAD get agent: |0E0|update of vla table: TMP|192.168.1.220
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='36516242',uniqueid='1493285028.7', channel='SIP/_SERVER_PROVIDER_-00000002', call_server_ip='192.168.1.220', callerid='V4271123470036516242',comments='AUTO' where status='READY' and lead_id<1 and ring_callerid='' and campaign_id='TMP' and last_update_time > '20170427112402' order by last_state_change limit 1;|
2017-04-27 11:24:07|agi-VDAD_ALL_outbound.agi|NNNNNNNNNN No agent record found!!! 9
2017-04-27 11:24:17|agi-VDAD_ALL_outbound.agi||UPDATE vicidial_log FORCE INDEX(lead_id) set status='DROP',end_epoch='1493285057',length_in_sec='9',term_reason='QUEUETIMEOUT' where lead_id = '36516242' and uniqueid LIKE "1493285028%";|
2017-04-27 11:24:17|agi-VDAD_ALL_outbound.agi|-- VDAD vicidial_log update: |1|1493285028.7
2017-04-27 11:24:17|agi-VDAD_ALL_outbound.agi||UPDATE vicidial_list set status='DROP' where lead_id = '36516242';|
2017-04-27 11:24:17|agi-VDAD_ALL_outbound.agi|-- VDAD vicidial_list update: |1|36516242
2017-04-27 11:24:17|agi-VDAD_ALL_outbound.agi|-- VDAD vac record deleted: |1|TMP|
2017-04-27 11:24:17|agi-VDAD_ALL_outbound.agi|exiting the VDAD app, transferring call to 90009*TMP_IN**36516242**_phone_number_** default
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi|Perl Environment Dump:
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi|0|CLOSER-----LB-----CL_TESTCAMP-----7275551212-----Closer-----park----------999-----1
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi|callerID changed: "J4271124180036516242 <_phone_number_>"
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- accountcode = ASTloop
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- callerid = unknown
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- calleridname = V4271123470036516242
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- callington = 0
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- channel = IAX2/ASTloop-10349
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- context = default
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- dnid = unknown
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- extension = 990009*TMP_IN**36516242**_phone_number_**
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- language = en
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- priority = 2
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- type = IAX2
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1493285058.11
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi|AGI Variables: |1493285058.11|IAX2/ASTloop-10349|990009*TMP_IN**36516242**_phone_number_**|IAX2|J4271124180036516242|
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |TMP_IN|J4271124180036516242-|2017-04-27 11:24:18
2017-04-27 11:24:18|11:24:18|agi-VDAD_ALL_inbound.agi|-- NANQUE Check: |1|SELECT count(*) FROM vicidial_live_agents where closer_campaigns LIKE "% TMP_IN %" ;
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|36516242|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|callerID changed: "Y4271124180036516242 <_phone_number_>"
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_xfer_log (lead_id,campaign_id,call_date,phone_code,phone_number,user,closer) values('36516242','TMP_IN','2017-04-27 11:24:18','1','_phone_number_','VDAD','VDXL')|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|-- VDXL : |36516242|26|insert to vicidial_xfer_log
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|0|SELECT auto_call_id from vicidial_auto_calls where uniqueid='1493285058.11' and server_ip='192.168.1.220';|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls SET server_ip='192.168.1.220', campaign_id='TMP_IN', status='LIVE', lead_id='36516242', uniqueid='1493285058.11', callerid='Y4271124180036516242', channel='IAX2/ASTloop-10349', phone_code='1', phone_number='_phone_number_', call_time='2017-04-27 11:24:18', call_type='IN', stage='LIVE-0', queue_priority='99' ;|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|1|SELECT count(*) from vicidial_auto_calls where status = 'LIVE' and campaign_id='TMP_IN';|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|1|UPDATE vicidial_auto_calls SET queue_position='1' WHERE auto_call_id='439967';|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log SET lead_id='36516242', campaign_id='TMP_IN', call_date='2017-04-27 11:24:18', start_epoch='1493285058', status='QUEUE', phone_code='1', phone_number='_phone_number_', user='VDCL', processed='N', xfercallid='26', uniqueid='1493285058.11', queue_position='1' ;|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|-- VDCL : |36516242|26|1421|insert to vicidial_closer_log
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|-- ENTER QUEUE VLE insert: |1|
|INSERT INTO vicidial_log_extended set uniqueid='1493285058.11',server_ip='192.168.1.220',call_date='2017-04-27 11:24:18',lead_id = '36516242',caller_code='Y4271124180036516242',custom_call_id='';|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_time < "2017-04-27 11:24:18" and lead_id != '36516242' and queue_priority >= '99' and agent_only='';|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '36516242' and agent_only='' and ( (queue_priority > '99') or (queue_priority = '99' and call_time < "2017-04-27 11:24:18") );|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|_USER_|2017-04-27 11:23:01|SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_ring_time FROM vicidial_live_agents where status IN('CLOSER','READY') and lead_id<1 and campaign_id IN('TMP') and closer_campaigns LIKE "% TMP_IN %" and last_update_time > '20170427112413' and vicidial_live_agents.user NOT IN('','') order by vicidial_live_agents.last_state_change limit 1;|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|-9|1|1|1||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|-- VDCL XFER REMOTE: |1|update of vac table: Y4271124180036516242
|UPDATE vicidial_auto_calls set status='CLOSER', stage='CLOSER-0' where callerid='Y4271124180036516242';|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|-- VDXL vicidial_xfer_log update: |1|36516242|_USER_
|UPDATE vicidial_xfer_log set closer='_USER_' where lead_id = '36516242' order by call_date desc limit 1;|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|-- closer log : |1|update of vcl table: 36516242
|UPDATE vicidial_closer_log set user='_USER_' where lead_id='36516242' order by call_date desc limit 1;|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|exiting VDAD app, transferring call to 192*168*001*220*8600051
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi||SELECT calls_today from vicidial_inbound_group_agents WHERE user='_USER_' and group_id='TMP_IN';|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|-- VDLIA agent calls: |2|_USER_|TMP_IN|
2017-04-27 11:24:18|11:24:28|agi-VDAD_ALL_inbound.agi|-- VDCL vcl update: |1|36516242|
|UPDATE vicidial_closer_log set queue_seconds='0' where lead_id = '36516242' and call_date='2017-04-27 11:24:18';|
2017-04-27 11:24:28|11:24:28|agi-VDAD_ALL_inbound.agi|XXXXX VDAD transferred: start|stop 2017-04-27 11:24:18|2017-04-27 11:24:28|192*168*001*220*8600051

by **mflorell** » Thu Apr 27, 2017 5:40 am

The problem is that if you set Drop Call Seconds to 0, the system thinks it is unset, so it will default to 9 seconds. Try changing it to '-1'.

by **davide.filippi** » Thu Apr 27, 2017 5:55 am

Done.
This reduces the time but the voice ever start after few seconds.
I have to setup only the ingroup - Music On Hold Context field, right? not the welcome message

by **mflorell** » Thu Apr 27, 2017 10:03 am

correct. The welcome message is blocking, meaning that the call can't be sent to an agent while it's playing, so using Music on Hold only is better.

by **davide.filippi** » Thu Apr 27, 2017 12:44 pm

Ok Thank you.
I have another question but I think this is the wrong section.
When a customer in wait close the call, in my agent vicidial web interface i see the red write "call in queue=1". If the customer close the call and an agent become available, the close call is passed to that agent anyway. How can I avoid this?

by **mflorell** » Thu Apr 27, 2017 12:47 pm

A call will not go to an agent if the customer has hung up. The AGI script will terminate as soon as the customer hangs up. Although, we have seen carriers that delayed the sending of the hangup signal, and there is nothing we can do about that.

by **davide.filippi** » Thu Apr 27, 2017 12:57 pm

Ok thank you so much

by **davide.filippi** » Wed May 03, 2017 12:26 pm

When I test this configuration, sometimes i hear the moh after 3 seconds and sometimes after 5-7.
Also i hear a "ding" when I answer and after 3 - 7 seconds i hear the moh.
Is there any way to disable this "ding" sound? Why this gap between the ding and the moh?

by **mflorell** » Wed May 03, 2017 12:30 pm

you would have to post the debug output as you had above if you want any feedback as to reasons why it is happening.

by **davide.filippi** » Tue May 09, 2017 4:24 am

This is what i get from cli

[May 9 11:14:08] -- Executing [49639_CUSTPHONENUMBER_@default:1] AGI("Local/49639_CUSTPHONENUMBER_@default-56ef,2", "agi://127.0.0.1:4577/call_log") in new stack
[May 9 11:14:08] -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
[May 9 11:14:08] -- Executing [49639_CUSTPHONENUMBER_@default:2] Dial("Local/49639_CUSTPHONENUMBER_@default-56ef,2", "sip/39_CUSTPHONENUMBER_@_PROVIDERSERVERIP_|60|Tto") in new stack
[May 9 11:14:18] -- Called 39_CUSTPHONENUMBER_@_PROVIDERSERVERIP_
[May 9 11:14:21] -- SIP/_PROVIDERSERVERIP_-00000001 is making progress passing it to Local/49639_CUSTPHONENUMBER_@default-56ef,2
[May 9 11:14:31] -- SIP/_PROVIDERSERVERIP_-00000001 answered Local/49639_CUSTPHONENUMBER_@default-56ef,2
[May 9 11:14:31] > Channel Local/49639_CUSTPHONENUMBER_@default-56ef,1 was answered.
[May 9 11:14:31] -- Executing [8368@default:1] Playback("Local/49639_CUSTPHONENUMBER_@default-56ef,1", "sip-silence") in new stack
[May 9 11:14:31] == Manager 'sendcron' logged off from 127.0.0.1
[May 9 11:14:31] -- <Local/49639_CUSTPHONENUMBER_@default-56ef,1> Playing 'sip-silence' (language 'en')
[May 9 11:14:31] WARNING[2713]: file.c:1297 waitstream_core: Unexpected control subclass '-1'
[May 9 11:14:31] -- Executing [8368@default:2] AGI("Local/49639_CUSTPHONENUMBER_@default-56ef,1", "agi://127.0.0.1:4577/call_log") in new stack
[May 9 11:14:31] -- AGI Script agi://127.0.0.1:4577/call_log completed, returning 0
[May 9 11:14:31] -- Executing [8368@default:3] AGI("Local/49639_CUSTPHONENUMBER_@default-56ef,1", "agi-VDAD_ALL_outbound.agi|NORMAL-----LB") in new stack
[May 9 11:14:31] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_outbound.agi
[May 9 11:14:32] -- Executing [h@default:1] DeadAGI("Local/49639_CUSTPHONENUMBER_@default-56ef,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----24-----1") in new stack
[May 9 11:14:32] -- AGI Script agi-VDAD_ALL_outbound.agi completed, returning 0
[May 9 11:14:32] -- Executing [8368@default:4] AGI("SIP/_PROVIDERSERVERIP_-00000001", "agi-VDAD_ALL_outbound.agi|NORMAL-----LB") in new stack
[May 9 11:14:32] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_outbound.agi
[May 9 11:14:33] -- Playing 'ding' (escape_digits=) (sample_offset 0)
[May 9 11:14:33] -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... --24-----1 completed, returning 0
[May 9 11:14:33] == Spawn extension (default, 49639_CUSTPHONENUMBER_, 2) exited non-zero on 'Local/49639_CUSTPHONENUMBER_@default-56ef,2'
[May 9 11:14:34] -- AGI Script agi-VDAD_ALL_outbound.agi completed, returning 0
[May 9 11:14:34] -- Executing [90009*TMP_IN**37314985**_CUSTPHONENUMBER_**@default:1] Answer("SIP/_PROVIDERSERVERIP_-00000001", "") in new stack
[May 9 11:14:34] -- Executing [90009*TMP_IN**37314985**_CUSTPHONENUMBER_**@default:2] Dial("SIP/_PROVIDERSERVERIP_-00000001", "IAX2/ASTloop:wPg4UDaLBeHvpB4@127.0.0.1:40569/990009*TMP_IN**37314985**_CUSTPHONENUMBER_**||to") in new stack
[May 9 11:14:34] -- Called ASTloop:wPg4UDaLBeHvpB4@127.0.0.1:40569/990009*TMP_IN**37314985**_CUSTPHONENUMBER_**
[May 9 11:14:34] -- Accepting AUTHENTICATED call from 127.0.0.1:
> requested format = alaw,
> requested prefs = (alaw|ulaw|g729),
> actual format = ulaw,
> host prefs = (ulaw),
> priority = mine
[May 9 11:14:34] -- Executing [990009*TMP_IN**37314985**_CUSTPHONENUMBER_**@default:1] Answer("IAX2/ASTloop-2272", "") in new stack
[May 9 11:14:34] -- Executing [990009*TMP_IN**37314985**_CUSTPHONENUMBER_**@default:2] AGI("IAX2/ASTloop-2272", "agi-VDAD_ALL_inbound.agi|CLOSER-----LB-----CL_TESTCAMP-----7275551212-----Closer-----park----------999-----1") in new stack
[May 9 11:14:34] -- Call accepted by 127.0.0.1 (format ulaw)
[May 9 11:14:34] -- Format for call is ulaw
[May 9 11:14:34] -- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi
[May 9 11:14:34] -- IAX2/127.0.0.1:40569-10076 answered SIP/_PROVIDERSERVERIP_-00000001
[May 9 11:14:34] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[May 9 11:14:34] -- Playing 'sip-silence' (escape_digits=) (sample_offset 0)
[May 9 11:14:36] -- Started music on hold, class 'OfficeNoise', on IAX2/ASTloop-2272
[May 9 11:14:40] -- Stopped music on hold on IAX2/ASTloop-2272
[May 9 11:14:40] -- Started music on hold, class 'OfficeNoise', on IAX2/ASTloop-2272
[May 9 11:14:43] -- Stopped music on hold on IAX2/ASTloop-2272
[May 9 11:14:43] -- Started music on hold, class 'OfficeNoise', on IAX2/ASTloop-2272
[May 9 11:14:46] -- Stopped music on hold on IAX2/ASTloop-2272
[May 9 11:14:46] -- Started music on hold, class 'OfficeNoise', on IAX2/ASTloop-2272
[May 9 11:14:49] -- Stopped music on hold on IAX2/ASTloop-2272
[May 9 11:14:49] -- Started music on hold, class 'OfficeNoise', on IAX2/ASTloop-2272
[May 9 11:14:52] -- Stopped music on hold on IAX2/ASTloop-2272
[May 9 11:14:52] -- Started music on hold, class 'OfficeNoise', on IAX2/ASTloop-2272
[May 9 11:14:55] -- Stopped music on hold on IAX2/ASTloop-2272
[May 9 11:14:55] -- Started music on hold, class 'OfficeNoise', on IAX2/ASTloop-2272
[May 9 11:14:56] -- Executing [h@default:1] DeadAGI("SIP/_PROVIDERSERVERIP_-00000001", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----23-----22") in new stack
[May 9 11:14:56] -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... -23-----22 completed, returning 0
[May 9 11:14:56] -- Hungup 'IAX2/127.0.0.1:40569-10076'
[May 9 11:14:56] == Spawn extension (default, 90009*TMP_IN**37314985**_CUSTPHONENUMBER_**, 2) exited non-zero on 'SIP/_PROVIDERSERVERIP_-00000001'
[May 9 11:14:56] -- Stopped music on hold on IAX2/ASTloop-2272
[May 9 11:14:56] == Spawn extension (default, 990009*TMP_IN**37314985**_CUSTPHONENUMBER_**, 2) exited non-zero on 'IAX2/ASTloop-2272'
[May 9 11:14:56] -- Executing [h@default:1] DeadAGI("IAX2/ASTloop-2272", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16---------------") in new stack
[May 9 11:14:56] -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ---------- completed, returning 0
[May 9 11:14:56] -- Hungup 'IAX2/ASTloop-2272'

and this is what i get from the agiout file
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi|Perl Environment Dump:
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi|0|NORMAL-----LB
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi|callerID changed: V5091114080037314985
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi|AGI Environment Dump:
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- accountcode =
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- callerid = 39_MYCLI_
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- calleridname = V5091114080037314985
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- callingani2 = 0
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- callingpres = 0
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- callingtns = 0
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- callington = 0
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- channel = Local/49639_CUSTPHONENUMBER_@default-56ef,1
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- context = default
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- dnid = unknown
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- enhanced = 0.0
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- extension = 8368
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- language = en
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- priority = 3
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- rdnis = unknown
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- request = agi-VDAD_ALL_outbound.agi
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- type = Local
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi| -- uniqueid = 1494321248.2
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi|AGI Variables: |1494321248.2|Local/49639_CUSTPHONENUMBER_@default-56ef,1|8368|Local|V5091114080037314985|V509111408003$
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi|+++++ VDAD START : |37314985|2017-05-09 11:14:31|1.4.44-vici|3|
2017-05-09 11:14:31|agi-VDAD_ALL_outbound.agi|+++++ VDAD START LOCAL CHANNEL: EXITING- 3
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|Perl Environment Dump:
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|0|NORMAL-----LB
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|callerID changed: V5091114080037314985
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|AGI Environment Dump:
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- accountcode =
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- callerid = unknown
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- calleridname = V5091114080037314985
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- callingani2 = 0
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- callingpres = 0
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- callingtns = 0
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- callington = 0
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- channel = SIP/_PROVIDERSERVERIP_-00000001
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- context = default
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- dnid = unknown
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- enhanced = 0.0
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- extension = 8368
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- language = en
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- priority = 4
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- rdnis = unknown
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- request = agi-VDAD_ALL_outbound.agi
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- type = SIP
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi| -- uniqueid = 1494321248.2
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|AGI Variables: |1494321248.2|SIP/_PROVIDERSERVERIP_-00000001|8368|SIP|V5091114080037314985|V5091114080037314985|4|
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|+++++ VDAD START : |37314985|2017-05-09 11:14:32|1.4.44-vici|4|
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_live_agents where callerid='V5091114080037314985';|
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where callerid='V5091114080037314985' and status IN('LIVE','XFER');|
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|-- VDAD : |1|update of vac table: V5091114080037314985
|UPDATE vicidial_auto_calls set uniqueid='1494321248.2', channel='SIP/_PROVIDERSERVERIP_-00000001',status='LIVE',stage='LIVE-0' where callerid='V509111408003731498$
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi||UPDATE vicidial_list set status='PU' where lead_id='37314985' and status NOT IN('CBHOLD','CALLBK','CBHOLD','QC$
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|-- VDAD vicidial_list PU update: |1|1494321248.2|
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|Preprocess time: |0.046 (1494321273.039090 - 1494321272.993052)|
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,us$
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|-- VDAD : |37314985|37314985|insert to vicidial_log: 1494321248.2
2017-05-09 11:14:32|agi-VDAD_ALL_outbound.agi|-- VDAD VLE insert: |1|
|INSERT INTO vicidial_log_extended set uniqueid='1494321248.2',server_ip='192.168.1.220',call_date='2017-05-09 11:14:32',lead_id = '37314985',caller_code='V5$
2017-05-09 11:14:33|agi-VDAD_ALL_outbound.agi||UPDATE vicidial_log FORCE INDEX(lead_id) set status='DROP',end_epoch='1494321273',length_in_sec='-1',term_reas$
2017-05-09 11:14:33|agi-VDAD_ALL_outbound.agi|-- VDAD vicidial_log update: |1|1494321248.2
2017-05-09 11:14:33|agi-VDAD_ALL_outbound.agi||UPDATE vicidial_list set status='DROP' where lead_id = '37314985';|
2017-05-09 11:14:33|agi-VDAD_ALL_outbound.agi|-- VDAD vicidial_list update: |1|37314985
2017-05-09 11:14:33|agi-VDAD_ALL_outbound.agi|-- VDAD vac record deleted: |1|TMP|
2017-05-09 11:14:33|agi-VDAD_ALL_outbound.agi|exiting the VDAD app, transferring call to 90009*TMP_IN**37314985**_CUSTPHONENUMBER_** default
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|Perl Environment Dump:
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|0|CLOSER-----LB-----CL_TESTCAMP-----7275551212-----Closer-----park----------999-----1
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|callerID changed: "J5091114340037314985 <_CUSTPHONENUMBER_>"
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- accountcode = ASTloop
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- callerid = unknown
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- calleridname = V5091114080037314985
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- callingani2 = 0
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- callingpres = 0
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- callingtns = 0
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- callington = 0
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- channel = IAX2/ASTloop-2272
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- context = default
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- dnid = unknown
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- enhanced = 0.0
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- extension = 990009*TMP_IN**37314985**_CUSTPHONENUMBER_**
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- language = en
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- priority = 2
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- rdnis = unknown
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- request = agi-VDAD_ALL_inbound.agi
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- type = IAX2
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi| -- uniqueid = 1494321274.6
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|AGI Variables: |1494321274.6|IAX2/ASTloop-2272|990009*TMP_IN**37314985**_CUSTPHONENUMBER_**|IAX2|J509111434003$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|+++++ INBOUND CALL VDCL STARTED : |TMP_IN|J5091114340037314985-|2017-05-09 11:14:34
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|DAILY STATS UPDATE TMP_IN|1|UPDATE vicidial_daily_max_stats SET update_time=NOW(),max_inbound='1' where$

2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|-- NANQUE Check: |1|SELECT count(*) FROM vicidial_live_agents where closer_campaigns LIKE "% TMP_IN %"$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi||SELECT campaign_id FROM vicidial_campaigns where active='Y' and campaign_allow_inbound='Y';|37314985|
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|callerID changed: "Y5091114340037314985 <_CUSTPHONENUMBER_>"
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_xfer_log (lead_id,campaign_id,call_date,phone_code,phone_number,user,closer) valu$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|-- VDXL : |37314985|196|insert to vicidial_xfer_log
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|0|SELECT auto_call_id from vicidial_auto_calls where uniqueid='1494321274.6' and server_ip='192.168.1.2$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_auto_calls SET server_ip='192.168.1.220', campaign_id='TMP_IN', status='LIVE', le$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|1|SELECT count(*) from vicidial_auto_calls where status = 'LIVE' and campaign_id='TMP_IN';|
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|1|UPDATE vicidial_auto_calls SET queue_position='1' WHERE auto_call_id='110041';|
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi||INSERT INTO vicidial_closer_log SET lead_id='37314985', campaign_id='TMP_IN', call_date='2017-05-09 11$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|-- VDCL : |37314985|196|1640|insert to vicidial_closer_log
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|-- ENTER QUEUE VLE insert: |1|
|INSERT INTO vicidial_log_extended set uniqueid='1494321274.6',server_ip='192.168.1.220',call_date='2017-05-09 11:14:34',lead_id = '37314985',caller_code='Y5$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0|-9|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.25|-8|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:34|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.5|-7|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|0.75|-6|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1|-5|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.25|-4|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:35|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.5|-3|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|1.75|-2|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|2|-1|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:36|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:37|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:37|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:37|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:37|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|3|0|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:37|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:37|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:38|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:38|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:38|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:38|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|4|1|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:38|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:38|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:39|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:39|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:39|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:39|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|5|2|1|0|0||0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:39|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:39|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:39|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20170509111440|Y5091114340037314985|,call_time='2017-05-09 11:14:39'|
2017-05-09 11:14:34|11:14:39|agi-VDAD_ALL_inbound.agi|-- No-Block Prompt Set: |1|2017-05-09 11:14:34|Y5091114340037314985|
2017-05-09 11:14:34|11:14:40|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:40|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:40|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:40|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|6|0|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:40|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:40|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:41|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:41|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:41|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:41|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|7|1|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:41|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:41|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:42|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:42|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:42|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:42|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|8|2|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:42|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:42|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:42|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20170509111443|Y5091114340037314985|,call_time='2017-05-09 11:14:42'|
2017-05-09 11:14:34|11:14:42|agi-VDAD_ALL_inbound.agi|-- No-Block Prompt Set: |1|2017-05-09 11:14:34|Y5091114340037314985|
2017-05-09 11:14:34|11:14:43|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:43|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:43|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:43|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|9|0|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:43|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:43|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:44|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:44|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:44|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:44|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|10|1|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:44|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:44|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:45|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:45|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:45|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:45|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|11|2|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:45|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:45|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:45|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20170509111446|Y5091114340037314985|,call_time='2017-05-09 11:14:45'|
2017-05-09 11:14:34|11:14:45|agi-VDAD_ALL_inbound.agi|-- No-Block Prompt Set: |1|2017-05-09 11:14:34|Y5091114340037314985|
2017-05-09 11:14:34|11:14:46|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:46|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:46|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:46|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|12|0|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:46|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:46|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:47|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:47|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:47|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:47|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|13|1|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:47|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:47|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:48|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:48|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:48|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:48|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|14|2|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:48|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:48|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:48|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20170509111449|Y5091114340037314985|,call_time='2017-05-09 11:14:48'|
2017-05-09 11:14:34|11:14:48|agi-VDAD_ALL_inbound.agi|-- No-Block Prompt Set: |1|2017-05-09 11:14:34|Y5091114340037314985|
2017-05-09 11:14:34|11:14:49|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:49|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:49|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:49|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|15|0|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:49|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:49|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:50|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:50|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:50|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:50|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|16|1|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:50|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:50|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:51|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:51|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:51|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:51|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|17|2|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:51|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:51|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:51|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20170509111452|Y5091114340037314985|,call_time='2017-05-09 11:14:51'|
2017-05-09 11:14:34|11:14:51|agi-VDAD_ALL_inbound.agi|-- No-Block Prompt Set: |1|2017-05-09 11:14:34|Y5091114340037314985|
2017-05-09 11:14:34|11:14:52|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:52|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:52|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:52|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|18|0|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:52|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:52|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:53|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:53|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:53|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:53|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|19|1|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:53|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:53|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:54|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:54|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:54|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:54|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|20|2|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:54|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:54|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset
2017-05-09 11:14:34|11:14:54|agi-VDAD_ALL_inbound.agi|-- VDAC posttime record: |1|20170509111455|Y5091114340037314985|,call_time='2017-05-09 11:14:54'|
2017-05-09 11:14:34|11:14:54|agi-VDAD_ALL_inbound.agi|-- No-Block Prompt Set: |1|2017-05-09 11:14:34|Y5091114340037314985|
2017-05-09 11:14:34|11:14:55|agi-VDAD_ALL_inbound.agi|0|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and campaign_id = 'TMP_IN' and call_$
2017-05-09 11:14:34|11:14:55|agi-VDAD_ALL_inbound.agi|0|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and lead_id != '37314985' and agent_on$
2017-05-09 11:14:34|11:14:55|agi-VDAD_ALL_inbound.agi|||SELECT conf_exten,user,extension,server_ip,last_call_time,ra_user,campaign_id,on_hook_agent,on_hook_r$
2017-05-09 11:14:34|11:14:55|agi-VDAD_ALL_inbound.agi|-- VDAD get agent: |360|21|0|1|0|0|0|0|update of vla table: TMP_IN|
|UNLOCK TABLES;|
2017-05-09 11:14:34|11:14:55|agi-VDAD_ALL_inbound.agi|NNNNN No available balance agent found
2017-05-09 11:14:34|11:14:55|agi-VDAD_ALL_inbound.agi|ring_no_answer_agents reset

by **mflorell** » Wed May 10, 2017 6:33 am

I looked through the code and put the log events into context:

Looks like it took 1 second for your carrier to start sending audio(Local/ channel resolution), it took a little over 1 second to update the vicidial_log and vicidial_list tables, it took 1 second to play the ding and launch the inbound process, then there is a minimum of a 2 second delay in MoH starting so that the call can try to route to an agent right away, this also reduces load on busy systems. That delay is increased by 1 second if options like estimated hold time, hold time features, wait time features or play place in line are enabled.

Music on hold seems to be starting and stopping every 3 seconds in your example, which is horrible, you should probably raise the On Hold Prompt Interval up to 60 seconds, you had said earlier you set it to 1.

MoH is not designed to be started right away, this is due to the inbound process trying every quarter-second to find an agent to send the call to during the first two seconds. After that is over, then it will start MoH.

Other than making some major programming changes, you could speed everything up by, rolling your logs, reducing the number of leads in vicidial_list, and manually commenting out where the 'ding' audio file is played in the outbound process.

by **davide.filippi** » Wed May 10, 2017 7:37 am

Can I do this task with a custom dialplan? If so, can you link me some example?

by **mflorell** » Wed May 10, 2017 9:25 am

Not if you want to call to be routed to an agent.

by **davide.filippi** » Mon May 15, 2017 4:22 am

Ok.
What about the previous post?

by **davide.filippi** » Wed May 24, 2017 3:49 am

I need an answer, please

by **mflorell** » Wed May 24, 2017 5:40 am

An answer to what exactly, you've asked a dozen questions here.

by **davide.filippi** » Wed May 24, 2017 10:57 am

You have right.
The question is: Why the music on hold start after few seconds from the answer? I need to avoid mute call since the called party answer the phone

by **mflorell** » Wed May 24, 2017 11:51 am

It's a load consideration. For most call centers, most calls are answered quickly, and starting up music on hold for 1-2 seconds adds a lot of load to the server compared to leaving it in silence as it tries to find an agent. Then after a couple seconds if no agent is found, it will start MoH. I'm sure this delay could be removed, but it would take some work to do it properly.

by **davide.filippi** » Thu May 25, 2017 3:44 am

Can you link me some tutorial or explain me in general?
Anyway I have delay also with only 1 call

vicidial.org

Play custom sound during "Drop Call Seconds"

Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Re: Play custom sound during "Drop Call Seconds"

Who is online