Local Call Time

[tommyinnn]

For some reason, after daylight savings time, setting the local call time to anything other than 24 hours will not load leads in the hopper - all my times (server, vici, pc's) are set to the correct time, and I'm running the same campaign I was last week with the same leads - does anyone know what the problem could be? For now, I have to watch the hopper till noon to make sure agents aren't calling anywhere before 9AM

[mflorell]

what country are you calling, and what country are you in. Also what state if in the US/Canada/Mexico?

output of /usr/share/astguiclient/AST_VDhopper.pl --debugX at 9AM

[tommyinnn]

US - nationwide list - calling from C. Florida - it used to only call the east coast @ 9AM - and move west as the day went on.
Thanks, I will run that command in the morning & post it

[tommyinnn]

Code: Select all

----- DEBUG -----


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

TIME DEBUG: -5.00|-4|1|   GMT: 13:03
SELECT * FROM vicidial_lists where active='N';Inactive Lists:  3
Inactive List Leads Deleted:  0E0 |DELETE from vicidial_hopper where list_id IN('1062','1060','1064');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2010-03-17 9:03:04' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR:  1|0

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

[mflorell]

That output looks good to me.

Is the ADMIN_adjust_GMTnow_on_leads.pl script in your crontab and running?

What is the output 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;

[tommyinnn]

count(*) list_id status called_since_last_reset gmt_offset_now
5 998 A Y1 0.00
1 998 A Y3 0.00
1 998 A Y8 0.00
5 998 DC Y1 0.00
4 998 DNC Y1 0.00
1 998 ERI Y 0.00
7 998 ERI Y1 0.00
1 998 ERI Y2 0.00
1 998 ERI Y5 0.00
1 998 ERI Y8 0.00
5 998 HU Y1 0.00
1 998 HU Y5 0.00
11 998 N Y1 0.00
6 998 N Y2 0.00
1 998 N Y3 0.00
2 998 N Y5 0.00
1 998 N Y6 0.00
1 998 N Y7 0.00
19 998 NDM Y1 0.00
5 998 NDM Y2 0.00
4 998 NI Y1 0.00
8 998 SALE Y1 0.00
1 998 SALE Y2 0.00
1 998 SALE Y7 0.00
6 998 WN Y1 0.00
1 998 WN Y2 0.00
1 998 WN Y3 0.00
362 1060 A Y -8.00
1403 1060 A Y -6.00
1873 1060 A Y -5.00

[mflorell]

either you have no east coast leads or your GMT adjust script is not running regularly in the crontab, or you do not have a phone_code of 1 in some of your leads(or a combination of these).