vicidial.org

Hello recently i load the leads and when i see the real time report it doesn`t show leads in hopper, it is strange because the leads was loaded.

have i to make something a refresh to see the information upload in the leads hopper.

I executed this command in the CLI

/usr/share/astguiclient/AST_VDhopper.pl --debugX
SUMMARY: 2 campaigns
20000444 0 500 0
20000445 0 500 0
DONE. Script execution time in seconds: 0


openSUSE Leap 42.3 | Asterisk 11.25.3-vici | VERSION: 2.14-751a BUILD: 200425-0949 | mysql Ver 15.1 Distrib 10.1.25-MariaDB | Apache/2.4.23

try adding the --campaign=CampName trigger and show me the logs from the whole process

This is detail of the debug

/usr/share/astguiclient/AST_VDhopper.pl --campaing=20000444 --debugX

----- DEBUG -----


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

TIME DEBUG: -5.00|-5.00|0| GMT: 14:47
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2021-01-16") ) );Inactive Lists: 25
Inactive and Expired List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','2001501','2001502','2001503','2001504','2001505','2001506','2001507','2001508','2001509','2001510','2001511','2001512','2001515','2001514','2001513','2001516','2001517','2001518','2001519','2001520','2001521','2001522','2001525') ;|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2021-01-16 09:47:09' and status='ACTIVE' ;|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Hopper Level Enabled For 20000446---------------------
Number of Agents = 16
Number of Paused Agents = 1
Auto Dial Level = 3.0
Dial Timeout = 25
Dial Timeout Multiplier = 2.4
Auto Hopper Multipier = 1
Minimum Hopper Level = 500
Auto Hopper Level Adjustment = 123
Final Hopper Level = 500

---------------Auto Trim Hopper Enabled For 20000446---------------------
Leads in Hopper for this Campaign = 973
Hopper Level for this Campaign = 500

CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0

Starting hopper run for 20000446 campaign- GMT: 24hours HOPPER: 500 ORDER: DOWN|Y|LEAD_ASCEND

|GMT-DAY-HOUR| |13.00-0-347||12.75-0-332||12.50-0-317||12.25-0-302||12.00-0-247||11.75-0-232||11.50-0-217||11.25-0-202||11.00-0-147||10.75-0-132||10.50-0-117||10.25-0-102||10.00-0-47||9.75-0-32||9.50-0-17||9.25-0-2||9.00-6-2347||8.75-6-2332||8.50-6-2317||8.25-6-2302||8.00-6-2247||7.75-6-2232||7.50-6-2217||7.25-6-2202||7.00-6-2147||6.75-6-2132||6.50-6-2117||6.25-6-2102||6.00-6-2047||5.75-6-2032||5.50-6-2017||5.25-6-2002||5.00-6-1947||4.75-6-1932||4.50-6-1917||4.25-6-1902||4.00-6-1847||3.75-6-1832||3.50-6-1817||3.25-6-1802||3.00-6-1747||2.75-6-1732||2.50-6-1717||2.25-6-1702||2.00-6-1647||1.75-6-1632||1.50-6-1617||1.25-6-1602||1.00-6-1547||0.75-6-1532||0.50-6-1517||0.25-6-1502||0.00-6-1447||-0.25-6-1432||-0.50-6-1417||-0.75-6-1402||-1.00-6-1347||-1.25-6-1332||-1.50-6-1317||-1.75-6-1302||-2.00-6-1247||-2.25-6-1232||-2.50-6-1217||-2.75-6-1202||-3.00-6-1147||-3.25-6-1132||-3.50-6-1117||-3.75-6-1102||-4.00-6-1047||-4.25-6-1032||-4.50-6-1017||-4.75-6-1002||-5.00-6-947||-5.25-6-932||-5.50-6-917||-5.75-6-902||-6.00-6-847||-6.25-6-832||-6.50-6-817||-6.75-6-802||-7.00-6-747||-7.25-6-732||-7.50-6-717||-7.75-6-702||-8.00-6-647||-8.25-6-632||-8.50-6-617||-8.75-6-602||-9.00-6-547||-9.25-6-532||-9.50-6-517||-9.75-6-502||-10.00-6-447||-10.25-6-432||-10.50-6-417||-10.75-6-402||-11.00-6-347||-11.25-6-332||-11.50-6-317||-11.75-6-302||-12.00-6-247||-12.25-6-232||-12.50-6-217||-12.75-6-202|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|6|5|
hopper READY count: 974
|SELECT count(*) from vicidial_hopper where campaign_id='20000446' and status='READY';|
Processing GMT for list 2001515
Processing GMT for list 2001514
Processing GMT for list 2001513
Processing GMT for list 2001516
Processing GMT for list 2001517
Processing GMT for list 2001518
Processing GMT for list 2001519
Processing GMT for list 2001520
Processing GMT for list 2001521
Processing GMT for list 2001522
Processing GMT for list 2001523
Processing GMT for list 2001524
Processing GMT for list 2001525
campaign lists count ACTIVE:2 | TOTAL:13
LIST ID SQL (list_id IN('2001523','2001524')) |SELECT count(*) from vicidial_hopper where campaign_id='20000446' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='20000446' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='20000446' 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: 20000446
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('PDROP','02','DROP','B','AA','A','NA','N','ADC','NEW') and ((list_id IN('2001523','2001524'))) 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: 3369
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('PDROP','02','DROP','B','AA','A','NA','N','ADC','NEW') and ((list_id IN('2001523','2001524'))) 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
CAMPAIGN STATS: 1|UPDATE vicidial_campaign_stats SET dialable_leads='3369' where campaign_id='20000446';|

SUMMARY: 1 campaigns
20000446 3369 500 974
DONE. Script execution time in seconds: 0

that is showing leads in the hopper, so thats not the issue. What exactly are you doing? step by step so i can better understand your issue

To be sincere I didn´t make change and nothing because I don´t have the responsibility to make that task but I am part of the support team. The person with responsibility doesn´t explain exactly what happened.

I found information on internet and I found this and was of much help https://striker24x7.blogspot.com/2012/1 ... -dial.html

But while I have searching the solution I saw something about the scripts in /usr/share/astguiclient/. I wanted to run one of that scripts but I not had clear what was it real function

VIVICIDIAL_DEDUPE_leads.pl
VICIDIAL_fix_list_statuses.pl
VICIDIAL_rebuild_list_statuses.pl
VICIDIAL_UPDATE_leads_status_file.pl

yes striker is a member of this community that is very knowledgeable and knows his shit. Those files are used via other .php pages throughout the system, they are not for individual use.

As far as no leads, can you show me a screen shot of the error your having?

In case it helps: Be sure you are not loading leads into the hopper that are on your DNC list. Most importantly: Do not add DNC as a Dial Status. This can cause leads to be loaded, and then removed because they are DNC. But then they can get loaded again (because they are due for a call, but not yet called, and then deleted again ... eventually accumulating to the point that the dialer "grinds to a halt" when enough DNC leads collect as "next to be dialed". This can be particularly annoying when the sort order is not Random since any other method will have an order, and once they are "next up", they will continually get loaded by one process and dumped by another.

carpenox wrote:yes striker is a member of this community that is very knowledgeable and knows his shit. Those files are used via other .php pages throughout the system, they are not for individual use.

As far as no leads, can you show me a screen shot of the error your having?

carpenox the error was visualize when the list was charge and it can`t showed on the LEADS IN HOPPER



