Predictive Dialer Not Working

[ramizuabhalim]

Hi Support,

I have issue with the new installation for the Vicidial 11 where i cannot run the predictive dialer after upload the leads file.
I also run command this command to check

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

However, I still cannot understand what is the error.
I also have the old AST_VDhopper.pl old version is working fine.

What I did now, i just copy the old file to the new server and as for now working fine.
I still want to know why i cannot run with new file.

The new version is : version: 230428-2017
The old version is : version: 190703-1650

Campaign setting as below :-

Dial Method:
RATIO
Auto Dial Level:
1.0
Auto Dial Level Threshold:
WAITING_AGENTS
agents:
0
Available Only Tally:
Y
Available Only Tally Threshold:
WAITING_AGENTS
agents:
0


Is there i need to focus on the GUI setting on campaign part ? Maybe missed out some setting for the new vicidial.
Can advise on this?

VERSION: 2.14-895a
BUILD: 230830-1059
Version: 2.14b0.5
SVN Version: 3758
DB Schema Version: 1695
Vicibox 11 standard

[carpenox]

What's the output from running that script?

[ramizuabhalim]

Hi Carpenox,

These the output :

New version : Not working

----- DEBUG -----


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

select container_entry from vicidial_settings_containers where container_id='DNC_CURRENT_BLOCKED_LISTS' and container_entry!=''
BLOCKED LISTS: '100001', '100001', '100001', '100001', '100001', '100001', '100001', '100001', '100001'
TIME DEBUG: 8.00|8.00|0| GMT: 15:06
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2023-09-30") ) );Inactive Lists: 2
Inactive and Expired List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998') ;|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2023-09-30 23:06:20' and status IN('ACTIVE','TFHCCL') ;|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
Checking for 24-Hour Call Limit skipped leads reset: |139 = (1696086380 - 1696086241)|
---------------Auto Trim Hopper Enabled For PML_PRED---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 5

CAMPAIGNS TO PROCESS HOPPER FOR: 1|0

Starting hopper run for PML_PRED campaign- GMT: 24hours HOPPER LEVEL: 5 ORDER: DOWN|N|LEAD_ASCEND

|GMT-DAY-HOUR| |13.00-0-406||12.75-0-351||12.50-0-336||12.25-0-321||12.00-0-306||11.75-0-251||11.50-0-236||11.25-0-221||11.00-0-206||10.75-0-151||10.50-0-136||10.25-0-121||10.00-0-106||9.75-0-51||9.50-0-36||9.25-0-21||9.00-0-6||8.75-6-2351||8.50-6-2336||8.25-6-2321||8.00-6-2306||7.75-6-2251||7.50-6-2236||7.25-6-2221||7.00-6-2206||6.75-6-2151||6.50-6-2136||6.25-6-2121||6.00-6-2106||5.75-6-2051||5.50-6-2036||5.25-6-2021||5.00-6-2006||4.75-6-1951||4.50-6-1936||4.25-6-1921||4.00-6-1906||3.75-6-1851||3.50-6-1836||3.25-6-1821||3.00-6-1806||2.75-6-1751||2.50-6-1736||2.25-6-1721||2.00-6-1706||1.75-6-1651||1.50-6-1636||1.25-6-1621||1.00-6-1606||0.75-6-1551||0.50-6-1536||0.25-6-1521||0.00-6-1506||-0.25-6-1451||-0.50-6-1436||-0.75-6-1421||-1.00-6-1406||-1.25-6-1351||-1.50-6-1336||-1.75-6-1321||-2.00-6-1306||-2.25-6-1251||-2.50-6-1236||-2.75-6-1221||-3.00-6-1206||-3.25-6-1151||-3.50-6-1136||-3.75-6-1121||-4.00-6-1106||-4.25-6-1051||-4.50-6-1036||-4.75-6-1021||-5.00-6-1006||-5.25-6-951||-5.50-6-936||-5.75-6-921||-6.00-6-906||-6.25-6-851||-6.50-6-836||-6.75-6-821||-7.00-6-806||-7.25-6-751||-7.50-6-736||-7.75-6-721||-8.00-6-706||-8.25-6-651||-8.50-6-636||-8.75-6-621||-9.00-6-606||-9.25-6-551||-9.50-6-536||-9.75-6-521||-10.00-6-506||-10.25-6-451||-10.50-6-436||-10.75-6-421||-11.00-6-406||-11.25-6-351||-11.50-6-336||-11.75-6-321||-12.00-6-306||-12.25-6-251||-12.50-6-236||-12.75-6-221|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|6|5|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='PML_PRED' and status='READY';|
Processing GMT for list 100001
campaign lists count ACTIVE:1 | TOTAL:1
LIST ID SQL (list_id IN('100001')) |SELECT count(*) from vicidial_hopper where campaign_id='PML_PRED' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='PML_PRED' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='PML_PRED' and ((gmt_offset_now NOT 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 lead filter defined for campaign: PML_PRED
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('100001'))) 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: 6
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('100001'))) 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
hopper too low (0|5) starting hopper dump
Getting Leads to add to hopper
|SELECT lead_id,vendor_lead_code FROM vicidial_hopper where campaign_id='PML_PRED';|
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,vendor_lead_code,phone_code,postal_code FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('100001'))) and lead_id NOT IN('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') ) ) and list_id not in ('100001', '100001', '100001', '100001', '100001', '100001', '100001', '100001', '100001') order by lead_id asc limit 5;|
Adding to hopper: 0
vicidial_campaign_stats_debug UPDATE: 1|UPDATE vicidial_campaign_stats_debug SET entry_time='2023-09-30 23:06:20',debug_output="Starting hopper run for PML_PRED campaign- GMT: 24hours HOPPER LEVEL: 5 ORDER: DOWN|N|LEAD_ASCEND
Hopper Ready count: 0 Local Call Time: 24hours
campaign lists count ACTIVE: 1 | TOTAL: 1
leads to call count: 6
hopper too low (0|5) starting hopper dump
Recycle leads to insert into the hopper: 0
" where campaign_id='PML_PRED' and server_ip='HOPPER';|

