Leads are not loaded in dial hopper

[Sufyan]

When i load new leads in the list, it shows leads are successfully load, but the dial hopper is empty.

[mflorell]

What is the output of the following comand when you run it:

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

[Sufyan]

[root@vici ~]# /usr/share/astguiclient/AST_VDhopper.pl --debug

----- DEBUG -----

TIME DEBUG: -5|-5|0| GMT: 03:39
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0
CALLBACK HOLD: 31|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-02-12 22:39:52' and status='ACTIVE';|
DBD::mysql::st execute failed: Table 'asterisk.vicidial_list' doesn't exist at /usr/share/astguiclient/AST_VDhopper.pl line 318.
executing: SELECT vicidial_callbacks.lead_id,recipient,campaign_id,vicidial_callbacks.list_id,gmt_offset_now,state FROM vicidial_callbacks,vicidial_list where callback_time <= '2009-02-12 22:39:52' and vicidial_callbacks.status='ACTIVE' and vicidial_callbacks.lead_id=vicidial_list.lead_id; Table 'asterisk.vicidial_list' doesn't exist at /usr/share/astguiclient/AST_VDhopper.pl line 318.

[mcargile]

This looks like either you did not create the database properly or you have wrong settings in your astguiclient.conf file.

[Sufyan]

i have the vicidialnow, The db might be different as compare to vicidial.

i face the cited problem since last week, otherwise my server work perfectly. if the astguiclient.conf settings are wrong or database not created properly how can i make calls earlier.

[williamconley]

your system says the vicidial_list table no longer exists. obviously there is something wrong.

Table 'asterisk.vicidial_list' doesn't exist at /usr/share/astguiclient/AST_VDhopper.pl line 318

find out if it is actually Gone first, so start here:

mysql -p

mysql> use asterisk;

mysql> show tables;

if it is, indeed, gone ... noone outside your organization is likely to know what happened. change your passwords.

[Sufyan]

[root@vici ~]# mysql -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[williamconley]

you need to know your mysql password i'm not sure it's appropriate to post it on the forum.

[Sufyan]

If your not sure to post in the forum, kindly send it to my e-mail

I am waiting for your reply

[williamconley]

lol

i said YOU need to know your password for mysql.

i didn't say I do.

if *I* know your password for mysql and *YOU* don't ... something is seriously wrong with this picture.

[Sufyan]

is this possible to restore or recover vicidial at previous state (1 month before)

[mflorell]

If you took a snapshot of the database at that time then yes.

Please do not double/triple post

[ykhan]

My issue is somewhat similar in nature. The hopper is not loading. I get this output when I run the hopper script in debug:

Code: Select all

----- DEBUG -----

TIME DEBUG: -5|-5|0|   GMT: 05:15
SELECT * FROM vicidial_lists where active='N';Inactive Lists:  3
Inactive List Leads Deleted:  0E0 |DELETE from vicidial_hopper where list_id IN('999','1000','1002');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-02-26 0:15:27' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR:  1|0
Starting hopper run for TEST2 campaign- GMT: 9am-9pm   HOPPER: 10
     hopper DONE cleared:  0E0
     hopper GMT BAD cleared:  0E0
     hopper READY count:   0
     hopper too low (0|10) starting hopper dump
     campaign lists count: 1 | '9876'
     no lead filter defined for campaign: TEST2
     leads to call count:  0
     [b]NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
     ERROR CANNOT ADD ANY LEADS TO HOPPER[/b]
DONE. Script execution time in seconds: 0


I did not do the install, but its an install based on VicidialNOW 1.1.

[mflorell]

OK, looks like there are no active leads to dial, what's the problem?

[ykhan]

On the campaign page I have the following:

Code: Select all

This campaign has 1 active lists and 1 inactive lists

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

This campaign has 0 leads in the dial hopper


There are 13 leads in the hopper but hopper is not loading them.

[mflorell]

First I would recommend upgrading to astguiclient 2.0.4.1rc5.

After that if you still see the problem, run this and post the results:

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

[asteriskvairam]

Have you installed All perl module which is given in the installation document.
Kindly recheck.Could be the problem with Perl DBD::mysql module

Thanks

Vairam k

[ykhan]

I am getting this error and no leads are loaded into the hopper:

Code: Select all