I followed the steps dictated by strike and i could solve the issue. In the image state i colored with yellow the section, when I had the problem this section had 0 lead in hopper.

im glad it worked out for you, i told u striker knows his shit :-p

carpenox wrote:im glad it worked out for you, i told u striker knows his shit :-p

Carpenox I have the issue again with the hopper, i made other debug and I am seeing this, I execute the steps recommended by strike but i don´r know what happen

mfvicipilot05pri:/var/log/astguiclient # /usr/share/astguiclient/AST_VDhopper.pl --debugX --campaing='20000446'

----- DEBUG -----


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

TIME DEBUG: -5.00|-5.00|0| GMT: 14:46
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2021-01-28") ) );Inactive Lists: 45
Inactive and Expired List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','2001502','2001503','2001504','2001505','2001506','2001515','2001514','2001513','2001516','2001517','2001518','2001519','2001520','2001521','2001522','2001523','2001524','2001525','2001526','2001527','2001528','2001529','2001530','2001531','2001532','2001533','2001534','2001535','2001536','2001537','2001538','2001539','2001540','2001541','2001542','2001543','2001544','2001545','2001546','2001547','2001554','2001552','2001553') ;|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2021-01-28 09:46:27' and status='ACTIVE' ;|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Hopper Level Enabled For 20000446---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 4.500
Dial Timeout = 25
Dial Timeout Multiplier = 2.4
Auto Hopper Multipier = 1
Minimum Hopper Level = 500
Auto Hopper Level Adjustment = 0
Final Hopper Level = 500

