help with "This campaign has 0 leads to be dialed in ..

[crios]

Hello,

Vicidal version 2.2.1-237 Build 100510-2015.

I'm following the manual to load leads but I keep on getting :

This campaign has 3 active lists and 2 inactive lists

|| This campaign has 0 leads to be dialed in those lists - HIDE

This campaign has 0 leads in the dial hopper


The output from /usr/share/astguiclient/AST_VDhopper.pl --debugX is:


/usr/share/astguiclient/AST_VDhopper.pl --debugX

----- DEBUG -----


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

TIME DEBUG: -5|-5|0| GMT: 22:38
SELECT list_id FROM vicidial_lists where active='N';Inactive Lists: 4
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','997','996');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2011-02-15 17:38:10' and status='ACTIVE';|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 2|1

|GMT-DAY-HOUR| |13.00-3-1138||12.75-3-1123||12.50-3-1108||12.25-3-1053||12.00-3-1038||11.75-3-1023||11.50-3-1008||11.25-3-953||11.00-3-938||10.75-3-923||10.50-3-908||10.25-3-853||10.00-3-838||9.75-3-823||9.50-3-808||9.25-3-753||9.00-3-738||8.75-3-723||8.50-3-708||8.25-3-653||8.00-3-638||7.75-3-623||7.50-3-608||7.25-3-553||7.00-3-538||6.75-3-523||6.50-3-508||6.25-3-453||6.00-3-438||5.75-3-423||5.50-3-408||5.25-3-353||5.00-3-338||4.75-3-323||4.50-3-308||4.25-3-253||4.00-3-238||3.75-3-223||3.50-3-208||3.25-3-153||3.00-3-138||2.75-3-123||2.50-3-108||2.25-3-53||2.00-3-38||1.75-3-23||1.50-3-8||1.25-2-2353||1.00-2-2338||0.75-2-2323||0.50-2-2308||0.25-2-2253||0.00-2-2238||-0.25-2-2223||-0.50-2-2208||-0.75-2-2153||-1.00-2-2138||-1.25-2-2123||-1.50-2-2108||-1.75-2-2053||-2.00-2-2038||-2.25-2-2023||-2.50-2-2008||-2.75-2-1953||-3.00-2-1938||-3.25-2-1923||-3.50-2-1908||-3.75-2-1853||-4.00-2-1838||-4.25-2-1823||-4.50-2-1808||-4.75-2-1753||-5.00-2-1738||-5.25-2-1723||-5.50-2-1708||-5.75-2-1653||-6.00-2-1638||-6.25-2-1623||-6.50-2-1608||-6.75-2-1553||-7.00-2-1538||-7.25-2-1523||-7.50-2-1508||-7.75-2-1453||-8.00-2-1438||-8.25-2-1423||-8.50-2-1408||-8.75-2-1353||-9.00-2-1338||-9.25-2-1323||-9.50-2-1308||-9.75-2-1253||-10.00-2-1238||-10.25-2-1223||-10.50-2-1208||-10.75-2-1153||-11.00-2-1138||-11.25-2-1123||-11.50-2-1108||-11.75-2-1053||-12.00-2-1038||-12.25-2-1023||-12.50-2-1008||-12.75-2-953|
|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 FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|2|1|
Starting hopper run for TEST_IN campaign- GMT: 24hours HOPPER: 5 ORDER: DOWN
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='TEST_IN' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='TEST_IN' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='TEST_IN' and status='READY';|
hopper too low (0|5) starting hopper dump
campaign lists count: 0 | '999876543210'
|SELECT list_id FROM vicidial_lists where campaign_id='TEST_IN' and active='Y';|
no lead filter defined for campaign: TEST_IN
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('999876543210') 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 where called_since_last_reset='N' and status IN('NEW') and list_id IN('999876543210') 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
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-3-1138||12.75-3-1123||12.50-3-1108||12.25-3-1053||12.00-3-1038||11.75-3-1023||11.50-3-1008||11.25-3-953||11.00-3-938||10.75-3-923||10.50-3-908||10.25-3-853||10.00-3-838||9.75-3-823||9.50-3-808||9.25-3-753||9.00-3-738||8.75-3-723||8.50-3-708||8.25-3-653||8.00-3-638||7.75-3-623||7.50-3-608||7.25-3-553||7.00-3-538||6.75-3-523||6.50-3-508||6.25-3-453||6.00-3-438||5.75-3-423||5.50-3-408||5.25-3-353||5.00-3-338||4.75-3-323||4.50-3-308||4.25-3-253||4.00-3-238||3.75-3-223||3.50-3-208||3.25-3-153||3.00-3-138||2.75-3-123||2.50-3-108||2.25-3-53||2.00-3-38||1.75-3-23||1.50-3-8||1.25-2-2353||1.00-2-2338||0.75-2-2323||0.50-2-2308||0.25-2-2253||0.00-2-2238||-0.25-2-2223||-0.50-2-2208||-0.75-2-2153||-1.00-2-2138||-1.25-2-2123||-1.50-2-2108||-1.75-2-2053||-2.00-2-2038||-2.25-2-2023||-2.50-2-2008||-2.75-2-1953||-3.00-2-1938||-3.25-2-1923||-3.50-2-1908||-3.75-2-1853||-4.00-2-1838||-4.25-2-1823||-4.50-2-1808||-4.75-2-1753||-5.00-2-1738||-5.25-2-1723||-5.50-2-1708||-5.75-2-1653||-6.00-2-1638||-6.25-2-1623||-6.50-2-1608||-6.75-2-1553||-7.00-2-1538||-7.25-2-1523||-7.50-2-1508||-7.75-2-1453||-8.00-2-1438||-8.25-2-1423||-8.50-2-1408||-8.75-2-1353||-9.00-2-1338||-9.25-2-1323||-9.50-2-1308||-9.75-2-1253||-10.00-2-1238||-10.25-2-1223||-10.50-2-1208||-10.75-2-1153||-11.00-2-1138||-11.25-2-1123||-11.50-2-1108||-11.75-2-1053||-12.00-2-1038||-12.25-2-1023||-12.50-2-1008||-12.75-2-953|
|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 FROM vicidial_call_times where call_time_id='9am-9pm';|
LocalCallTime No-Call Gap: |43200|2100(21 00)|0900(09 00)|2|1|
Starting hopper run for TESTCAMP campaign- GMT: 9am-9pm HOPPER: 5 ORDER: DOWN
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='TESTCAMP' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='TESTCAMP' and ((gmt_offset_now IN('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','99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='TESTCAMP' and status='READY';|
hopper too low (0|5) starting hopper dump
campaign lists count: 3 | '995','994','993'
|SELECT list_id FROM vicidial_lists where campaign_id='TESTCAMP' and active='Y';|
no lead filter defined for campaign: TESTCAMP
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('QUEUE','NEW') and list_id IN('995','994','993') 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','-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 where called_since_last_reset='N' and status IN('QUEUE','NEW') and list_id IN('995','994','993') 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','-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
ERROR CANNOT ADD ANY LEADS TO HOPPER
DONE. Script execution time in seconds: 0


Any help would be appreciated!

Thanks!

[williamconley]

This campaign has 0 leads to be dialed in those lists

This means your problem is NOT related to the hopper. The hopper can only load available leads.

There is a reason your leads are not available .. some possibilities are:

1) Call times. Set to 24 hours to test this.

2) Filters. Remove any filter on the campaign.

3) Dial Status: check that there is at least ONE dialable status for the campaign and that there is at least ONE lead WITH that status in the ACTIVE list.

Also:

when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build

[crios]

Thanks William. I was able to figure out what the problem was.

[williamconley]

ok. i'll bite ... what was it?

[gaiiogmd]

can you tell please? I have the same problem now and i had reset my list a lot of times and nothing...

[berrayahkamel]

Whers was the problem !!!??

[berrayahkamel]

Hello

I had the same problem , so just when you creat a compagn put call 24h 24h

[williamconley]

Cool answers from 2011 still working today.

[Fares MEHENI]

Thank you, it served me too.