no leads in the hopper for this campaign

[vasilis.manolopoulos]

Hi,

I am trying to install vicidial on a fedora 5 pc with asterisk 1.4.2. The problem is that when an agent logs in there is a message "Sorry, there are no leads in the hopper for this campaign"
the output of the command:
/usr/share/astguiclient/AST_VDhopper.pl --debugX is:

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

TIME DEBUG: -5|-4|1| GMT: 18:57
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2007-06-06 14:57:21' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0

|GMT-DAY-HOUR| |13.00-4-757||12.75-4-742||12.50-4-727||12.25-4-712||12.00-4-657||11.75-4-642||11.50-4-627||11.25-4-612||11.00-4-557||10.75-4-542||10.50-4-527||10.25-4-512||10.00-4-457||9.75-4-442||9.50-4-427||9.25-4-412||9.00-4-357||8.75-4-342||8.50-4-327||8.25-4-312||8.00-4-257||7.75-4-242||7.50-4-227||7.25-4-212||7.00-4-157||6.75-4-142||6.50-4-127||6.25-4-112||6.00-4-57||5.75-4-42||5.50-4-27||5.25-4-12||5.00-3-2357||4.75-3-2342||4.50-3-2327||4.25-3-2312||4.00-3-2257||3.75-3-2242||3.50-3-2227||3.25-3-2212||3.00-3-2157||2.75-3-2142||2.50-3-2127||2.25-3-2112||2.00-3-2057||1.75-3-2042||1.50-3-2027||1.25-3-2012||1.00-3-1957||0.75-3-1942||0.50-3-1927||0.25-3-1912||0.00-3-1857||-0.25-3-1842||-0.50-3-1827||-0.75-3-1812||-1.00-3-1757||-1.25-3-1742||-1.50-3-1727||-1.75-3-1712||-2.00-3-1657||-2.25-3-1642||-2.50-3-1627||-2.75-3-1612||-3.00-3-1557||-3.25-3-1542||-3.50-3-1527||-3.75-3-1512||-4.00-3-1457||-4.25-3-1442||-4.50-3-1427||-4.75-3-1412||-5.00-3-1357||-5.25-3-1342||-5.50-3-1327||-5.75-3-1312||-6.00-3-1257||-6.25-3-1242||-6.50-3-1227||-6.75-3-1212||-7.00-3-1157||-7.25-3-1142||-7.50-3-1127||-7.75-3-1112||-8.00-3-1057||-8.25-3-1042||-8.50-3-1027||-8.75-3-1012||-9.00-3-957||-9.25-3-942||-9.50-3-927||-9.75-3-912||-10.00-3-857||-10.25-3-842||-10.50-3-827||-10.75-3-812||-11.00-3-757||-11.25-3-742||-11.50-3-727||-11.75-3-712||-12.00-3-657||-12.25-3-642||-12.50-3-627||-12.75-3-612|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for 100 campaign- GMT: 24hours HOPPER: 50
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='100' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='100' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='100' and status='READY';|
hopper too low (0|50) starting hopper dump
campaign lists count: 1 | '100'
|SELECT list_id FROM vicidial_lists where campaign_id='100' and active='Y';|
no lead filter defined for campaign: 100
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('100') 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('100') 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


can you provide me with some workaround for this problem?

Regards
Vasilis Manolopoulos

[mflorell]

Please post results of this query in MySQL:

SELECT count(*),list_id,status,called_since_last_reset,gmt_offset_now from vicidial_list group by list_id,status,called_since_last_reset,gmt_offset_now;

[vasilis.manolopoulos]

Thx for the immediate reply mflorell!

Here is the result of the query:

SELECT count(*),list_id,status,called_since_last_reset,gmt_offset_now from vicidial_list group by list_id,status,called_since_last_reset,gmt_offset_now;
+----------+---------+--------+-------------------------+----------------+
| count(*) | list_id | status | called_since_last_reset | gmt_offset_now |
+----------+---------+--------+-------------------------+----------------+
| 39 | 107 | NEW | N | -4.00 |
| 6 | 129 | NEW | N | -7.00 |
| 6 | 129 | NEW | N | -6.00 |
| 9 | 129 | NEW | N | -5.00 |
| 9 | 129 | NEW | N | -4.00 |
| 3 | 129 | NEW | N | 1.00 |
| 3 | 129 | NEW | N | 9.50 |
| 3 | 129 | NEW | N | 10.00 |
+----------+---------+--------+-------------------------+----------------+
8 rows in set (0.11 sec)