---------------Auto Trim Hopper Enabled For 20000446---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 500

---------------Auto Hopper Level Enabled For 20000447---------------------
Number of Agents = 5
Number of Paused Agents = 5
Auto Dial Level = 3.0
Dial Timeout = 25
Dial Timeout Multiplier = 2.4
Auto Hopper Multipier = 1
Minimum Hopper Level = 500
Auto Hopper Level Adjustment = 72
Final Hopper Level = 500

---------------Auto Trim Hopper Enabled For 20000447---------------------
Leads in Hopper for this Campaign = 504
Hopper Level for this Campaign = 500

CAMPAIGNS TO PROCESSES HOPPER FOR: 2|1

Starting hopper run for 20000446 campaign- GMT: 24hours HOPPER: 500 ORDER: DOWN|Y|LEAD_ASCEND

|GMT-DAY-HOUR| |13.00-5-346||12.75-5-331||12.50-5-316||12.25-5-301||12.00-5-246||11.75-5-231||11.50-5-216||11.25-5-201||11.00-5-146||10.75-5-131||10.50-5-116||10.25-5-101||10.00-5-46||9.75-5-31||9.50-5-16||9.25-5-1||9.00-4-2346||8.75-4-2331||8.50-4-2316||8.25-4-2301||8.00-4-2246||7.75-4-2231||7.50-4-2216||7.25-4-2201||7.00-4-2146||6.75-4-2131||6.50-4-2116||6.25-4-2101||6.00-4-2046||5.75-4-2031||5.50-4-2016||5.25-4-2001||5.00-4-1946||4.75-4-1931||4.50-4-1916||4.25-4-1901||4.00-4-1846||3.75-4-1831||3.50-4-1816||3.25-4-1801||3.00-4-1746||2.75-4-1731||2.50-4-1716||2.25-4-1701||2.00-4-1646||1.75-4-1631||1.50-4-1616||1.25-4-1601||1.00-4-1546||0.75-4-1531||0.50-4-1516||0.25-4-1501||0.00-4-1446||-0.25-4-1431||-0.50-4-1416||-0.75-4-1401||-1.00-4-1346||-1.25-4-1331||-1.50-4-1316||-1.75-4-1301||-2.00-4-1246||-2.25-4-1231||-2.50-4-1216||-2.75-4-1201||-3.00-4-1146||-3.25-4-1131||-3.50-4-1116||-3.75-4-1101||-4.00-4-1046||-4.25-4-1031||-4.50-4-1016||-4.75-4-1001||-5.00-4-946||-5.25-4-931||-5.50-4-916||-5.75-4-901||-6.00-4-846||-6.25-4-831||-6.50-4-816||-6.75-4-801||-7.00-4-746||-7.25-4-731||-7.50-4-716||-7.75-4-701||-8.00-4-646||-8.25-4-631||-8.50-4-616||-8.75-4-601||-9.00-4-546||-9.25-4-531||-9.50-4-516||-9.75-4-501||-10.00-4-446||-10.25-4-431||-10.50-4-416||-10.75-4-401||-11.00-4-346||-11.25-4-331||-11.50-4-316||-11.75-4-301||-12.00-4-246||-12.25-4-231||-12.50-4-216||-12.75-4-201|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|4|3|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='20000446' and status='READY';|
Processing GMT for list 2001515
Processing GMT for list 2001514
Processing GMT for list 2001513
Processing GMT for list 2001516
Processing GMT for list 2001517
Processing GMT for list 2001518
Processing GMT for list 2001519
Processing GMT for list 2001520
Processing GMT for list 2001521
Processing GMT for list 2001522
Processing GMT for list 2001523
Processing GMT for list 2001524
Processing GMT for list 2001525
Processing GMT for list 2001526
Processing GMT for list 2001527
Processing GMT for list 2001528
Processing GMT for list 2001529
Processing GMT for list 2001530
Processing GMT for list 2001531
Processing GMT for list 2001532
Processing GMT for list 2001533
Processing GMT for list 2001534
Processing GMT for list 2001535
Processing GMT for list 2001536
Processing GMT for list 2001537
Processing GMT for list 2001538
Processing GMT for list 2001539
Processing GMT for list 2001540
Processing GMT for list 2001541
Processing GMT for list 2001542
Processing GMT for list 2001543
Processing GMT for list 2001544
Processing GMT for list 2001545
Processing GMT for list 2001546
Processing GMT for list 2001547
Processing GMT for list 2001548
Processing GMT for list 2001549
Processing GMT for list 2001550
Processing GMT for list 2001551
campaign lists count ACTIVE:4 | TOTAL:39
LIST ID SQL (list_id IN('2001548','2001549','2001550','2001551')) |SELECT count(*) from vicidial_hopper where campaign_id='20000446' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='20000446' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='20000446' 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: 20000446
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('PDROP','DROP','B','AA','A','NA','N','ADC') and ((list_id IN('2001548','2001549','2001550','2001551'))) 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: 0
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('PDROP','DROP','B','AA','A','NA','N','ADC') and ((list_id IN('2001548','2001549','2001550','2001551'))) 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
NO DIALABLE LEADS FOR THIS CAMPAIGN
hopper too low (0|500) starting hopper dump
ERROR CANNOT ADD ANY LEADS TO HOPPER

