no more leads in hopper for campaign

[seanbrowne]

Hi,

I am using Vicibix Server (2.05-173 Build 90320-0424)

I have a problem. Loaded new list but hopper remains empty. I cannot dial new leads as I get message 'no more leads in hopper for campaign'

I have made sure Dial Status is 'new'
I have confirmed Campaign times are correct.

When I run /usr/share/astguiclient/AST_VDhopper.pl --debugX I get

-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','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
root@vicidial:~#

Everything was working fine until this happened.

Can anyone help?

Thanks a lot,

Sean

[seanbrowne]

Having read other posts, I suspect this may help you.

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 |
+----------+---------+--------+-------------------------+----------------+
| 7 | 101 | NEW | N | -5.00 |
| 2 | 999 | DEC | Y | -5.00 |
| 38 | 999 | DROP | Y | -5.00 |
| 2 | 999 | INBND | Y | -5.00 |
| 2 | 999 | N | Y | -5.00 |
| 60000 | 999 | NEW | N | -5.00 |
| 14 | 999 | NI | Y | -5.00 |
| 334 | 1015 | NEW | N | 0.00 |
| 4 | 1017 | ERI | N | 0.00 |
| 1 | 1017 | N | N | 0.00 |
| 29 | 1017 | NEW | N | 0.00 |
| 16 | 1017 | NI | N | 0.00 |
| 334 | 1018 | NEW | N | 0.00 |
+----------+---------+--------+-------------------------+----------------+
13 rows in set (0.17 sec)

mysql>