This campaign has zero leads in the dial hopper

 vicidial campaign hopper leads not loading or updating

Errors:
This campaign has zero leads in the dial hopper
Sorry, there are no leads in hopper for this campaign

  Overview: Vicidial-Hopper-Campaing

    Vicidial is an enterprise class, open source, contact center suite in use by many large call centers around the world. VICIdial has a full featured predictive dialer.  It is capable of inbound, outbound, and blended phone call handling. 

    Campaign - the basic module of Vicidial, allowing for outbound calls. A user will need to log into a campaign to be able to place or receive phone calls.

   Hopper: Where the dialer temporarily places the leads, just prior to dialing them. Rather than pulling leads from the database one at a time, which is resource intensive, every 60 seconds the dialer grabs a group of leads. Once a lead is selected, the hopper script runs all of the system checks (call time, filter, DNC list, etc.) before placing it in the hopper to be dialed.

  Vicidial Hopper Issue:

You may notice below errors/message in Campaign or while logging into the agent portal
1. This campaign has 0 leads in the dial Hopper
2. Sorry, there are no leads in hopper for this campaign

  Workaround: vicidial no leads in hopper.

Below are the possible areas to check for the issue.

Campaign Settings & List settings
Database Crash
Disk space utilization
Cronjob Running
Run VDHopper script with debug
Server IP update in vicidial 
Timezone settings

   Campaign Settings:

• Check the Particular Campaign is set to ACTIVE

• Make sure New Dial Status are selected as shown below

• If you are redialing the dialed leads by resetting the list, make sure necessary dial status are added in the campaign, like no-answer,busy,callback etc

• Make sure local call time is set as per your timezone , if you are not sure set the local call time to 24 hours to make issue relate to calling time.

• Check the Minimum Hopper Level : 500

         Set this to minimum 500, as the hopper script will run every minute to fetch data from the database,so keeping to 500 or more will give good result.

• Set Y to No hooper leads Login

          Set this option, if you are using campaign only for inbound calls, or if you want your agents to login to campaign even there is no leads

• Select Force Reset of Hopper to Y and check the Hopper level in next one minute

  List Settings

• Check the List is set to Active

• check proper campaign is selected

• check the Leads are there to dial.

• make sure to reset the list if you want to redial 

  Database Crash

Due to overload or im-porper shutdown or lack of disk space of the system leads to Mysql/maria db crash
Check out the below link for Database related stuff.

Database repair LINK

Deleting Old Call Logs of Database LINK

Avoiding the Database crash LINK

  Disk space 100%/full

Due to lack of disk space, the mysql/mariadb become inoperative ,and failed to fetch data for Hopper script, 
So check the disk space by typing the linux command

df -h

if the disk if full, better increase the disk size or delete the old data's like

Old Call Recordings LINK

Old Call Logs in mysql LINK

System Logs under /var/log

  Cronjob : AST_VDhopper.pl 

Make sure the AST_VDhopper.pl script entry is there in crontab

type below command to enter to crontab

crontab -e

make sure below entry is there

* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q

if this line is missing or the crontab is empty better copy the cronjob entries from this LINK

  AST_VDhopper Script with Debug

If above said Troubleshoot are not working ,better run the VD hopper script with debug ,where you will get clue for empty hopper

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

  Server IP update in DB:

If you have changed the server ip , then you have to update the new ip in the vicidial db by running below command

/usr/share/astguiclient/ADMIN_update_server_ip.pl

Once you have follow above troubleshoots , reboot the server  once and check the hopper status

  System Time and Timezone:

Make sure you server is set with proper timezone,
command to check the linux time

date

Check the vicidial GMT offset
navigate to 

ADMIN > Servers
Local GMT :-5.50 
ADMIN > System Settings
Default Local GMT: -5.50

update the timezone in php.ini file in the blow line

date.timezone = America/NewYork 

Also Run the below script once and reupload leads, make sure the GMT set to proper timezone according to country or area code.

/usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table –debug

test if any errors by running below script

 /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debug --list-settings

  Conclusion:

If you like my post, kindly share and subscribe.

for professional support reach me at skype:striker24x7