Starting hopper run for 20000447 campaign- GMT: 24hours HOPPER: 500 ORDER: DOWN|Y|LEAD_ASCEND

|GMT-DAY-HOUR| |13.00-5-346||12.75-5-331||12.50-5-316||12.25-5-301||12.00-5-246||11.75-5-231||11.50-5-216||11.25-5-201||11.00-5-146||10.75-5-131||10.50-5-116||10.25-5-101||10.00-5-46||9.75-5-31||9.50-5-16||9.25-5-1||9.00-4-2346||8.75-4-2331||8.50-4-2316||8.25-4-2301||8.00-4-2246||7.75-4-2231||7.50-4-2216||7.25-4-2201||7.00-4-2146||6.75-4-2131||6.50-4-2116||6.25-4-2101||6.00-4-2046||5.75-4-2031||5.50-4-2016||5.25-4-2001||5.00-4-1946||4.75-4-1931||4.50-4-1916||4.25-4-1901||4.00-4-1846||3.75-4-1831||3.50-4-1816||3.25-4-1801||3.00-4-1746||2.75-4-1731||2.50-4-1716||2.25-4-1701||2.00-4-1646||1.75-4-1631||1.50-4-1616||1.25-4-1601||1.00-4-1546||0.75-4-1531||0.50-4-1516||0.25-4-1501||0.00-4-1446||-0.25-4-1431||-0.50-4-1416||-0.75-4-1401||-1.00-4-1346||-1.25-4-1331||-1.50-4-1316||-1.75-4-1301||-2.00-4-1246||-2.25-4-1231||-2.50-4-1216||-2.75-4-1201||-3.00-4-1146||-3.25-4-1131||-3.50-4-1116||-3.75-4-1101||-4.00-4-1046||-4.25-4-1031||-4.50-4-1016||-4.75-4-1001||-5.00-4-946||-5.25-4-931||-5.50-4-916||-5.75-4-901||-6.00-4-846||-6.25-4-831||-6.50-4-816||-6.75-4-801||-7.00-4-746||-7.25-4-731||-7.50-4-716||-7.75-4-701||-8.00-4-646||-8.25-4-631||-8.50-4-616||-8.75-4-601||-9.00-4-546||-9.25-4-531||-9.50-4-516||-9.75-4-501||-10.00-4-446||-10.25-4-431||-10.50-4-416||-10.75-4-401||-11.00-4-346||-11.25-4-331||-11.50-4-316||-11.75-4-301||-12.00-4-246||-12.25-4-231||-12.50-4-216||-12.75-4-201|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|4|3|
hopper READY count: 504
|SELECT count(*) from vicidial_hopper where campaign_id='20000447' and status='READY';|
Processing GMT for list 2001554
Processing GMT for list 2001552
Processing GMT for list 2001553
Processing GMT for list 2001555
Processing GMT for list 2001556
Processing GMT for list 2001557
campaign lists count ACTIVE:3 | TOTAL:6
LIST ID SQL (list_id IN('2001555','2001556','2001557')) |SELECT count(*) from vicidial_hopper where campaign_id='20000447' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='20000447' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='20000447' 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: 20000447
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('01','NEW','PDROP','02','DROP','B','AA','A','NA','N','ADC') and ((list_id IN('2001555','2001556','2001557'))) 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: 9436
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('01','NEW','PDROP','02','DROP','B','AA','A','NA','N','ADC') and ((list_id IN('2001555','2001556','2001557'))) 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
CAMPAIGN STATS: 1|UPDATE vicidial_campaign_stats SET dialable_leads='9436' where campaign_id='20000447';|

