Page 1 of 1

scratch install:This campaign has 0 leads in the dial hopper

PostPosted: Sun Mar 30, 2014 11:14 pm
by shirker
Hello everyone!
I hope, someone could help me out on this. Some "magic fix"

The system: desktop PC, Intel Dual core Celeron, Centos 6.5 x64
Additional hardware: openvox g400p. works over chan_extra pretty well
Installation method: http://ray-solomon.com/vicidial.html, followed step by step except ftp server
VERSION: 2.8-431a
BUILD: 140314-1134

screen -ls:
[root@gsm-gateway ~]# screen -ls
Code: Select all
There are screens on:
        2223.ASTfastlog (Detached)
        3362.ASTemail   (Detached)
        3943.ASTlisten  (Detached)
        3365.ASTconf3way        (Detached)
        3937.ASTupdate  (Detached)
        3356.ASTVDadapt (Detached)
        3946.ASTVDauto  (Detached)
        3949.ASTVDremote        (Detached)
        3940.ASTsend    (Detached)
        3359.ASTVDautoFILL      (Detached)
10 Sockets in /var/run/screen/S-root.


/usr/share/astguiclient/AST_VDhopper.pl --debugX :
Code: Select all
----- DEBUG -----


----- SUPER DEBUG -----

TIME DEBUG: -5.00|-5.00|0|   GMT: 16:48
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2014-03-31") ) );Inactive Lists:  2
Inactive and Expired List Leads Deleted:  0E0 |DELETE from vicidial_hopper where list_id IN('999','998');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2014-03-31 11:48:39' and status='ACTIVE';|
     hopper DNC count:   0
     |SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Trim Hopper Enabled For GLBCOLD1---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 500

CAMPAIGNS TO PROCESSES HOPPER FOR:  2|1
Campaign TEST1 set to no-hopper-dialing: Y
NO HOPPER COUNT: 0|SELECT count(*) FROM vicidial_hopper where campaign_id='TEST1' and status NOT IN('QUEUE','HOLD');|
Campaign GLBCOLD1 set to no-hopper-dialing: Y
NO HOPPER COUNT: 0|SELECT count(*) FROM vicidial_hopper where campaign_id='GLBCOLD1' and status NOT IN('QUEUE','HOLD');|
DONE. Script execution time in seconds: 0


GLBCOLD1 campaign's call time set as 24 hours. There are 2 active agents. The campaign is active and the list as well

Code: Select all
"This campaign has 179 leads to be dialed in those lists - HIDE

This campaign has 0 leads in the dial hopper"

All leads are 'NEW', as well 'NEW' leds are allowed to dial.

BUT! no one lead comes to the hopper... As well I did mysqlcheck for several times. hopper table is empty :evil:

Is there a way to "force" send leads to the hopper?

PS In campaign settings->Detail tab there is a weird notice: "State rules defined for this call time: -1" right below to "Local Call Time" field. Not sure, if it somehow related to the issue...

Re: scratch install:This campaign has 0 leads in the dial ho

PostPosted: Mon Mar 31, 2014 4:12 am
by shirker
Even more strange... :(

AST_VDhopper.pl is actually erasing leads from hopper, that im trying to add manually..

Code: Select all
mysql> insert into vicidial_hopper (lead_id,campaign_id,status,list_id,gmt_offset_now) select lead_id,'GLBCOLD1','READY','100001','08:00' from vicidial_list where list_id='100001';


Code: Select all
# /usr/share/astguiclient/AST_VDhopper.pl --debugX

----- DEBUG -----


----- SUPER DEBUG -----

TIME DEBUG: -5.00|-5.00|0|   GMT: 22:06
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2014-03-31") ) );Inactive Lists:  2
Inactive and Expired List Leads Deleted:  0E0 |DELETE from vicidial_hopper where list_id IN('999','998');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2014-03-31 17:06:34' and status='ACTIVE';|
     hopper DNC count:   0
     |SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Trim Hopper Enabled For GLBCOLD1---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 500

CAMPAIGNS TO PROCESSES HOPPER FOR:  2|1
Campaign TEST1 set to no-hopper-dialing: Y
NO HOPPER COUNT: 0|SELECT count(*) FROM vicidial_hopper where campaign_id='TEST1' and status NOT IN('QUEUE','HOLD');|
Campaign GLBCOLD1 set to no-hopper-dialing: Y
NO HOPPER COUNT: 179|SELECT count(*) FROM vicidial_hopper where campaign_id='GLBCOLD1' and status NOT IN('QUEUE','HOLD');|
No Hopper delete:  179
DONE. Script execution time in seconds: 0


why these leads are considered as "NO HOPPER COUNT: 179" and wiped out?

Re: scratch install:This campaign has 0 leads in the dial ho

PostPosted: Mon Mar 31, 2014 8:32 am
by shirker
Sorry, guys, my mistake! I set "No Hopper Dialing" to Y
I was thinking that this option will allow manual dialing even hopper is empty, but it completely turns off the hopper for the campaign

please close the thread