Posted:
Thu May 28, 2009 7:09 am
by webgurru
----- DEBUG -----
----- SUPER DEBUG -----
TIME DEBUG: 0.00|0.00|0| GMT: 13:06
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 3
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','101');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-05-28 13:06:46' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0
|GMT-DAY-HOUR| |13.00-5-206||12.75-5-151||12.50-5-136||12.25-5-121||12.00-5-106||11.75-5-51||11.50-5-36||11.25-5-21||11.00-5-6||10.75-4-2351||10.50-4-2336||10.25-4-2321||10.00-4-2306||9.75-4-2251||9.50-4-2236||9.25-4-2221||9.00-4-2206||8.75-4-2151||8.50-4-2136||8.25-4-2121||8.00-4-2106||7.75-4-2051||7.50-4-2036||7.25-4-2021||7.00-4-2006||6.75-4-1951||6.50-4-1936||6.25-4-1921||6.00-4-1906||5.75-4-1851||5.50-4-1836||5.25-4-1821||5.00-4-1806||4.75-4-1751||4.50-4-1736||4.25-4-1721||4.00-4-1706||3.75-4-1651||3.50-4-1636||3.25-4-1621||3.00-4-1606||2.75-4-1551||2.50-4-1536||2.25-4-1521||2.00-4-1506||1.75-4-1451||1.50-4-1436||1.25-4-1421||1.00-4-1406||0.75-4-1351||0.50-4-1336||0.25-4-1321||0.00-4-1306||-0.25-4-1251||-0.50-4-1236||-0.75-4-1221||-1.00-4-1206||-1.25-4-1151||-1.50-4-1136||-1.75-4-1121||-2.00-4-1106||-2.25-4-1051||-2.50-4-1036||-2.75-4-1021||-3.00-4-1006||-3.25-4-951||-3.50-4-936||-3.75-4-921||-4.00-4-906||-4.25-4-851||-4.50-4-836||-4.75-4-821||-5.00-4-806||-5.25-4-751||-5.50-4-736||-5.75-4-721||-6.00-4-706||-6.25-4-651||-6.50-4-636||-6.75-4-621||-7.00-4-606||-7.25-4-551||-7.50-4-536||-7.75-4-521||-8.00-4-506||-8.25-4-451||-8.50-4-436||-8.75-4-421||-9.00-4-406||-9.25-4-351||-9.50-4-336||-9.75-4-321||-10.00-4-306||-10.25-4-251||-10.50-4-236||-10.75-4-221||-11.00-4-206||-11.25-4-151||-11.50-4-136||-11.75-4-121||-12.00-4-106||-12.25-4-51||-12.50-4-36||-12.75-4-21|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|4|3|
Starting hopper run for TESTCAMP campaign- GMT: 24hours HOPPER: 100 ORDER: DOWN
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('99') ) );|
hopper READY count: 45
|SELECT count(*) from vicidial_hopper where campaign_id='TESTCAMP' and status='READY';|
hopper too low (45|100) starting hopper dump
campaign lists count: 1 | '111'
|SELECT list_id FROM vicidial_lists where campaign_id='TESTCAMP' and active='Y';|
no lead filter defined for campaign: TESTCAMP
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('111') 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: 45
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('111') 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
Getting Leads to add to hopper
|SELECT lead_id FROM vicidial_hopper where campaign_id='TESTCAMP';|
NO RECYCLE-LEADS INTO HOPPER DEFINED
lead call order: order by lead_id asc
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('111') and lead_id NOT IN('97','96','95','94','93','92','91','90','89','88','87','86','85','84','83','82','81','80','79','78','77','76','75','74','73','72','71','70','69','68','67','66','65','64','63','62','61','60','59','58','57','56','55','53','54','0') 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') ) ) order by lead_id asc limit 100;|
Adding to hopper: 0
DONE with this campaign
DONE. Script execution time in seconds: 0