SUMMARY: 2 campaigns
20000446 0 500 0
20000447 9436 500 504
DONE. Script execution time in seconds: 1




I am seeing this in the debug:


no lead filter defined for campaign: 20000446

NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
NO DIALABLE LEADS FOR THIS CAMPAIGN
hopper too low (0|500) starting hopper dump
ERROR CANNOT ADD ANY LEADS TO HOPPER

It looks like the lists in that campaign do not have statuses in PDROP','DROP','B','AA','A','NA','N','ADC' within those timezones, The other campaign loaded fine. Try this command on linux:

/usr/share/astguiclient/AST_VDhopper.pl --campaign=20000446 --wipe-hopper-clean

Let me know if this helps.

-Nox
www.CyburityLLC.com

I executed the instruction and disable the list and reset it, after enable again. Now i have lead


perl AST_VDhopper.pl --campaing=20000446 --debugX

----- DEBUG -----


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

TIME DEBUG: -5.00|-5.00|0| GMT: 21:04
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2021-01-28") ) );Inactive Lists: 45
Inactive and Expired List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','2001502','2001503','2001504','2001505','2001506','2001515','2001514','2001513','2001516','2001517','2001518','2001519','2001520','2001521','2001522','2001523','2001524','2001525','2001526','2001527','2001528','2001529','2001530','2001531','2001532','2001533','2001534','2001535','2001536','2001537','2001538','2001539','2001540','2001541','2001542','2001543','2001544','2001545','2001546','2001547','2001554','2001552','2001553') ;|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2021-01-28 16:04:24' and status='ACTIVE' ;|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Hopper Level Enabled For 20000446---------------------
Number of Agents = 0
Number of Paused Agents = 0
Auto Dial Level = 4.5
Dial Timeout = 25
Dial Timeout Multiplier = 2.4
Auto Hopper Multipier = 1
Minimum Hopper Level = 500
Auto Hopper Level Adjustment = 0
Final Hopper Level = 500

---------------Auto Trim Hopper Enabled For 20000446---------------------
Leads in Hopper for this Campaign = 500
Hopper Level for this Campaign = 500

---------------Auto Hopper Level Enabled For 20000447---------------------
Number of Agents = 4
Number of Paused Agents = 2
Auto Dial Level = 3.0
Dial Timeout = 25
Dial Timeout Multiplier = 2.4
Auto Hopper Multipier = 1
Minimum Hopper Level = 500
Auto Hopper Level Adjustment = 44
Final Hopper Level = 500

---------------Auto Trim Hopper Enabled For 20000447---------------------
Leads in Hopper for this Campaign = 905
Hopper Level for this Campaign = 500

CAMPAIGNS TO PROCESSES HOPPER FOR: 2|1

Starting hopper run for 20000446 campaign- GMT: 24hours HOPPER: 500 ORDER: DOWN|Y|LEAD_ASCEND

