Vicidial vicidial_auto_calls not updating properly

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

Vicidial vicidial_auto_calls not updating properly

Postby thirdhatch » Fri Feb 03, 2017 3:18 pm

Hello,

Vicibox 6.0.2
VERSION: 2.12-538a
BUILD: 160122-1401
2X Dual Core 2.8 Ghz
4GB Memory
120GB mirrored hard Drive

We started experiencing a problem this morning where the vicidial_auto_calls table is filling up and not clearing itself out when calls are stale. This is causing issues with ratio and auto dialing because there are no more channels available to dial. I have cleared the table out manually of the stale records, but this is only a temp fix. Because the table fills up again shortly after.

Any ideas? Is a cron script not running properly?
thirdhatch
 
Posts: 96
Joined: Fri Jul 09, 2010 1:07 pm

Re: Vicidial vicidial_auto_calls not updating properly

Postby thirdhatch » Fri Feb 03, 2017 3:32 pm

It appears that the uniqueid column is not being populated on the calls that are getting stuck. Any ideas on how to fix?
thirdhatch
 
Posts: 96
Joined: Fri Jul 09, 2010 1:07 pm

Re: Vicidial vicidial_auto_calls not updating properly

Postby thirdhatch » Fri Feb 03, 2017 4:17 pm

Ok, it appears that performing the steps Matt outlines in this ticket have resolved the issue for us.
viewtopic.php?t=3694

give changing it to VARCHAR a try and post if it resolves the problem or not.

As for performance hit, I believe DOUBLEs are stored as specially formatted VARCHARs anyway.

ALTER TABLE live_inbound MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE live_inbound_log MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE live_inbound_log MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE vicidial_manager MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE vicidial_live_agents MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE vicidial_auto_calls MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE call_log DROP PRIMARY KEY;
ALTER TABLE call_log DROP INDEX uniqueid;
ALTER TABLE call_log MODIFY uniqueid VARCHAR(40) PRIMARY KEY UNIQUE NOT NULL;
ALTER TABLE park_log DROP PRIMARY KEY;
ALTER TABLE park_log DROP INDEX uniqueid;
ALTER TABLE park_log MODIFY uniqueid VARCHAR(40) PRIMARY KEY UNIQUE NOT NULL;
ALTER TABLE vicidial_log DROP PRIMARY KEY;
ALTER TABLE vicidial_log DROP INDEX uniqueid;
ALTER TABLE vicidial_log MODIFY uniqueid VARCHAR(40) PRIMARY KEY UNIQUE NOT NULL;


Thanks!
thirdhatch
 
Posts: 96
Joined: Fri Jul 09, 2010 1:07 pm

Re: Vicidial vicidial_auto_calls not updating properly

Postby williamconley » Fri Feb 03, 2017 10:53 pm

Excellent postback!
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 58 guests