SELECT * FROM vicidial_lists where active='N';Inactive Lists:  2
Inactive List Leads Deleted:  0E0 |DELETE from vicidial_hopper where list_id IN('555','1515');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-04-20 13:17:12' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR:  1|0

   |GMT-DAY-HOUR|   |13.00-1-1947||12.75-1-1932||12.50-1-1917||12.25-1-1902||12.00-1-1847||11.75-1-1832||11.50-1-1817||11.25-1-1802||11.00-1-1747||10.75-1-1732||10.50-1-1717||10.25-1-1702||10.00-1-1647||9.75-1-1632||9.50-1-1617||9.25-1-1602||9.00-1-1547||8.75-1-1532||8.50-1-1517||8.25-1-1502||8.00-1-1447||7.75-1-1432||7.50-1-1417||7.25-1-1402||7.00-1-1347||6.75-1-1332||6.50-1-1317||6.25-1-1302||6.00-1-1247||5.75-1-1232||5.50-1-1217||5.25-1-1202||5.00-1-1147||4.75-1-1132||4.50-1-1117||4.25-1-1102||4.00-1-1047||3.75-1-1032||3.50-1-1017||3.25-1-1002||3.00-1-947||2.75-1-932||2.50-1-917||2.25-1-902||2.00-1-847||1.75-1-832||1.50-1-817||1.25-1-802||1.00-1-747||0.75-1-732||0.50-1-717||0.25-1-702||0.00-1-647||-0.25-1-632||-0.50-1-617||-0.75-1-602||-1.00-1-547||-1.25-1-532||-1.50-1-517||-1.75-1-502||-2.00-1-447||-2.25-1-432||-2.50-1-417||-2.75-1-402||-3.00-1-347||-3.25-1-332||-3.50-1-317||-3.75-1-302||-4.00-1-247||-4.25-1-232||-4.50-1-217||-4.75-1-202||-5.00-1-147||-5.25-1-132||-5.50-1-117||-5.75-1-102||-6.00-1-47||-6.25-1-32||-6.50-1-17||-6.75-1-2||-7.00-0-2347||-7.25-0-2332||-7.50-0-2317||-7.75-0-2302||-8.00-0-2247||-8.25-0-2232||-8.50-0-2217||-8.75-0-2202||-9.00-0-2147||-9.25-0-2132||-9.50-0-2117||-9.75-0-2102||-10.00-0-2047||-10.25-0-2032||-10.50-0-2017||-10.75-0-2002||-11.00-0-1947||-11.25-0-1932||-11.50-0-1917||-11.75-0-1902||-12.00-0-1847||-12.25-0-1832||-12.50-0-1817||-12.75-0-1802|
   |SELECT * FROM vicidial_call_times where call_time_id='9am-9pm';|
LocalCallTime No-Call Gap: |43200|2100(21 00)|0900(09 00)|1|0|
Starting hopper run for HSH2 campaign- GMT: 9am-9pm   HOPPER: 50   ORDER: DOWN COUNT 2nd NEW
     hopper DONE cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='HSH2' and status IN('DONE');|
     hopper GMT BAD cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='HSH2' and ((gmt_offset_now IN('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','99') ) );|
     hopper READY count:   0
     |SELECT count(*) from vicidial_hopper where campaign_id='HSH2' and status='READY';|
     hopper too low (0|50) starting hopper dump
     campaign lists count: 1 | '1003'
     |SELECT list_id FROM vicidial_lists where campaign_id='HSH2' and active='Y';|
     no lead filter defined for campaign: HSH2
     |NONE|
     |SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('CALLBK','NEW') and list_id IN('1003') 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') ) ) ;|
     leads to call count:  0
     |SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('CALLBK','NEW') and list_id IN('1003') 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') ) ) ;|
     NEW leads to call count:  0
     |SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('1003') 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') ) ) ;|
     ERROR CANNOT ADD ANY NEW LEADS TO HOPPER
     ERROR CANNOT ADD ANY LEADS TO HOPPER
DONE. Script execution time in seconds: 0

[mflorell]

Have you tried to run any of the queries shown there to see if they yield results or not in mysql?

[jjohnson78]

Have you gotten this list to load successfully into the hopper earlier? If so, check the "Lead Called" status for the leads in it. You have to reset the "Lead-Called-Status for this list" before you can go through that list again, if you already burned through the leads before without resetting.

Also, if you're using a List Order like "DOWN COUNT 2nd NEW/3rd NEW/etc" (check this in the Modify Campaign screen), make sure you DON'T use NEW as a dialable status. I've never done that myself, so I don't know if it would cause the problem you're describing.

