Leads are not coming in the HOPPER

[prince.fer]

I am using astguclient_2.0.2 with CentOS 4.4. I have loaded the leads perfectly with GUI and it went properly. When i saw my campaign there is no leads in hopper. I am from
I am from Amsterdam I have put GMT +2

Below are the output of my server :

[root@local cron]# date
Wed Apr 11 20:41:48 CEST 2007
My timings in vicidial admin page and server is same.

[root@local cron]# /home/cron/ADMIN_adjust_GMTnow_on_leads.pl --debug

-----DEBUGGING -----

STARTING TIME ZONE DAYLIGHT SAVING TIME CALCULATION SCRIPT



SEED TIME 1176317613 : 2007-04-11 20:53:33 LOCAL GMT OFFSET NOW: 3
- Unique Country dial codes found: 2
- GMT postal codes records: 41750

RUNNING LOOP FOR COUNTRY CODE: 1

RUNNING LOOP FOR COUNTRY CODE:
Postal Updates:
Area Code Updates: 0

DONE

- process runtime (1 sec) (0.0166666666666667 minutes)


============================================================

\========================================================


[root@local cron]# /home/cron/AST_VDhopper.pl --debugX

----- DEBUG -----


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

TIME DEBUG: 2.00|3|1| GMT: 17:48
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 1
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('1111');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2007-04-11 20:48:09' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 4|3

|GMT-DAY-HOUR| |13.00-4-648||12.75-4-633||12.50-4-618||12.25-4-603||12.00-4-548||11.75-4-533||11.50-4-518||11.25-4-503||11.00-4-448||10.75-4-433||10.50-4-418||10.25-4-403||10.00-4-348||9.75-4-333||9.50-4-318||9.25-4-303||9.00-4-248||8.75-4-233||8.50-4-218||8.25-4-203||8.00-4-148||7.75-4-133||7.50-4-118||7.25-4-103||7.00-4-48||6.75-4-33||6.50-4-18||6.25-4-3||6.00-3-2348||5.75-3-2333||5.50-3-2318||5.25-3-2303||5.00-3-2248||4.75-3-2233||4.50-3-2218||4.25-3-2203||4.00-3-2148||3.75-3-2133||3.50-3-2118||3.25-3-2103||3.00-3-2048||2.75-3-2033||2.50-3-2018||2.25-3-2003||2.00-3-1948||1.75-3-1933||1.50-3-1918||1.25-3-1903||1.00-3-1848||0.75-3-1833||0.50-3-1818||0.25-3-1803||0.00-3-1748||-0.25-3-1733||-0.50-3-1718||-0.75-3-1703||-1.00-3-1648||-1.25-3-1633||-1.50-3-1618||-1.75-3-1603||-2.00-3-1548||-2.25-3-1533||-2.50-3-1518||-2.75-3-1503||-3.00-3-1448||-3.25-3-1433||-3.50-3-1418||-3.75-3-1403||-4.00-3-1348||-4.25-3-1333||-4.50-3-1318||-4.75-3-1303||-5.00-3-1248||-5.25-3-1233||-5.50-3-1218||-5.75-3-1203||-6.00-3-1148||-6.25-3-1133||-6.50-3-1118||-6.75-3-1103||-7.00-3-1048||-7.25-3-1033||-7.50-3-1018||-7.75-3-1003||-8.00-3-948||-8.25-3-933||-8.50-3-918||-8.75-3-903||-9.00-3-848||-9.25-3-833||-9.50-3-818||-9.75-3-803||-10.00-3-748||-10.25-3-733||-10.50-3-718||-10.75-3-703||-11.00-3-648||-11.25-3-633||-11.50-3-618||-11.75-3-603||-12.00-3-548||-12.25-3-533||-12.50-3-518||-12.75-3-503|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for AUSCAMP campaign- GMT: 24hours HOPPER: 750
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='AUSCAMP' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='AUSCAMP' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 1387
|SELECT count(*) from vicidial_hopper where campaign_id='AUSCAMP' and status='READY';|

