- ACTIVE: Y
- DIAL METHOD: INBOUND MANUAL
- LOCAL CALL TIME: 24hours - default 24 hours calling
This campaign has 40872 leads to be dialed in those lists - HIDE
This campaign has 0 leads in the dial hopper
perl /usr/share/astguiclient/AST_VDhopper.pl --campaign=MAILDROP --debug
----- 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 < "2023-12-21") ) ) and (campaign_id IN('MAILDROP') ) );Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2023-12-21 17:06:52' and status IN('ACTIVE','TFHCCL') and campaign_id IN('MAILDROP') ;|
hopper DNC count: 0
---------------Auto Hopper Level Enabled For MAILDROP---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 1
Dial Timeout = 60
Dial Timeout Multiplier = 1
Auto Hopper Multipier = 1
Minimum Hopper Level = 1
Auto Hopper Level Adjustment = 0
Final Hopper Level = 1
---------------Auto Trim Hopper Enabled For MAILDROP---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 1
CAMPAIGNS TO PROCESS HOPPER FOR: 1|0
Starting hopper run for MAILDROP campaign- GMT: 24hours HOPPER LEVEL: 1 ORDER: DOWN|N|LEAD_ASCEND
hopper READY count: 0
Processing GMT for list 20230508
Processing GMT for list 20231121
Processing GMT for list 20231017
Processing GMT for list 1007
Processing GMT for list 1008
campaign lists count ACTIVE:5 | TOTAL:5
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
no lead filter defined for campaign: MAILDROP
leads to call count: 40872
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
hopper too low (0|1) starting hopper dump
Getting Leads to add to hopper
NO RECYCLE-LEADS INTO HOPPER DEFINED
lead call order: order by lead_id asc
Adding to hopper: 0
SUMMARY: 1 campaigns
MAILDROP 40872 1 0
DONE. Script execution time in seconds: 0
/usr/share/astguiclient/AST_VDhopper.pl -q --debugX
SELECT count(*) from vicidial_hopper where campaign_id='MAILDROP' and status='READY';|
Processing GMT for list 20230508
Processing GMT for list 20231121
Processing GMT for list 20231017
Processing GMT for list 1007
Processing GMT for list 1008
campaign lists count ACTIVE:5 | TOTAL:5
LIST ID SQL (list_id IN('20230508','20231121','20231017','1007','1008')) |SELECT count(*) from vicidial_hopper where campaign_id='MAILDROP' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='MAILDROP' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='MAILDROP' and ((gmt_offset_now NOT IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ));|
no lead filter defined for campaign: MAILDROP
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('20230508','20231121','20231017','1007','1008'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
leads to call count: 40872
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('20230508','20231121','20231017','1007','1008'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
hopper too low (0|1) starting hopper dump
Getting Leads to add to hopper
|SELECT lead_id,vendor_lead_code FROM vicidial_hopper where campaign_id='MAILDROP';|
NO RECYCLE-LEADS INTO HOPPER DEFINED
lead call order: order by lead_id asc
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user,vendor_lead_code,phone_code,postal_code FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('20230508','20231121','20231017','1007','1008'))) and lead_id NOT IN('0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) and list_id not in ('20230508', '20230508', '20231017', '20231121', '20230508', '5010', '5010', '5010', '5010', '5003', '5003', '5005', '5005', '5003', '5004', '5003', '5003', '5003', '5010', '5004', '5003', '5003') order by lead_id asc limit 1;|
Adding to hopper: 0
vicidial_campaign_stats_debug UPDATE: 1|UPDATE vicidial_campaign_stats_debug SET entry_time='2023-12-21 17:12:59',debug_output="Starting hopper run for MAILDROP campaign- GMT: 24hours HOPPER LEVEL: 1 ORDER: DOWN|N|LEAD_ASCEND
Hopper Ready count: 0 Local Call Time: 24hours
campaign lists count ACTIVE: 5 | TOTAL: 5
leads to call count: 40872
hopper too low (0|1) starting hopper dump
Recycle leads to insert into the hopper: 0
" where campaign_id='MAILDROP' and server_ip='HOPPER';|
I RAN THIS QUERY ON THE DATABASE:
SELECT
lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user,vendor_lead_code,phone_code,postal_code
FROM vicidial_list
FORCE INDEX(list_id)
WHERE called_since_last_reset='N' AND
status IN('NEW') AND
((list_id IN('20230508','20231121','20231017','1007','1008'))) AND
lead_id NOT IN('0') AND
((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) AND
list_id not in ('20230508', '20230508', '20231017', '20231121', '20230508', '5010', '5010', '5010', '5010', '5003', '5003', '5005', '5005', '5003', '5004', '5003', '5003', '5003', '5010', '5004', '5003', '5003')
order by lead_id asc
limit 100;
AND THIS PART IS CAUSING THE ISSUE:
list_id not in ('20230508', '20230508', '20231017', '20231121', '20230508', '5010', '5010', '5010', '5010', '5003', '5003', '5005', '5005', '5003', '5004', '5003', '5003', '5003', '5010', '5004', '5003', '5003')
Any help please ????