When it says "no dialable leads", of course the leads cannot then populate the hopper. How can I get a more specific error?
- Code: Select all
vici:~ #
vici:~ # /usr/share/astguiclient/AST_VDhopper.pl --debugX
----- DEBUG -----
----- SUPER DEBUG -----
TIME DEBUG: -5.00|-4|1| GMT: 00:32
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2015-04-05") ) );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 <= '2015-04-05 20:32:51' and status='ACTIVE';|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Trim Hopper Enabled For 1001---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 1
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0
Starting hopper run for 1001 campaign- GMT: 12pm-5pm HOPPER: 1 ORDER: DOWN|N|LEAD_ASCEND
|GMT-DAY-HOUR| |13.00-1-1332||12.75-1-1317||12.50-1-1302||12.25-1-1247||12.00-1-1232||11.75-1-1217||11.50-1-1202||11.25-1-1147||11.00-1-1132||10.75-1-1117||10.50-1-1102||10.25-1-1047||10.00-1-1032||9.75-1-1017||9.50-1-1002||9.25-1-947||9.00-1-932||8.75-1-917||8.50-1-902||8.25-1-847||8.00-1-832||7.75-1-817||7.50-1-802||7.25-1-747||7.00-1-732||6.75-1-717||6.50-1-702||6.25-1-647||6.00-1-632||5.75-1-617||5.50-1-602||5.25-1-547||5.00-1-532||4.75-1-517||4.50-1-502||4.25-1-447||4.00-1-432||3.75-1-417||3.50-1-402||3.25-1-347||3.00-1-332||2.75-1-317||2.50-1-302||2.25-1-247||2.00-1-232||1.75-1-217||1.50-1-202||1.25-1-147||1.00-1-132||0.75-1-117||0.50-1-102||0.25-1-47||0.00-1-32||-0.25-1-17||-0.50-1-2||-0.75-0-2347||-1.00-0-2332||-1.25-0-2317||-1.50-0-2302||-1.75-0-2247||-2.00-0-2232||-2.25-0-2217||-2.50-0-2202||-2.75-0-2147||-3.00-0-2132||-3.25-0-2117||-3.50-0-2102||-3.75-0-2047||-4.00-0-2032||-4.25-0-2017||-4.50-0-2002||-4.75-0-1947||-5.00-0-1932||-5.25-0-1917||-5.50-0-1902||-5.75-0-1847||-6.00-0-1832||-6.25-0-1817||-6.50-0-1802||-6.75-0-1747||-7.00-0-1732||-7.25-0-1717||-7.50-0-1702||-7.75-0-1647||-8.00-0-1632||-8.25-0-1617||-8.50-0-1602||-8.75-0-1547||-9.00-0-1532||-9.25-0-1517||-9.50-0-1502||-9.75-0-1447||-10.00-0-1432||-10.25-0-1417||-10.50-0-1402||-10.75-0-1347||-11.00-0-1332||-11.25-0-1317||-11.50-0-1302||-11.75-0-1247||-12.00-0-1232||-12.25-0-1217||-12.50-0-1202||-12.75-0-1147|
|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='12pm-5pm';|
LocalCallTime No-Call Gap: |68400|1700(17 00)|1200(12 00)|0|6|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='1001' and status='READY';|
Processing GMT for list 102
campaign lists count ACTIVE:1 | TOTAL:1
LIST ID SQL (list_id="102") |SELECT count(*) from vicidial_hopper where campaign_id='1001' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='1001' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='1001' and ((gmt_offset_now NOT IN('13.00','12.75','12.50','12.25','12.00','11.75','11.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','99') ) ));|
no lead filter defined for campaign: 1001
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('') and ((list_id="102")) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.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','99') ) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('') and ((list_id="102")) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.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','99') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
NO DIALABLE LEADS FOR THIS CAMPAIGN
hopper too low (0|1) starting hopper dump
ERROR CANNOT ADD ANY LEADS TO HOPPER
SUMMARY: 1 campaigns
1001 0 1 0
DONE. Script execution time in seconds: 0
vici:~ #
vici:~ # mysql -u root asterisk
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 335
Server version: 5.5.33-MariaDB-log openSUSE package
Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [asterisk]>
MariaDB [asterisk]> SELECT count(*),list_id,status,phone_code from vicidial_list group by list_id,status,phone_code;
+----------+---------+--------+------------+
| count(*) | list_id | status | phone_code |
+----------+---------+--------+------------+
| 1 | 101 | ERI | 1 |
| 1 | 101 | INCALL | 1 |
| 103 | 101 | NEW | 1 |
| 98 | 102 | NEW | 1 |
+----------+---------+--------+------------+
4 rows in set (0.00 sec)
MariaDB [asterisk]>
how do I "3) check "dialable statuses" to be sure "NEW" is listed"? see:
viewtopic.php?f=4&t=27823&p=98356&hilit=NO+DIALABLE+LEADS+FOR+THIS+CAMPAIGN#p98356
screens (not the problem, but included just in-case):
- Code: Select all
vici:~ #
vici:~ # screen -list
There are screens on:
3061.ASTemail (Detached)
3058.ASTVDadFILL (Detached)
3055.ASTfastlog (Detached)
3052.ASTVDadapt (Detached)
3049.ASTVDremote (Detached)
3046.ASTVDauto (Detached)
3043.ASTlisten (Detached)
3040.ASTsend (Detached)
3037.ASTupdate (Detached)
2865.asterisk (Detached)
2860.astshell20150405200552 (Detached)
11 Sockets in /var/run/screens/S-root.
vici:~ #