|GMT-DAY-HOUR| |13.00-4-648||12.75-4-633||12.50-4-618||12.25-4-603||12.00-4-548||11.75-4-533||11.50-4-518||11.25-4-503||11.00-4-448||10.75-4-433||10.50-4-418||10.25-4-403||10.00-4-348||9.75-4-333||9.50-4-318||9.25-4-303||9.00-4-248||8.75-4-233||8.50-4-218||8.25-4-203||8.00-4-148||7.75-4-133||7.50-4-118||7.25-4-103||7.00-4-48||6.75-4-33||6.50-4-18||6.25-4-3||6.00-3-2348||5.75-3-2333||5.50-3-2318||5.25-3-2303||5.00-3-2248||4.75-3-2233||4.50-3-2218||4.25-3-2203||4.00-3-2148||3.75-3-2133||3.50-3-2118||3.25-3-2103||3.00-3-2048||2.75-3-2033||2.50-3-2018||2.25-3-2003||2.00-3-1948||1.75-3-1933||1.50-3-1918||1.25-3-1903||1.00-3-1848||0.75-3-1833||0.50-3-1818||0.25-3-1803||0.00-3-1748||-0.25-3-1733||-0.50-3-1718||-0.75-3-1703||-1.00-3-1648||-1.25-3-1633||-1.50-3-1618||-1.75-3-1603||-2.00-3-1548||-2.25-3-1533||-2.50-3-1518||-2.75-3-1503||-3.00-3-1448||-3.25-3-1433||-3.50-3-1418||-3.75-3-1403||-4.00-3-1348||-4.25-3-1333||-4.50-3-1318||-4.75-3-1303||-5.00-3-1248||-5.25-3-1233||-5.50-3-1218||-5.75-3-1203||-6.00-3-1148||-6.25-3-1133||-6.50-3-1118||-6.75-3-1103||-7.00-3-1048||-7.25-3-1033||-7.50-3-1018||-7.75-3-1003||-8.00-3-948||-8.25-3-933||-8.50-3-918||-8.75-3-903||-9.00-3-848||-9.25-3-833||-9.50-3-818||-9.75-3-803||-10.00-3-748||-10.25-3-733||-10.50-3-718||-10.75-3-703||-11.00-3-648||-11.25-3-633||-11.50-3-618||-11.75-3-603||-12.00-3-548||-12.25-3-533||-12.50-3-518||-12.75-3-503|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for USCAMP campaign- GMT: 24hours HOPPER: 0
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='USCAMP' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='USCAMP' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='USCAMP' and status='READY';|