|GMT-DAY-HOUR| |13.00-5-1004||12.75-5-949||12.50-5-934||12.25-5-919||12.00-5-904||11.75-5-849||11.50-5-834||11.25-5-819||11.00-5-804||10.75-5-749||10.50-5-734||10.25-5-719||10.00-5-704||9.75-5-649||9.50-5-634||9.25-5-619||9.00-5-604||8.75-5-549||8.50-5-534||8.25-5-519||8.00-5-504||7.75-5-449||7.50-5-434||7.25-5-419||7.00-5-404||6.75-5-349||6.50-5-334||6.25-5-319||6.00-5-304||5.75-5-249||5.50-5-234||5.25-5-219||5.00-5-204||4.75-5-149||4.50-5-134||4.25-5-119||4.00-5-104||3.75-5-49||3.50-5-34||3.25-5-19||3.00-5-4||2.75-4-2349||2.50-4-2334||2.25-4-2319||2.00-4-2304||1.75-4-2249||1.50-4-2234||1.25-4-2219||1.00-4-2204||0.75-4-2149||0.50-4-2134||0.25-4-2119||0.00-4-2104||-0.25-4-2049||-0.50-4-2034||-0.75-4-2019||-1.00-4-2004||-1.25-4-1949||-1.50-4-1934||-1.75-4-1919||-2.00-4-1904||-2.25-4-1849||-2.50-4-1834||-2.75-4-1819||-3.00-4-1804||-3.25-4-1749||-3.50-4-1734||-3.75-4-1719||-4.00-4-1704||-4.25-4-1649||-4.50-4-1634||-4.75-4-1619||-5.00-4-1604||-5.25-4-1549||-5.50-4-1534||-5.75-4-1519||-6.00-4-1504||-6.25-4-1449||-6.50-4-1434||-6.75-4-1419||-7.00-4-1404||-7.25-4-1349||-7.50-4-1334||-7.75-4-1319||-8.00-4-1304||-8.25-4-1249||-8.50-4-1234||-8.75-4-1219||-9.00-4-1204||-9.25-4-1149||-9.50-4-1134||-9.75-4-1119||-10.00-4-1104||-10.25-4-1049||-10.50-4-1034||-10.75-4-1019||-11.00-4-1004||-11.25-4-949||-11.50-4-934||-11.75-4-919||-12.00-4-904||-12.25-4-849||-12.50-4-834||-12.75-4-819|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|4|3|
hopper READY count: 500
|SELECT count(*) from vicidial_hopper where campaign_id='20000446' and status='READY';|
Processing GMT for list 2001515
Processing GMT for list 2001514
Processing GMT for list 2001513
Processing GMT for list 2001516
Processing GMT for list 2001517
Processing GMT for list 2001518
Processing GMT for list 2001519
Processing GMT for list 2001520
Processing GMT for list 2001521
Processing GMT for list 2001522
Processing GMT for list 2001523
Processing GMT for list 2001524
Processing GMT for list 2001525
Processing GMT for list 2001526
Processing GMT for list 2001527
Processing GMT for list 2001528
Processing GMT for list 2001529
Processing GMT for list 2001530
Processing GMT for list 2001531
Processing GMT for list 2001532
Processing GMT for list 2001533
Processing GMT for list 2001534
Processing GMT for list 2001535
Processing GMT for list 2001536
Processing GMT for list 2001537
Processing GMT for list 2001538
Processing GMT for list 2001539
Processing GMT for list 2001540
Processing GMT for list 2001541
Processing GMT for list 2001542
Processing GMT for list 2001543
Processing GMT for list 2001544
Processing GMT for list 2001545
Processing GMT for list 2001546
Processing GMT for list 2001547
Processing GMT for list 2001548
Processing GMT for list 2001549
Processing GMT for list 2001550
Processing GMT for list 2001551
campaign lists count ACTIVE:4 | TOTAL:39
LIST ID SQL (list_id IN('2001548','2001549','2001550','2001551')) |SELECT count(*) from vicidial_hopper where campaign_id='20000446' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='20000446' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='20000446' 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: 20000446
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('PDROP','DROP','B','AA','A','NA','N','ADC') and ((list_id IN('2001548','2001549','2001550','2001551'))) 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: 2967
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('PDROP','DROP','B','AA','A','NA','N','ADC') and ((list_id IN('2001548','2001549','2001550','2001551'))) 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

Starting hopper run for 20000447 campaign- GMT: 24hours HOPPER: 500 ORDER: DOWN|Y|LEAD_ASCEND