[jjohnson78]

Oh, I think there may be one other thing you have to check. Is the server you are running the VDhopper script from in the servers table in your asterisk database? If it ISN'T, when the VDhopper script runs from that server, it will assume Greenwich Mean Time, which could seriously throw off the leads that are being pulled and kept in the hopper. Unless you already live on GMT where you're located, of course.

Check what servers are listed under the Admin => Servers section from the vicidial admin page. If the IP address of the server you are running this from is NOT in there, you will either have to add an entry for it or run the VDhopper script from a server that is already listed in the Servers section. And the server you do run this from needs to have the correct "Local GMT" value set.

[Ivanchomg]

From time to time I could not upload leads, I need urgent help in this matter, I would.


TIME DEBUG: ||0| GMT: 15:59
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-06-08 15:59:07' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0

|GMT-DAY-HOUR| |13.00-2-459||12.75-2-444||12.50-2-429||12.25-2-414||12.00-2-359||11.75-2-344||11.50-2-329||11.25-2-314||11.00-2-259||10.75-2-244||10.50-2-229||10.25-2-214||10.00-2-159||9.75-2-144||9.50-2-129||9.25-2-114||9.00-2-59||8.75-2-44||8.50-2-29||8.25-2-14||8.00-1-2359||7.75-1-2344||7.50-1-2329||7.25-1-2314||7.00-1-2259||6.75-1-2244||6.50-1-2229||6.25-1-2214||6.00-1-2159||5.75-1-2144||5.50-1-2129||5.25-1-2114||5.00-1-2059||4.75-1-2044||4.50-1-2029||4.25-1-2014||4.00-1-1959||3.75-1-1944||3.50-1-1929||3.25-1-1914||3.00-1-1859||2.75-1-1844||2.50-1-1829||2.25-1-1814||2.00-1-1759||1.75-1-1744||1.50-1-1729||1.25-1-1714||1.00-1-1659||0.75-1-1644||0.50-1-1629||0.25-1-1614||0.00-1-1559||-0.25-1-1544||-0.50-1-1529||-0.75-1-1514||-1.00-1-1459||-1.25-1-1444||-1.50-1-1429||-1.75-1-1414||-2.00-1-1359||-2.25-1-1344||-2.50-1-1329||-2.75-1-1314||-3.00-1-1259||-3.25-1-1244||-3.50-1-1229||-3.75-1-1214||-4.00-1-1159||-4.25-1-1144||-4.50-1-1129||-4.75-1-1114||-5.00-1-1059||-5.25-1-1044||-5.50-1-1029||-5.75-1-1014||-6.00-1-959||-6.25-1-944||-6.50-1-929||-6.75-1-914||-7.00-1-859||-7.25-1-844||-7.50-1-829||-7.75-1-814||-8.00-1-759||-8.25-1-744||-8.50-1-729||-8.75-1-714||-9.00-1-659||-9.25-1-644||-9.50-1-629||-9.75-1-614||-10.00-1-559||-10.25-1-544||-10.50-1-529||-10.75-1-514||-11.00-1-459||-11.25-1-444||-11.50-1-429||-11.75-1-414||-12.00-1-359||-12.25-1-344||-12.50-1-329||-12.75-1-314|
|SELECT * FROM vicidial_call_times where call_time_id='12pm-5pm';|
Starting hopper run for mauricio campaign- GMT: 12pm-5pm HOPPER: 2000
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='mauricio' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='mauricio' 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','-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='mauricio' and status='READY';|
hopper too low (0|2000) starting hopper dump
campaign lists count: 1 | '102'
|SELECT list_id FROM vicidial_lists where campaign_id='mauricio' and active='Y';|
no lead filter defined for campaign: mauricio
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('102') and ((gmt_offset_now IN('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','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('102') and ((gmt_offset_now IN('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','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

[williamconley]

|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('102') and ((gmt_offset_now IN('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','99') ) ) ;|
leads to call count: 0

this says that there are no leads to dial, right?

check the campaign to see if it says it has leads. Apparently the only list you have active in the campaign is "102" and it has a limit on the local time of the call.

try running this same query (or the new version from your live system as it would execute now, from the same log file) directly from mysql and see if you get the same results. there is a reason it comes back "0". modify your query until you find the reason.

of course, you could also set it to 24 hour dialing for now to see if the time of day is the issue.

[Ivanchomg]

*s

[williamconley]

Wow.