SUMMARY: 1 campaigns
PML_PRED 6 5 0
DONE. Script execution time in seconds: 0



Old version : Working fine

----- DEBUG -----


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

TIME DEBUG: 8.00|8.00|0| GMT: 15:07
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2023-09-30") ) );Inactive Lists: 2
Inactive and Expired List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998') ;|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2023-09-30 23:07:06' and status='ACTIVE' ;|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Trim Hopper Enabled For PML_PRED---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 5

CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0

Starting hopper run for PML_PRED campaign- GMT: 24hours HOPPER: 5 ORDER: DOWN|N|LEAD_ASCEND

|GMT-DAY-HOUR| |13.00-0-407||12.75-0-352||12.50-0-337||12.25-0-322||12.00-0-307||11.75-0-252||11.50-0-237||11.25-0-222||11.00-0-207||10.75-0-152||10.50-0-137||10.25-0-122||10.00-0-107||9.75-0-52||9.50-0-37||9.25-0-22||9.00-0-7||8.75-6-2352||8.50-6-2337||8.25-6-2322||8.00-6-2307||7.75-6-2252||7.50-6-2237||7.25-6-2222||7.00-6-2207||6.75-6-2152||6.50-6-2137||6.25-6-2122||6.00-6-2107||5.75-6-2052||5.50-6-2037||5.25-6-2022||5.00-6-2007||4.75-6-1952||4.50-6-1937||4.25-6-1922||4.00-6-1907||3.75-6-1852||3.50-6-1837||3.25-6-1822||3.00-6-1807||2.75-6-1752||2.50-6-1737||2.25-6-1722||2.00-6-1707||1.75-6-1652||1.50-6-1637||1.25-6-1622||1.00-6-1607||0.75-6-1552||0.50-6-1537||0.25-6-1522||0.00-6-1507||-0.25-6-1452||-0.50-6-1437||-0.75-6-1422||-1.00-6-1407||-1.25-6-1352||-1.50-6-1337||-1.75-6-1322||-2.00-6-1307||-2.25-6-1252||-2.50-6-1237||-2.75-6-1222||-3.00-6-1207||-3.25-6-1152||-3.50-6-1137||-3.75-6-1122||-4.00-6-1107||-4.25-6-1052||-4.50-6-1037||-4.75-6-1022||-5.00-6-1007||-5.25-6-952||-5.50-6-937||-5.75-6-922||-6.00-6-907||-6.25-6-852||-6.50-6-837||-6.75-6-822||-7.00-6-807||-7.25-6-752||-7.50-6-737||-7.75-6-722||-8.00-6-707||-8.25-6-652||-8.50-6-637||-8.75-6-622||-9.00-6-607||-9.25-6-552||-9.50-6-537||-9.75-6-522||-10.00-6-507||-10.25-6-452||-10.50-6-437||-10.75-6-422||-11.00-6-407||-11.25-6-352||-11.50-6-337||-11.75-6-322||-12.00-6-307||-12.25-6-252||-12.50-6-237||-12.75-6-222|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|6|5|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='PML_PRED' and status='READY';|
Processing GMT for list 100001
campaign lists count ACTIVE:1 | TOTAL:1
LIST ID SQL (list_id IN('100001')) |SELECT count(*) from vicidial_hopper where campaign_id='PML_PRED' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='PML_PRED' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='PML_PRED' and ((gmt_offset_now NOT 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 lead filter defined for campaign: PML_PRED
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('100001'))) 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: 6
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('100001'))) 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
hopper too low (0|5) starting hopper dump
Getting Leads to add to hopper
|SELECT lead_id,vendor_lead_code FROM vicidial_hopper where campaign_id='PML_PRED';|
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,vendor_lead_code FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('NEW') and ((list_id IN('100001'))) and lead_id NOT IN('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 5;|
Adding to hopper: 5
LEAD INSERTED: 1|29|
LEAD INSERTED: 1|30|
LEAD INSERTED: 1|31|
LEAD INSERTED: 1|32|
LEAD INSERTED: 1|33|
DONE with this campaign
VLC Dup Check Rejected: 0

SUMMARY: 1 campaigns
PML_PRED 6 5 0
DONE. Script execution time in seconds: 0


Thanks in advance.

[carpenox]

Are you only trying to pull from list 10001 and the dispo of "TFHCCL"?

[ramizuabhalim]

Hi Carpenox,

Are you only trying to pull from list 10001 and the dispo of "TFHCCL"?

I just try to pull from list 10001 only. The dispo TFHCCL I did not know anything about this.
Can you advise?

[carpenox]

Nevermind about that dispo I misread the query. It looks like it's only finding 6 leads from that list that are disable statuses. You said if you copy the hopper script from old server it works or what did you do to test on the same system that worked? Message me on Skype I'll try to help you

[ramizuabhalim]

Hi Carpenox,

Noted with thanks.