[vasilis.manolopoulos]

Ok problem solved . Thx for helping.

[artimus]

If you don't mind me butting in, I am having a simular problem. My phone rings and puts me in 8600051. You are the only caller in this conf... asterisk -rvvvvv.... does not show any attempt to dial an outside number.

here is my output

Code: Select all

+----------+---------+--------+-------------------------+----------------+
| count(*) | list_id | status | called_since_last_reset | gmt_offset_now |
+----------+---------+--------+-------------------------+----------------+
|        4 |       1 | NEW    | N                       |          -4.00 |
|        1 |     102 | N      | Y                       |          -4.00 |
|        5 |     102 | NEW    | Y                       |          -4.00 |
+----------+---------+--------+-------------------------+----------------+


There is only one list (102).

Code: Select all

# /usr/share/astguiclient/AST_VDhopper.pl --debug

----- DEBUG -----

TIME DEBUG: -5|-4|1|   GMT: 16:47
SELECT * FROM vicidial_lists where active='N';Inactive Lists:  0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2007-09-26 12:47:52' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR:  1|0
Starting hopper run for 02 campaign- GMT: 24hours   HOPPER: 5
     hopper DONE cleared:  0E0
     hopper GMT BAD cleared:  0E0
     hopper READY count:   0
     hopper too low (0|5) starting hopper dump
     campaign lists count: 1 | '102'
     no lead filter defined for campaign: 02
     leads to call count:  0
     NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
     ERROR CANNOT ADD ANY LEADS TO HOPPER
DONE. Script execution time in seconds: 0


[ciacho]

I have similiar problem:

I use manual dial, when i dial some numbers, i got popup window:

Code: Select all

<10.0.0.3>

No more leads in the hopper for campaign:
LAP

and 'dial next number' button is not clickable.

Code: Select all

mysql> SELECT count(*),list_id,status,called_since_last_reset,gmt_offset_now from vicidial_list group by list_id,status,called_since_last_reset,gmt_offset_now;
+----------+---------+--------+-------------------------+----------------+
| count(*) | list_id | status | called_since_last_reset | gmt_offset_now |
+----------+---------+--------+-------------------------+----------------+
|        2 |    1000 | CBHOLD | Y                       |           2.00 |
|        1 |    1000 | DROP   | Y                       |           2.00 |
|       12 |    1000 | N      | Y                       |           2.00 |
|        7 |    1000 | NA     | Y                       |           2.00 |
|        3 |    1000 | NEW    | Y                       |           2.00 |
|       78 |    1000 | NEW    | N                       |           2.00 |
|        9 |    1000 | Nieode | Y                       |           2.00 |
+----------+---------+--------+-------------------------+----------------+
7 rows in set (0.01 sec)


Code: Select all

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

----- DEBUG -----

TIME DEBUG: 0.00|1|1|   GMT: 10:19
SELECT * FROM vicidial_lists where active='N';Inactive Lists:  0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2008-07-16 11:19:01' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR:  1|0
Starting hopper run for lap campaign- GMT: 24hours   HOPPER: 1
     hopper DONE cleared:  0E0
     hopper GMT BAD cleared:  0E0
     hopper READY count:   0
     hopper too low (0|1) starting hopper dump
     campaign lists count: 2 | '999','1000'
     no lead filter defined for campaign: lap
     leads to call count:  77
     NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
     Getting Leads to add to hopper
     NO RECYCLE-LEADS INTO HOPPER DEFINED
     lead call order:      order by lead_id asc
     Adding to hopper:     1
     DONE with this campaign
DONE. Script execution time in seconds: 1


[mflorell]

This is fixed in 2.0.4.1rc3:

http://www.eflo.net/VICIDIALforum/viewtopic.php?t=5852