This campaign has 0 leads in the dial hopper

[ramonvel]

Hi,

I installed Vicidial asterisk 1.2.17 and astguiclient 2.0.3 on CentOS 4.4. I followed the "scratch installation" step by step. I also purchased the manager manual. I'm on the first tutorial where I create a campagin and load up a list. However, on the campaing created it says "This campaign has 0 leads in the dial hopper".

I typed the following commands:

mysql > SELECT count(*),list_id,status,called_since_last_reset,gmt_offset_now fro m 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 |
+----------+---------+--------+-------------------------+----------------+
| 4870 | 101 | NEW | N | 0.00 |
+----------+---------+--------+-------------------------+----------------+
1 row in set (0.03 sec)

Also:

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

----- DEBUG -----


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

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

|GMT-DAY-HOUR| |13.00-0-1758||12.75-0-1743||12.50-0-1728||12.25-0-1713||12. 00-0-1658||11.75-0-1643||11.50-0-1628||11.25-0-1613||11.00-0-1558||10.75-0-1543| |10.50-0-1528||10.25-0-1513||10.00-0-1458||9.75-0-1443||9.50-0-1428||9.25-0-1413 ||9.00-0-1358||8.75-0-1343||8.50-0-1328||8.25-0-1313||8.00-0-1258||7.75-0-1243|| 7.50-0-1228||7.25-0-1213||7.00-0-1158||6.75-0-1143||6.50-0-1128||6.25-0-1113||6. 00-0-1058||5.75-0-1043||5.50-0-1028||5.25-0-1013||5.00-0-958||4.75-0-943||4.50-0 -928||4.25-0-913||4.00-0-858||3.75-0-843||3.50-0-828||3.25-0-813||3.00-0-758||2. 75-0-743||2.50-0-728||2.25-0-713||2.00-0-658||1.75-0-643||1.50-0-628||1.25-0-613 ||1.00-0-558||0.75-0-543||0.50-0-528||0.25-0-513||0.00-0-458||-0.25-0-443||-0.50 -0-428||-0.75-0-413||-1.00-0-358||-1.25-0-343||-1.50-0-328||-1.75-0-313||-2.00-0 -258||-2.25-0-243||-2.50-0-228||-2.75-0-213||-3.00-0-158||-3.25-0-143||-3.50-0-1 28||-3.75-0-113||-4.00-0-58||-4.25-0-43||-4.50-0-28||-4.75-0-13||-5.00-6-2358||- 5.25-6-2343||-5.50-6-2328||-5.75-6-2313||-6.00-6-2258||-6.25-6-2243||-6.50-6-222 8||-6.75-6-2213||-7.00-6-2158||-7.25-6-2143||-7.50-6-2128||-7.75-6-2113||-8.00-6 -2058||-8.25-6-2043||-8.50-6-2028||-8.75-6-2013||-9.00-6-1958||-9.25-6-1943||-9. 50-6-1928||-9.75-6-1913||-10.00-6-1858||-10.25-6-1843||-10.50-6-1828||-10.75-6-1 813||-11.00-6-1758||-11.25-6-1743||-11.50-6-1728||-11.75-6-1713||-12.00-6-1658|| -12.25-6-1643||-12.50-6-1628||-12.75-6-1613|
|SELECT * FROM vicidial_call_times where call_time_id='9am-9pm';|
Starting hopper run for CLOSER campaign- GMT: 9am-9pm HOPPER: 1
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='CLOSER' and status IN('DONE ');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='CLOSER' and ((gmt_offset_no w IN('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','99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='CLOSER' and status ='READY';|
hopper too low (0|1) starting hopper dump
campaign lists count: 0 | ''
|SELECT list_id FROM vicidial_lists where campaign_id='CLOSER' and active=' Y';|
no lead filter defined for campaign: CLOSER
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and s tatus IN('NEW') and list_id IN('') and ((gmt_offset_now IN('13.00','12.75','12.5 0','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.0 0','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','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-1 0.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 s tatus IN('NEW') and list_id IN('') and ((gmt_offset_now IN('13.00','12.75','12.5 0','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.0 0','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','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-1 0.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-0-1758||12.75-0-1743||12.50-0-1728||12.25-0-1713||12. 00-0-1658||11.75-0-1643||11.50-0-1628||11.25-0-1613||11.00-0-1558||10.75-0-1543| |10.50-0-1528||10.25-0-1513||10.00-0-1458||9.75-0-1443||9.50-0-1428||9.25-0-1413 ||9.00-0-1358||8.75-0-1343||8.50-0-1328||8.25-0-1313||8.00-0-1258||7.75-0-1243|| 7.50-0-1228||7.25-0-1213||7.00-0-1158||6.75-0-1143||6.50-0-1128||6.25-0-1113||6. 00-0-1058||5.75-0-1043||5.50-0-1028||5.25-0-1013||5.00-0-958||4.75-0-943||4.50-0 -928||4.25-0-913||4.00-0-858||3.75-0-843||3.50-0-828||3.25-0-813||3.00-0-758||2. 75-0-743||2.50-0-728||2.25-0-713||2.00-0-658||1.75-0-643||1.50-0-628||1.25-0-613 ||1.00-0-558||0.75-0-543||0.50-0-528||0.25-0-513||0.00-0-458||-0.25-0-443||-0.50 -0-428||-0.75-0-413||-1.00-0-358||-1.25-0-343||-1.50-0-328||-1.75-0-313||-2.00-0 -258||-2.25-0-243||-2.50-0-228||-2.75-0-213||-3.00-0-158||-3.25-0-143||-3.50-0-1 28||-3.75-0-113||-4.00-0-58||-4.25-0-43||-4.50-0-28||-4.75-0-13||-5.00-6-2358||- 5.25-6-2343||-5.50-6-2328||-5.75-6-2313||-6.00-6-2258||-6.25-6-2243||-6.50-6-222 8||-6.75-6-2213||-7.00-6-2158||-7.25-6-2143||-7.50-6-2128||-7.75-6-2113||-8.00-6 -2058||-8.25-6-2043||-8.50-6-2028||-8.75-6-2013||-9.00-6-1958||-9.25-6-1943||-9. 50-6-1928||-9.75-6-1913||-10.00-6-1858||-10.25-6-1843||-10.50-6-1828||-10.75-6-1 813||-11.00-6-1758||-11.25-6-1743||-11.50-6-1728||-11.75-6-1713||-12.00-6-1658|| -12.25-6-1643||-12.50-6-1628||-12.75-6-1613|
|SELECT * FROM vicidial_call_times where call_time_id='9am-9pm';|
Starting hopper run for ARMCAMP campaign- GMT: 9am-9pm HOPPER: 5
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='ARMCAMP' and status IN('DON E');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='ARMCAMP' and ((gmt_offset_n ow IN('4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.5 0','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','99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='ARMCAMP' and statu s='READY';|
hopper too low (0|5) starting hopper dump
campaign lists count: 1 | '101'
|SELECT list_id FROM vicidial_lists where campaign_id='ARMCAMP' and active= 'Y';|
no lead filter defined for campaign: ARMCAMP
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and s tatus IN('NEW') and list_id IN('101') and ((gmt_offset_now IN('13.00','12.75','1 2.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','1 0.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.2 5','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50', '4.25','-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 s tatus IN('NEW') and list_id IN('101') and ((gmt_offset_now IN('13.00','12.75','1 2.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','1 0.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.2 5','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50', '4.25','-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

I've read previous troubleshooting steps, maybe now I should check the hopper perl file in crontab. But I have no idea how to do that!

Any recomendations, please? I need your help. Thanks,

[ramonvel]

I typed the following command on directorey /usr/share/astguiclient/

perl AST_VDhopper.pl
no command line options set

Help, Please,

Thanks in advance

[ramonvel]

Hey Guys,

I don't know how, but today I went to the campaing, and it shows:

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

This campaign has 5 leads in the dial hopper

So, I guess, some how it got fixed.

Thanks anyway!

[gardo]

check your dialing hours. if it's set between 9am to 9pm then that means it won't load any leads before 9am. if your server has gmt -5 then it will load the leads at 9am gmt -5 time.

[ramonvel]

Gardo,

Thanks for your reply. I almost go crazy again, asking what happened that it wasn't working, that's because I checked the hopper and it says 0 leads.

Of course, it's 9:24 PM and the calling hours is from 9:00 AM to 9:00 PM. I would make a post tomorrow morning after 9:00 AM. Hopefully it works.

Thanks again!

[ramonvel]

Yes !


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

This campaign has 5 leads in the dial hopper.

Great!

[ramonvel]

Hi,

The server has leads in the dial hopper. However, I notice that after 5:00 PM every day, it has none.

On the "local call time" I have it from 9:00 AM to 9:00 PM. I't suposed to be until 9:00 AM.

Any recomendations please,

[aster1]

If you are dialing for USA then a script in cron sets gmt offset for every lead . I supose 9 Am - 9 PM will be as per customer's time and not your office time . Where are you located ? Are you dialing to US ? Maybe your 5 PM is 9 PM in US then :-/

[ramonvel]

I'm in Miami , Florida & dialing to South Florida as well.

The server's time is right.

# date
#Tue Jul 3 13:27:31 EDT 2007

Any recommendation to fix this issue?

[Op3r]

If I remember correctly

after you load a big lead you need to run the script ADMIN_adjust_GMTnow_on_leads.pl

[ramindia]

Hi

is this must need to run the perl file.

even he upload from front end admin page ?

or its only need to run when the leads loading from command level ?

ram

[aster1]

As per cron this script is run once every day but it is must to run this after every huge leads upload . Either run manually or set cron to run this script every hour or so .

[ramonvel]

I'm sorry for taking such a long time to come back. Yes I entered this command before, but I just re-entered now again, this is the result:

[root@dialer ~]# /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl
no command line options set

- process runtime (0 sec) (0 minutes)

what do you think about results? Anything else that I must do?

[jekader]

I Also had this problem, and it didn't resolve by itself. So I did what the prel script wanted - went to the DB using phpMyAdmin, and saw, that there are no dial statuses in the vicidial_campaigns table.

All four fields, dial_status_a, dial_status_b, dial_status_c, dial_status_d were blank... I manually added 'NEW' to dial_status_a - and leads started appearing ib the hopper!

But I know this is not the right way. When I make changes to the campaign through the webadmin, the 'NEW' item disappears

And the dial statuses I add through the webadmin, appear in the auto_alt_dial_statuses field...

What am I doing wrong?

PS
Slackware 12.0
Asterisk 1.2.21.1
astguiclient 2.0.3

[ramonvel]

Hi Matt,

If I remember correctly, I never used SVN to install any software. I used the astguiclient release version 2.0.3.

In addition, I typed the following command :
# /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug --postal-code-gmt

-----DEBUGGING -----


----- DO POSTAL CODE LOOKUP -----

STARTING TIME ZONE DAYLIGHT SAVING TIME CALCULATION SCRIPT



SEED TIME 1185473213 : 2007-07-26 14:06:53 LOCAL GMT OFFSET NOW: -4
- Unique Country dial codes found: 1
- GMT postal codes records: 0

RUNNING LOOP FOR COUNTRY CODE: 1
POSTAL CODE RUN START...
Postal Updates: 0
Area Code Updates: 0

DONE

- process runtime (0 sec) (0 minutes)

It shows "OFFSET NOW: -4" Does this have to do anything with what's going on?

Once again, thanks for your help,

[aster1]

It shows "OFFSET NOW: -4" Does this have to do anything with what's going on?

This is fine since you are in EDT timezone which is GMT -4 .

NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER

This could be the problem . What dial status you have selected in campaign ? and what is the list order field set to ? Try changing that order once .
Also make a test campaign and see if it has having same problems with this one .