vicidial.org

Dear mflorell,
I am using vicidial scratch installed VERSION: 2.7-401a BUILD: 130508-2256 , with centos and the CRON has AST_reset_mysql_vars.pl script which every day night logs-out all the agents and cannot do any calls for 2 minutes till the database gets optimized.

### reset several temporary-info tables in the database
2 1 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl


i have read the script and found the optimization script deletes entries in vicidial_auto_calls and vicidial_live_agents tables.So i commented those entries

## $stmtA = "DELETE from vicidial_auto_calls where server_ip='$server_ip';";
## if($DB){print STDERR "\n|$stmtA|\n";}
## $affected_rows = $dbhA->do($stmtA); # or die "Couldn't execute query: |$stmtA|\n";
## print " - vicidial_auto_calls delete\n";

## $stmtA = "DELETE from vicidial_live_agents where server_ip='$server_ip';";
## if($DB){print STDERR "\n|$stmtA|\n";}
## $affected_rows = $dbhA->do($stmtA); # or die "Couldn't execute query: |$stmtA|\n";
## print " - vicidial_live_agents delete\n";

After commenting the entries i found that agents are not logging out and agents who are in live calls are not disturbed.But calls waiting in the in-group does not land to the waiting agents for 2 minutes until the dabase tables are optimized.Also agents cannot dial any new manual calls or conference calls for that 2 minutes.
So please guide me whether this script is mandatory and need to run every day ? it is there any solution for this? as my call-center is 24/7 i cannot ave this downtime.

I had same issue its solved. Don't do any changes in script file. Just change cron time. Looks like your server have IST time and you are dialing for USA. Just change cron time like run when you are not dialing. Below link will help you more.

http://vicidial.org/VICIDIALforum/viewtopic.php?f=4&t=13747&p=129861#p55068

Dear Udy,
My script is actually running at 2:59 am IST and my process is 24/7 incoming and cannot have down time or not dialing time.
What will be the problem if i dont run this script ?

### reset several temporary-info tables in the database
59 02 * * * /usr/share/astguiclient/AST_reset_mysql_vars.pl

Hi mflorell,

Can i run this script every week and not every day ? what will be the effect...........

Yes, you can run it weekly. We have done this for several clients and as long as it's not a heavy-dialing server, it should be fine.

Hi mflorell,
Thanks for the response,ours is a huge incoming call centre with 20 thousand calls a day.What could be impact of running it every week.

20,000/day shouldn't be a problem. Give it a try and see if you have any issues.

Yes will try and update the results

arunkooods wrote:Yes will try and update the results

If it does present a problem: Consider changing those queries to include a date statement that would make it unlikely (impossible?) for the records to be valid. For instance: An auto-call should never be older than the longest call you've ever made. And the live agents table should never have a record in it older than your longest shift.

Not a perfect solution, but may allow you to run for a lot longer without a full reset before a problem arises (perhaps forever).