|GMT-DAY-HOUR| |13.00-5-1004||12.75-5-949||12.50-5-934||12.25-5-919||12.00-5-904||11.75-5-849||11.50-5-834||11.25-5-819||11.00-5-804||10.75-5-749||10.50-5-734||10.25-5-719||10.00-5-704||9.75-5-649||9.50-5-634||9.25-5-619||9.00-5-604||8.75-5-549||8.50-5-534||8.25-5-519||8.00-5-504||7.75-5-449||7.50-5-434||7.25-5-419||7.00-5-404||6.75-5-349||6.50-5-334||6.25-5-319||6.00-5-304||5.75-5-249||5.50-5-234||5.25-5-219||5.00-5-204||4.75-5-149||4.50-5-134||4.25-5-119||4.00-5-104||3.75-5-49||3.50-5-34||3.25-5-19||3.00-5-4||2.75-4-2349||2.50-4-2334||2.25-4-2319||2.00-4-2304||1.75-4-2249||1.50-4-2234||1.25-4-2219||1.00-4-2204||0.75-4-2149||0.50-4-2134||0.25-4-2119||0.00-4-2104||-0.25-4-2049||-0.50-4-2034||-0.75-4-2019||-1.00-4-2004||-1.25-4-1949||-1.50-4-1934||-1.75-4-1919||-2.00-4-1904||-2.25-4-1849||-2.50-4-1834||-2.75-4-1819||-3.00-4-1804||-3.25-4-1749||-3.50-4-1734||-3.75-4-1719||-4.00-4-1704||-4.25-4-1649||-4.50-4-1634||-4.75-4-1619||-5.00-4-1604||-5.25-4-1549||-5.50-4-1534||-5.75-4-1519||-6.00-4-1504||-6.25-4-1449||-6.50-4-1434||-6.75-4-1419||-7.00-4-1404||-7.25-4-1349||-7.50-4-1334||-7.75-4-1319||-8.00-4-1304||-8.25-4-1249||-8.50-4-1234||-8.75-4-1219||-9.00-4-1204||-9.25-4-1149||-9.50-4-1134||-9.75-4-1119||-10.00-4-1104||-10.25-4-1049||-10.50-4-1034||-10.75-4-1019||-11.00-4-1004||-11.25-4-949||-11.50-4-934||-11.75-4-919||-12.00-4-904||-12.25-4-849||-12.50-4-834||-12.75-4-819|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|4|3|
hopper READY count: 906
|SELECT count(*) from vicidial_hopper where campaign_id='20000447' and status='READY';|
Processing GMT for list 2001554
Processing GMT for list 2001552
Processing GMT for list 2001553
Processing GMT for list 2001555
Processing GMT for list 2001556
Processing GMT for list 2001557
campaign lists count ACTIVE:3 | TOTAL:6
LIST ID SQL (list_id IN('2001555','2001556','2001557')) |SELECT count(*) from vicidial_hopper where campaign_id='20000447' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='20000447' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='20000447' 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: 20000447
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('01','NEW','PDROP','02','DROP','B','AA','A','NA','N','ADC') and ((list_id IN('2001555','2001556','2001557'))) 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: 4331
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('01','NEW','PDROP','02','DROP','B','AA','A','NA','N','ADC') and ((list_id IN('2001555','2001556','2001557'))) 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
CAMPAIGN STATS: 1|UPDATE vicidial_campaign_stats SET dialable_leads='4331' where campaign_id='20000447';|

SUMMARY: 2 campaigns
20000446 2967 500 500
20000447 4331 500 906
DONE. Script execution time in seconds: 0
mfvicipilot05pri:/usr/share/astguiclient #

Glad it worked for ya

carpenox wrote:Glad it worked for ya

A question, today I had this episode again. I make the steps and all was ok but exist a way to make a periodic maintenance to avoid the 0 leads in hopper, because this is converting in a recurrence. Thank your for you help

Regular maintenance should be done to maintain the sever performance.

old logs should be delete /purged and regularly mysql to be optimized. once in a week or month.
ref : http://vicidial.org/VICIDIALforum/viewtopic.php?t=6180
https://www.youtube.com/watch?v=8RPTTTFEgNQ&feature=youtu.be
https://www.youtube.com/watch?v=48LqIZ67oPk&t=1s

striker wrote:Regular maintenance should be done to maintain the sever performance.

old logs should be delete /purged and regularly mysql to be optimized. once in a week or month.
ref : http://vicidial.org/VICIDIALforum/viewtopic.php?t=6180
https://www.youtube.com/watch?v=8RPTTTFEgNQ&feature=youtu.be
https://www.youtube.com/watch?v=48LqIZ67oPk&t=1s

Thank you strike, i will check out