|GMT-DAY-HOUR| |13.00-4-648||12.75-4-633||12.50-4-618||12.25-4-603||12.00-4-548||11.75-4-533||11.50-4-518||11.25-4-503||11.00-4-448||10.75-4-433||10.50-4-418||10.25-4-403||10.00-4-348||9.75-4-333||9.50-4-318||9.25-4-303||9.00-4-248||8.75-4-233||8.50-4-218||8.25-4-203||8.00-4-148||7.75-4-133||7.50-4-118||7.25-4-103||7.00-4-48||6.75-4-33||6.50-4-18||6.25-4-3||6.00-3-2348||5.75-3-2333||5.50-3-2318||5.25-3-2303||5.00-3-2248||4.75-3-2233||4.50-3-2218||4.25-3-2203||4.00-3-2148||3.75-3-2133||3.50-3-2118||3.25-3-2103||3.00-3-2048||2.75-3-2033||2.50-3-2018||2.25-3-2003||2.00-3-1948||1.75-3-1933||1.50-3-1918||1.25-3-1903||1.00-3-1848||0.75-3-1833||0.50-3-1818||0.25-3-1803||0.00-3-1748||-0.25-3-1733||-0.50-3-1718||-0.75-3-1703||-1.00-3-1648||-1.25-3-1633||-1.50-3-1618||-1.75-3-1603||-2.00-3-1548||-2.25-3-1533||-2.50-3-1518||-2.75-3-1503||-3.00-3-1448||-3.25-3-1433||-3.50-3-1418||-3.75-3-1403||-4.00-3-1348||-4.25-3-1333||-4.50-3-1318||-4.75-3-1303||-5.00-3-1248||-5.25-3-1233||-5.50-3-1218||-5.75-3-1203||-6.00-3-1148||-6.25-3-1133||-6.50-3-1118||-6.75-3-1103||-7.00-3-1048||-7.25-3-1033||-7.50-3-1018||-7.75-3-1003||-8.00-3-948||-8.25-3-933||-8.50-3-918||-8.75-3-903||-9.00-3-848||-9.25-3-833||-9.50-3-818||-9.75-3-803||-10.00-3-748||-10.25-3-733||-10.50-3-718||-10.75-3-703||-11.00-3-648||-11.25-3-633||-11.50-3-618||-11.75-3-603||-12.00-3-548||-12.25-3-533||-12.50-3-518||-12.75-3-503|
|SELECT * FROM vicidial_call_times where call_time_id='9am-5pm';|
|SELECT * from vicidial_state_call_times where state_call_time_id='alabama';|
|SELECT * from vicidial_state_call_times where state_call_time_id='illinois';|
|SELECT * from vicidial_state_call_times where state_call_time_id='indiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='kentucky';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='massachuse';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
|SELECT * from vicidial_state_call_times where state_call_time_id='nebraska';|
|SELECT * from vicidial_state_call_times where state_call_time_id='nevada';|
|SELECT * from vicidial_state_call_times where state_call_time_id='pennsylvan';|
|SELECT * from vicidial_state_call_times where state_call_time_id='rhodeislan';|
|SELECT * from vicidial_state_call_times where state_call_time_id='sdakota';|
|SELECT * from vicidial_state_call_times where state_call_time_id='tennessee';|
|SELECT * from vicidial_state_call_times where state_call_time_id='texas';|
|SELECT * from vicidial_state_call_times where state_call_time_id='utah';|
|SELECT * from vicidial_state_call_times where state_call_time_id='washington';|
|SELECT * from vicidial_state_call_times where state_call_time_id='wyoming';|
Starting hopper run for TestCamp campaign- GMT: 9am-5pm HOPPER: 10
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('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','-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') and state NOT IN('AL','IL','IN','KY','LA','MA','MS','NE','NV','PN','RI','SD','TN','TX','UT','WA','WY')) or (state='AL' 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','-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')) or (state='IL' 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','-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')) or (state='IN' 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','-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')) or (state='KY' 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','-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')) or (state='LA' 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','-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')) or (state='MA' 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','-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')) or (state='MS' 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','-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')) or (state='NE' 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','-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')) or (state='NV' 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','-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')) or (state='PN' 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','-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')) or (state='RI' 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','-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')) or (state='SD' 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','-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')) or (state='TN' 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','-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')) or (state='TX' 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','-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')) or (state='UT' 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','-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')) or (state='WA' 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','-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')) or (state='WY' 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','-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')) );|
hopper READY count: 15
|SELECT count(*) from vicidial_hopper where campaign_id='TestCamp' and status='READY';|

|GMT-DAY-HOUR| |13.00-4-648||12.75-4-633||12.50-4-618||12.25-4-603||12.00-4-548||11.75-4-533||11.50-4-518||11.25-4-503||11.00-4-448||10.75-4-433||10.50-4-418||10.25-4-403||10.00-4-348||9.75-4-333||9.50-4-318||9.25-4-303||9.00-4-248||8.75-4-233||8.50-4-218||8.25-4-203||8.00-4-148||7.75-4-133||7.50-4-118||7.25-4-103||7.00-4-48||6.75-4-33||6.50-4-18||6.25-4-3||6.00-3-2348||5.75-3-2333||5.50-3-2318||5.25-3-2303||5.00-3-2248||4.75-3-2233||4.50-3-2218||4.25-3-2203||4.00-3-2148||3.75-3-2133||3.50-3-2118||3.25-3-2103||3.00-3-2048||2.75-3-2033||2.50-3-2018||2.25-3-2003||2.00-3-1948||1.75-3-1933||1.50-3-1918||1.25-3-1903||1.00-3-1848||0.75-3-1833||0.50-3-1818||0.25-3-1803||0.00-3-1748||-0.25-3-1733||-0.50-3-1718||-0.75-3-1703||-1.00-3-1648||-1.25-3-1633||-1.50-3-1618||-1.75-3-1603||-2.00-3-1548||-2.25-3-1533||-2.50-3-1518||-2.75-3-1503||-3.00-3-1448||-3.25-3-1433||-3.50-3-1418||-3.75-3-1403||-4.00-3-1348||-4.25-3-1333||-4.50-3-1318||-4.75-3-1303||-5.00-3-1248||-5.25-3-1233||-5.50-3-1218||-5.75-3-1203||-6.00-3-1148||-6.25-3-1133||-6.50-3-1118||-6.75-3-1103||-7.00-3-1048||-7.25-3-1033||-7.50-3-1018||-7.75-3-1003||-8.00-3-948||-8.25-3-933||-8.50-3-918||-8.75-3-903||-9.00-3-848||-9.25-3-833||-9.50-3-818||-9.75-3-803||-10.00-3-748||-10.25-3-733||-10.50-3-718||-10.75-3-703||-11.00-3-648||-11.25-3-633||-11.50-3-618||-11.75-3-603||-12.00-3-548||-12.25-3-533||-12.50-3-518||-12.75-3-503|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for Test Pat campaign- GMT: 24hours HOPPER: 1
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='Test Pat' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='Test Pat' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='Test Pat' and status='READY';|
hopper too low (0|1) starting hopper dump
campaign lists count: 1 | '1'
|SELECT list_id FROM vicidial_lists where campaign_id='Test Pat' and active='Y';|
no lead filter defined for campaign: Test Pat
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW','','','','') and list_id IN('1') 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('1') 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
DONE. Script execution time in seconds: 0



==========================================


mysql> SELECT count(*),gmt_offset_now,phone_code from vicidial_list group by gmt_offset_now,phone_code;
+----------+----------------+------------+
| count(*) | gmt_offset_now | phone_code |
+----------+----------------+------------+
| 21 | -10.00 | 1 |
| 9 | -8.00 | 1 |
| 710 | -7.00 | 1 |
| 264 | -6.00 | 1 |
| 898 | -5.00 | 1 |
| 2072 | -4.00 | 1 |
| 1 | 0.00 | |
| 28 | 0.00 | 1 |
+----------+----------------+------------+
8 rows in set (0.02 sec)

========================================================


mysql> SELECT count(*),list_id,status,phone_code from vicidial_list group by list_id,status,phone_code;
+----------+---------+--------+------------+
| count(*) | list_id | status | phone_code |
+----------+---------+--------+------------+
| 958 | 333 | NEW | 1 |
| 74 | 555 | A | 1 |
| 1 | 555 | CALLBK | 1 |
| 2 | 555 | DEC | 1 |
| 1 | 555 | DNC | 1 |
| 106 | 555 | DROP | 1 |
| 1 | 555 | INCALL | 1 |
| 26 | 555 | N | 1 |
| 14 | 555 | NA | 1 |
| 1453 | 555 | NEW | 1 |
| 8 | 555 | NI | 1 |
| 2 | 555 | NM | 1 |
| 12 | 555 | NO | 1 |
| 26 | 555 | NOA | 1 |
| 2 | 555 | NP | 1 |
| 2 | 555 | SALE | 1 |
| 2 | 555 | WN | 1 |
| 970 | 666 | NEW | 1 |
| 1 | 999 | N | 1 |
| 1 | 999 | SALE | |
| 1 | 1000 | DROP | 1 |
| 190 | 1000 | NEW | 1 |
| 1 | 1111 | B | 1 |
| 3 | 1111 | CALLBK | 1 |
| 1 | 1111 | CBHOLD | 1 |
| 2 | 1111 | DEC | 1 |
| 5 | 1111 | DROP | 1 |
| 12 | 1111 | N | 1 |
| 4 | 1111 | NA | 1 |
| 120 | 1111 | NEW | 1 |
| 1 | 1111 | SALE | 1 |
| 1 | 1111 | XFER | 1 |
+----------+---------+--------+------------+
32 rows in set (0.02 sec)



===============================================

mysql> SELECT * from servers;
+------------+---------------------------------+-----------+--------+------------------+---------------------+-------------+-------------+----------------+--------------+----------------------+----------------------+--------------------+-----------+----------------------+-----------------------+-------------+--------------+----------------+------------+-------------------------+--------------------------+
| server_id | server_description | server_ip | active | asterisk_version | max_vicidial_trunks | telnet_host | telnet_port | ASTmgrUSERNAME | ASTmgrSECRET | ASTmgrUSERNAMEupdate | ASTmgrUSERNAMElisten | ASTmgrUSERNAMEsend | local_gmt | voicemail_dump_exten | answer_transfer_agent | ext_context | sys_perf_log | vd_server_logs | agi_output | vicidial_balance_active | balance_trunks_offlimits |
+------------+---------------------------------+-----------+--------+------------------+---------------------+-------------+-------------+----------------+--------------+----------------------+----------------------+--------------------+-----------+----------------------+-----------------------+-------------+--------------+----------------+------------+-------------------------+--------------------------+
| TESTasteri | Test install of Asterisk server | 127.0.0.1 | Y | 2.0.2 | 20 | 127.0.0.1 | 5038 | cron | 1234 | updatecron | listencron | sendcron | 2.00 | 85026666666666 | 8365 | default | N | Y | FILE | N | 0 |
+------------+---------------------------------+-----------+--------+------------------+---------------------+-------------+-------------+----------------+--------------+----------------------+----------------------+--------------------+-----------+----------------------+-----------------------+-------------+--------------+----------------+------------+-------------------------+--------------------------+
1 row in set (0.00 sec)




=====================================



mysql> SELECT count(*) from vicidial_phone_codes;
+----------+
| count(*) |
+----------+
| 1014 |
+----------+
1 row in set (0.00 sec)

[chander.prakash]

PLease check that the crontab entries are correctly in place?

Also post the output of the following command

crontab -l

This will help us in analysing your problem and providing a solution

[prince.fer]

output of crontab -l

### recording mixing for Asterisk run every 5 minutes
1,6,11,16,21,26,31,36,41,46,51,56 * * * 1,2,3,4,5,6 /home/cron/AST_CRON_mix_recordings_BASIC.pl

### keepalive script for astguiclient processes
* * * * * /home/cron/ADMIN_keepalive_ALL.pl

### kill Hangup script for Asterisk updaters
* * * * * /home/cron/AST_manager_kill_hung_congested.pl

### updater for voicemail
* * * * * /home/cron/AST_vm_update.pl

### updater for conference validator
* * * * * /home/cron/AST_conf_update.pl

### flush queue DB table every hour for entries older than 1 hour
11 * * * * /home/cron/AST_flush_DBqueue.pl -q

### fix the vicidial_agent_log once every hour
33 * * * * /home/cron/AST_cleanup_agent_log.pl

### updater for VICIDIAL hopper
* * * * * /home/cron/AST_VDhopper.pl -q

### adjust the GMT offset for the leads in the vicidial_list table
1 1 * * * /home/cron/ADMIN_adjust_GMTnow_on_leads.pl --debug

### reset several temporary-info tables in the database
2 1 * * * /home/cron/AST_reset_mysql_vars.pl

### optimize the database tables within the asterisk database
3 1 * * * /home/cron/AST_DB_optimize.pl

## adjust time on the server with ntp
30 * * * * /usr/local/bin/ntpdate -u 18.145.0.30 2>/dev/null 1>&2

### VICIDIAL agent time log weekly summary report generation
2 0 * * 0 /home/cron/AST_agent_week.pl

Pls. help me....

[Op3r]

How many leads do you see on the campaign detail?

if you see some leads on it

then try to login again.

[chander.prakash]

Thanks for the output. We are analysing it and will get back soon.

Await our next post

[chander.prakash]

From the detailed view please post the local call time.

For test purpose change it to 24 hours

[prince.fer]

I am using USCAMP in my campaign. It gives me below output in campaign detail.

This campaign has 958 leads to be dialed in those lists -
This campaign has 0 leads in the dial hopper

[chander.prakash]

Is it possible for you to come on skype ?

We will try and sort it out now

[mflorell]

What list_ids are assigned to USCAMP?

Have you reset these lists?

What dial statuses do you have selected in your campaign screen?