vicidial.org

by **artimus** » Wed Nov 07, 2007 5:38 pm

We have had several problems where we have clear out the auto_calls table. Most of which we have fixed by scrubbing numbers in the list loader.

However it seems that manual campaigns do not clean up after themselves. I don't mind having to run a cleanup cron every 5 minutes, but I want to make sure I am doing it safely.

What I did this time was:

Code: Select all: delete from vicidial_auto_calls where phone_code != 1; --this is safe for me delete from vicidial_auto_calls where last_update_time < NOW() - interval 90 minute; -- not too fond of this one... if someone is on a call for >90 minutes i think they will end up getting multiple calls at once. delete from vicidial_auto_calls where channel is null; -- yeah that one cleared a lot... but I fear that it could be very dangerous.

Heres whats consistant of the records stuck in that table.
They are all in a manual campaign.
status="XFER"
channel is null
call_type="OUT"
stage="OUT"

Could someone help me identify what is safe to delete. Is a null channel a safe thing to look for, or could i accidentally be delete calls that are just about to dial out?

Or even better, does anyone know why the record didn't clear out in the first place.

by **mflorell** » Thu Nov 08, 2007 12:52 pm

MySQL version?

can you post the content of the vicidial_auto_calls records?

by **artimus** » Fri Nov 09, 2007 9:59 am

MySQL 5.0.27. Installed on another local box rather then the dialer.

below is dump from the next day when it happened again. In my original post the record count as 126. This is a bit bigger, but still the same problem.

For security purposes i have changed the phone_number field.

Code: Select all: -- -- Dumping data for table `vicidial_auto_calls` -- INSERT INTO `vicidial_auto_calls` VALUES (27632,'10.0.0.10','MANUAL_B','XFER',138085,1194555626.9182601,'M1108065015000138085',NULL,'1','9998887777','2007-11-08 06:50:15','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (29596,'10.0.0.10','MANUAL_B','XFER',171433,1194542072.7430401,'M1108091432000171433',NULL,'1','9998887777','2007-11-08 09:14:32','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (30490,'10.0.0.10','MANUAL_B','XFER',138085,1194555626.9182601,'M1108094057000138085',NULL,'1','9998887777','2007-11-08 09:40:57','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (27973,'10.0.0.10','MANUAL_B','XFER',128579,1194535411.6840799,'M1108072331000128579',NULL,'1','9998887777','2007-11-08 07:23:31','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (28430,'10.0.0.10','MANUAL_B','XFER',136962,1194551423.8871200,'M1108080847000136962',NULL,'1','9998887777','2007-11-08 08:08:47','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (28493,'10.0.0.10','MANUAL_B','XFER',152016,1194538481.7013199,'M1108081441000152016',NULL,'1','9998887777','2007-11-08 08:14:41','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (28508,'10.0.0.10','MANUAL_B','XFER',138085,1194555626.9182601,'M1108081730000138085',NULL,'1','9998887777','2007-11-08 08:17:30','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (28481,'10.0.0.10','MANUAL_B','XFER',152016,1194538481.7013199,'M1108081330000152016',NULL,'1','9998887777','2007-11-08 08:13:30','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (29657,'10.0.0.10','MANUAL_B','XFER',173022,1194542224.7450800,'M1108091704000173022',NULL,'1','9998887777','2007-11-08 09:17:04','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (29354,'10.0.0.10','MANUAL_B','XFER',136006,1194543574.7710299,'M1108090227000136006',NULL,'1','9998887777','2007-11-08 09:02:27','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (29764,'10.0.0.10','MANUAL_B','XFER',173025,1194542487.7487199,'M1108092127000173025',NULL,'1','9998887777','2007-11-08 09:21:27','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (29900,'10.0.0.10','MANUAL_B','XFER',171434,1194542725.7534201,'M1108092525000171434',NULL,'1','9998887777','2007-11-08 09:25:25','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (31479,'10.0.0.10','MANUAL_B','XFER',158255,1194545108.8066199,'M1108100507000158255',NULL,'1','9998887777','2007-11-08 10:05:07','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (30398,'10.0.0.10','MANUAL_B','XFER',173049,1194543535.7701700,'M1108093855000173049',NULL,'1','9998887777','2007-11-08 09:38:55','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (30082,'10.0.0.10','MANUAL_B','XFER',173032,1194543031.7596500,'M1108093030000173032',NULL,'1','9998887777','2007-11-08 09:30:30','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (30571,'10.0.0.10','MANUAL_B','XFER',128596,1194554628.9151800,'M1108094315000128596',NULL,'1','9998887777','2007-11-08 09:43:15','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (30685,'10.0.0.10','MANUAL_B','XFER',136991,1194543948.7798200,'M1108094548000136991',NULL,'1','9998887777','2007-11-08 09:45:48','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (29838,'10.0.0.10','MANUAL_B','XFER',173027,1194542631.7513399,'M1108092351000173027',NULL,'1','9998887777','2007-11-08 09:23:51','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (30624,'10.0.0.10','MANUAL_B','XFER',135925,1194554916.9159801,'M1108094416000135925',NULL,'1','9998887777','2007-11-08 09:44:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (30422,'10.0.0.10','MANUAL_B','XFER',136006,1194543574.7710299,'M1108093934000136006',NULL,'1','9998887777','2007-11-08 09:39:34','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (29953,'10.0.0.10','MANUAL_B','XFER',173029,1194542821.7551701,'M1108092701000173029',NULL,'1','9998887777','2007-11-08 09:27:01','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (31425,'10.0.0.10','MANUAL_B','XFER',151048,1194547576.8353000,'M1108100306000151048',NULL,'1','9998887777','2007-11-08 10:03:06','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (32215,'10.0.0.10','MANUAL_B','XFER',155461,1194547377.8333001,'M1108104257000155461',NULL,'1','9998887777','2007-11-08 10:42:57','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (31951,'10.0.0.10','MANUAL_B','XFER',173076,1194546382.8236699,'M1108102621000173076',NULL,'1','9998887777','2007-11-08 10:26:21','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34013,'10.0.0.10','MANUAL_B','XFER',150973,1194552448.9000900,'M1108120426000150973',NULL,'1','9998887777','2007-11-08 12:04:26','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34483,'10.0.0.10','MANUAL_B','XFER',128596,1194554628.9151800,'M1108124259000128596',NULL,'1','9998887777','2007-11-08 12:42:59','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34054,'10.0.0.10','MANUAL_B','XFER',150973,1194552448.9000900,'M1108120727000150973',NULL,'1','9998887777','2007-11-08 12:07:27','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (31629,'10.0.0.10','MANUAL_B','XFER',138085,1194555626.9182601,'M1108101108000138085',NULL,'1','9998887777','2007-11-08 10:11:08','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (32721,'10.0.0.10','MANUAL_B','XFER',138085,1194555626.9182601,'M1108110526000138085',NULL,'1','9998887777','2007-11-08 11:05:26','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (32269,'10.0.0.10','MANUAL_B','XFER',151048,1194547576.8353000,'M1108104615000151048',NULL,'1','9998887777','2007-11-08 10:46:15','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (32803,'10.0.0.10','MANUAL_B','XFER',138085,1194555626.9182601,'M1108110914000138085',NULL,'1','9998887777','2007-11-08 11:09:14','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34517,'10.0.0.10','MANUAL_B','XFER',173149,1194554992.9163101,'M1108124951000173149',NULL,'1','9998887777','2007-11-08 12:49:51','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (33977,'10.0.0.10','MANUAL_B','XFER',150973,1194552448.9000900,'M1108120242000150973',NULL,'1','9998887777','2007-11-08 12:02:42','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (33823,'10.0.0.10','MANUAL_B','XFER',138085,1194555626.9182601,'M1108115619000138085',NULL,'1','9998887777','2007-11-08 11:56:19','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (33954,'10.0.0.10','MANUAL_B','XFER',135925,1194554916.9159801,'M1108120135000135925',NULL,'1','9998887777','2007-11-08 12:01:35','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34051,'10.0.0.10','MANUAL_B','XFER',150973,1194552448.9000900,'M1108120716000150973',NULL,'1','9998887777','2007-11-08 12:07:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34052,'10.0.0.10','MANUAL_B','XFER',150973,1194552448.9000900,'M1108120716000150973',NULL,'1','9998887777','2007-11-08 12:07:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34491,'10.0.0.10','MANUAL_B','XFER',173143,1194554793.9154201,'M1108124633000173143',NULL,'1','9998887777','2007-11-08 12:46:33','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34478,'10.0.0.10','MANUAL_B','XFER',135944,1194554464.9148901,'M1108124103000135944',NULL,'1','9998887777','2007-11-08 12:41:03','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34477,'10.0.0.10','MANUAL_B','XFER',173139,1194554380.9148500,'M1108123940000173139',NULL,'1','9998887777','2007-11-08 12:39:40','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34479,'10.0.0.10','MANUAL_B','XFER',173140,1194554474.9149201,'M1108124114000173140',NULL,'1','9998887777','2007-11-08 12:41:14','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34480,'10.0.0.10','MANUAL_B','XFER',151033,1194554483.9149699,'M1108124123000151033',NULL,'1','9998887777','2007-11-08 12:41:23','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34481,'10.0.0.10','MANUAL_B','XFER',135925,1194554916.9159801,'M1108124149000135925',NULL,'1','9998887777','2007-11-08 12:41:49','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34597,'10.0.0.10','MANUAL_B','XFER',121037,1194556217.9192901,'M1108131016000121037',NULL,'1','9998887777','2007-11-08 13:10:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (33616,'10.0.0.10','MANUAL_B','XFER',136962,1194551423.8871200,'M1108114720000136962',NULL,'1','9998887777','2007-11-08 11:47:20','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34500,'10.0.0.10','MANUAL_B','XFER',158272,1194554859.9157500,'M1108124739000158272',NULL,'1','9998887777','2007-11-08 12:47:39','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34487,'10.0.0.10','MANUAL_B','XFER',82215,1194554676.9152901,'M1108124435000082215',NULL,'1','9998887777','2007-11-08 12:44:35','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34484,'10.0.0.10','MANUAL_B','XFER',122623,1194554594.9151499,'M1108124314000122623',NULL,'1','9998887777','2007-11-08 12:43:14','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34027,'10.0.0.10','MANUAL_B','XFER',150973,1194552448.9000900,'M1108120517000150973',NULL,'1','9998887777','2007-11-08 12:05:17','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34503,'10.0.0.10','MANUAL_B','XFER',173146,1194554868.9158399,'M1108124748000173146',NULL,'1','9998887777','2007-11-08 12:47:48','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34501,'10.0.0.10','MANUAL_B','XFER',173144,1194554860.9157901,'M1108124740000173144',NULL,'1','9998887777','2007-11-08 12:47:40','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34486,'10.0.0.10','MANUAL_B','XFER',128565,1194554648.9152100,'M1108124408000128565',NULL,'1','9998887777','2007-11-08 12:44:08','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (33697,'10.0.0.10','MANUAL_B','XFER',136962,1194551423.8871200,'M1108115023000136962',NULL,'1','9998887777','2007-11-08 11:50:23','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34511,'10.0.0.10','MANUAL_B','XFER',173148,1194554945.9161301,'M1108124905000173148',NULL,'1','9998887777','2007-11-08 12:49:05','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34504,'10.0.0.10','MANUAL_B','XFER',173141,1194554883.9158700,'M1108124802000173141',NULL,'1','9998887777','2007-11-08 12:48:02','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34489,'10.0.0.10','MANUAL_B','XFER',173142,1194554753.9153500,'M1108124552000173142',NULL,'1','9998887777','2007-11-08 12:45:52','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34490,'10.0.0.10','MANUAL_B','XFER',153419,1194554783.9153900,'M1108124622000153419',NULL,'1','9998887777','2007-11-08 12:46:22','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34505,'10.0.0.10','MANUAL_B','XFER',173147,1194554883.9159000,'M1108124802000173147',NULL,'1','9998887777','2007-11-08 12:48:02','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34551,'10.0.0.10','MANUAL_B','XFER',173161,1194555358.9175999,'M1108125558000173161',NULL,'1','9998887777','2007-11-08 12:55:58','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34507,'10.0.0.10','MANUAL_B','XFER',135925,1194554916.9159801,'M1108124836000135925',NULL,'1','9998887777','2007-11-08 12:48:36','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34572,'10.0.0.10','MANUAL_B','XFER',173169,1194555654.9182899,'M1108130054000173169',NULL,'1','9998887777','2007-11-08 13:00:54','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34499,'10.0.0.10','MANUAL_B','XFER',128556,1194554843.9157200,'M1108124723000128556',NULL,'1','9998887777','2007-11-08 12:47:23','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34488,'10.0.0.10','MANUAL_B','XFER',173141,1194554883.9158700,'M1108124505000173141',NULL,'1','9998887777','2007-11-08 12:45:05','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34482,'10.0.0.10','MANUAL_B','XFER',151034,1194554558.9150500,'M1108124238000151034',NULL,'1','9998887777','2007-11-08 12:42:38','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34502,'10.0.0.10','MANUAL_B','XFER',173145,NULL,'M1108124746000173145',NULL,'1','9998887777','2007-11-08 12:47:46','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34541,'10.0.0.10','MANUAL_B','XFER',173158,1194555277.9172699,'M1108125436000173158',NULL,'1','9998887777','2007-11-08 12:54:36','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34485,'10.0.0.10','MANUAL_B','XFER',128596,1194554628.9151800,'M1108124348000128596',NULL,'1','9998887777','2007-11-08 12:43:48','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34521,'10.0.0.10','MANUAL_B','XFER',173150,1194555019.9164400,'M1108125018000173150',NULL,'1','9998887777','2007-11-08 12:50:18','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34561,'10.0.0.10','MANUAL_B','XFER',136254,1194555514.9179201,'M1108125833000136254',NULL,'1','9998887777','2007-11-08 12:58:33','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34528,'10.0.0.10','MANUAL_B','XFER',125421,1194555130.9168100,'M1108125210000125421',NULL,'1','9998887777','2007-11-08 12:52:10','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34518,'10.0.0.10','MANUAL_B','XFER',121036,1194554993.9163401,'M1108124953000121036',NULL,'1','9998887777','2007-11-08 12:49:53','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34522,'10.0.0.10','MANUAL_B','XFER',173151,NULL,'M1108125122000173151',NULL,'1','9998887777','2007-11-08 12:51:22','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34523,'10.0.0.10','MANUAL_B','XFER',173152,1194555086.9166100,'M1108125126000173152',NULL,'1','9998887777','2007-11-08 12:51:26','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34524,'10.0.0.10','MANUAL_B','XFER',173153,1194555088.9166400,'M1108125128000173153',NULL,'1','9998887777','2007-11-08 12:51:28','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34526,'10.0.0.10','MANUAL_B','XFER',173154,1194555103.9167299,'M1108125143000173154',NULL,'1','9998887777','2007-11-08 12:51:43','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34531,'10.0.0.10','MANUAL_B','XFER',10131,1194555145.9169099,'M1108125225000010131',NULL,'1','9998887777','2007-11-08 12:52:25','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34532,'10.0.0.10','MANUAL_B','XFER',173155,1194555179.9169500,'M1108125258000173155',NULL,'1','9998887777','2007-11-08 12:52:58','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34533,'10.0.0.10','MANUAL_B','XFER',138507,1194555181.9169900,'M1108125301000138507',NULL,'1','9998887777','2007-11-08 12:53:01','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34534,'10.0.0.10','MANUAL_B','XFER',173156,1194555207.9170301,'M1108125327000173156',NULL,'1','9998887777','2007-11-08 12:53:27','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34535,'10.0.0.10','MANUAL_B','XFER',154573,1194555208.9170599,'M1108125328000154573',NULL,'1','9998887777','2007-11-08 12:53:28','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34540,'10.0.0.10','MANUAL_B','XFER',173157,1194555276.9172399,'M1108125436000173157',NULL,'1','9998887777','2007-11-08 12:54:36','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34556,'10.0.0.10','MANUAL_B','XFER',173163,1194555464.9177699,'M1108125744000173163',NULL,'1','9998887777','2007-11-08 12:57:44','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34543,'10.0.0.10','MANUAL_B','XFER',173159,1194555278.9173300,'M1108125437000173159',NULL,'1','9998887777','2007-11-08 12:54:37','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34574,'10.0.0.10','MANUAL_B','XFER',173170,1194555742.9184101,'M1108130222000173170',NULL,'1','9998887777','2007-11-08 13:02:22','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34546,'10.0.0.10','MANUAL_B','XFER',151025,1194555317.9174500,'M1108125516000151025',NULL,'1','9998887777','2007-11-08 12:55:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34547,'10.0.0.10','MANUAL_B','XFER',173160,1194555317.9174800,'M1108125517000173160',NULL,'1','9998887777','2007-11-08 12:55:17','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34570,'10.0.0.10','MANUAL_B','XFER',173168,1194555610.9182301,'M1108130010000173168',NULL,'1','9998887777','2007-11-08 13:00:10','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34555,'10.0.0.10','MANUAL_B','XFER',151754,1194555436.9177401,'M1108125716000151754',NULL,'1','9998887777','2007-11-08 12:57:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34558,'10.0.0.10','MANUAL_B','XFER',173164,1194555481.9178300,'M1108125801000173164',NULL,'1','9998887777','2007-11-08 12:58:01','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34559,'10.0.0.10','MANUAL_B','XFER',173165,1194555501.9178600,'M1108125821000173165',NULL,'1','9998887777','2007-11-08 12:58:21','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34560,'10.0.0.10','MANUAL_B','XFER',151027,1194555503.9178901,'M1108125823000151027',NULL,'1','9998887777','2007-11-08 12:58:23','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34567,'10.0.0.10','MANUAL_B','XFER',173166,1194555554.9181099,'M1108125914000173166',NULL,'1','9998887777','2007-11-08 12:59:14','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34573,'10.0.0.10','MANUAL_B','XFER',156011,1194555737.9183800,'M1108130217000156011',NULL,'1','9998887777','2007-11-08 13:02:17','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34569,'10.0.0.10','MANUAL_B','XFER',173167,1194555571.9181800,'M1108125931000173167',NULL,'1','9998887777','2007-11-08 12:59:31','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34571,'10.0.0.10','MANUAL_B','XFER',138085,1194555626.9182601,'M1108130025000138085',NULL,'1','9998887777','2007-11-08 13:00:25','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34575,'10.0.0.10','MANUAL_B','XFER',128578,1194555801.9184501,'M1108130321000128578',NULL,'1','9998887777','2007-11-08 13:03:21','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34576,'10.0.0.10','MANUAL_B','XFER',106187,1194555805.9184899,'M1108130325000106187',NULL,'1','9998887777','2007-11-08 13:03:25','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34577,'10.0.0.10','MANUAL_B','XFER',173171,NULL,'M1108130345000173171',NULL,'1','9998887777','2007-11-08 13:03:45','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34578,'10.0.0.10','MANUAL_B','XFER',173171,NULL,'M1108130345000173171',NULL,'1','9998887777','2007-11-08 13:03:45','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34579,'10.0.0.10','MANUAL_B','XFER',106188,1194555832.9185901,'M1108130352000106188',NULL,'1','9998887777','2007-11-08 13:03:52','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34580,'10.0.0.10','MANUAL_B','XFER',106189,1194555845.9186201,'M1108130405000106189',NULL,'1','9998887777','2007-11-08 13:04:05','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34581,'10.0.0.10','MANUAL_B','XFER',151060,1194555849.9186499,'M1108130409000151060',NULL,'1','9998887777','2007-11-08 13:04:09','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34582,'10.0.0.10','MANUAL_B','XFER',128577,1194555857.9186800,'M1108130417000128577',NULL,'1','9998887777','2007-11-08 13:04:17','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34583,'10.0.0.10','MANUAL_B','XFER',136055,1194555873.9187100,'M1108130432000136055',NULL,'1','9998887777','2007-11-08 13:04:32','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34584,'10.0.0.10','MANUAL_B','XFER',128569,1194555877.9187400,'M1108130437000128569',NULL,'1','9998887777','2007-11-08 13:04:37','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34585,'10.0.0.10','MANUAL_B','XFER',173172,1194555889.9187901,'M1108130449000173172',NULL,'1','9998887777','2007-11-08 13:04:49','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34586,'10.0.0.10','MANUAL_B','XFER',173173,1194555908.9188199,'M1108130508000173173',NULL,'1','9998887777','2007-11-08 13:05:08','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34587,'10.0.0.10','MANUAL_B','XFER',151077,1194555962.9188700,'M1108130602000151077',NULL,'1','9998887777','2007-11-08 13:06:02','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34588,'10.0.0.10','MANUAL_B','XFER',132241,1194556260.9193699,'M1108130632000132241',NULL,'1','9998887777','2007-11-08 13:06:32','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34589,'10.0.0.10','MANUAL_B','XFER',173174,1194556005.9189301,'M1108130645000173174',NULL,'1','9998887777','2007-11-08 13:06:45','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34590,'10.0.0.10','MANUAL_B','XFER',151101,1194556012.9189601,'M1108130652000151101',NULL,'1','9998887777','2007-11-08 13:06:52','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34591,'10.0.0.10','MANUAL_B','XFER',173175,1194556036.9190099,'M1108130715000173175',NULL,'1','9998887777','2007-11-08 13:07:15','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34592,'10.0.0.10','MANUAL_B','XFER',173176,1194556071.9190600,'M1108130751000173176',NULL,'1','9998887777','2007-11-08 13:07:51','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34593,'10.0.0.10','MANUAL_B','XFER',119051,1194556084.9190900,'M1108130803000119051',NULL,'1','9998887777','2007-11-08 13:08:03','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34594,'10.0.0.10','MANUAL_B','XFER',173177,1194556085.9191201,'M1108130805000173177',NULL,'1','9998887777','2007-11-08 13:08:05','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34595,'10.0.0.10','MANUAL_B','XFER',173178,1194556131.9191999,'M1108130850000173178',NULL,'1','9998887777','2007-11-08 13:08:50','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34596,'10.0.0.10','MANUAL_B','XFER',173179,1194556143.9192300,'M1108130903000173179',NULL,'1','9998887777','2007-11-08 13:09:03','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34598,'10.0.0.10','MANUAL_B','XFER',173180,1194556222.9193201,'M1108131022000173180',NULL,'1','9998887777','2007-11-08 13:10:22','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34599,'10.0.0.10','MANUAL_B','XFER',132241,1194556260.9193699,'M1108131100000132241',NULL,'1','9998887777','2007-11-08 13:11:00','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34600,'10.0.0.10','MANUAL_B','XFER',173181,1194556265.9194601,'M1108131104000173181',NULL,'1','9998887777','2007-11-08 13:11:04','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34601,'10.0.0.10','MANUAL_B','XFER',173181,1194556265.9194601,'M1108131104000173181',NULL,'1','9998887777','2007-11-08 13:11:04','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34602,'10.0.0.10','MANUAL_B','XFER',173181,1194556265.9194601,'M1108131105000173181',NULL,'1','9998887777','2007-11-08 13:11:05','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34606,'10.0.0.10','MANUAL_B','XFER',139141,1194556423.9196701,'M1108131343000139141',NULL,'1','9998887777','2007-11-08 13:13:43','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34604,'10.0.0.10','MANUAL_B','XFER',173183,1194556355.9195399,'M1108131235000173183',NULL,'1','9998887777','2007-11-08 13:12:35','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34605,'10.0.0.10','MANUAL_B','XFER',173184,1194556386.9195900,'M1108131306000173184',NULL,'1','9998887777','2007-11-08 13:13:06','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34615,'10.0.0.10','MANUAL_B','XFER',124719,1194556659.9199700,'M1108131739000124719',NULL,'1','9998887777','2007-11-08 13:17:39','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34608,'10.0.0.10','MANUAL_B','XFER',136955,1194556476.9197400,'M1108131436000136955',NULL,'1','9998887777','2007-11-08 13:14:36','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34609,'10.0.0.10','MANUAL_B','XFER',173186,1194556521.9197800,'M1108131520000173186',NULL,'1','9998887777','2007-11-08 13:15:20','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34610,'10.0.0.10','MANUAL_B','XFER',81517,1194556522.9198101,'M1108131522000081517',NULL,'1','9998887777','2007-11-08 13:15:22','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34611,'10.0.0.10','MANUAL_B','XFER',151019,1194556589.9198401,'M1108131629000151019',NULL,'1','9998887777','2007-11-08 13:16:29','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34612,'10.0.0.10','MANUAL_B','XFER',136023,1194556603.9198699,'M1108131643000136023',NULL,'1','9998887777','2007-11-08 13:16:43','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34613,'10.0.0.10','MANUAL_B','XFER',150968,1194556614.9198999,'M1108131654000150968',NULL,'1','9998887777','2007-11-08 13:16:54','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34614,'10.0.0.10','MANUAL_B','XFER',151082,1194556638.9199300,'M1108131718000151082',NULL,'1','9998887777','2007-11-08 13:17:18','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34616,'10.0.0.10','MANUAL_B','XFER',173187,1194557045.9204800,'M1108131756000173187',NULL,'1','9998887777','2007-11-08 13:17:56','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34618,'10.0.0.10','MANUAL_B','XFER',173189,1194556707.9200499,'M1108131827000173189',NULL,'1','9998887777','2007-11-08 13:18:27','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34619,'10.0.0.10','MANUAL_B','XFER',135915,1194556710.9200799,'M1108131830000135915',NULL,'1','9998887777','2007-11-08 13:18:30','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34620,'10.0.0.10','MANUAL_B','XFER',128583,1194556763.9201200,'M1108131923000128583',NULL,'1','9998887777','2007-11-08 13:19:23','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34630,'10.0.0.10','MANUAL_B','XFER',173187,1194557045.9204800,'M1108132405000173187',NULL,'1','9998887777','2007-11-08 13:24:05','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34623,'10.0.0.10','MANUAL_B','XFER',173192,1194556799.9202001,'M1108131959000173192',NULL,'1','9998887777','2007-11-08 13:19:59','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34622,'10.0.0.10','MANUAL_B','XFER',173191,1194556783.9201701,'M1108131943000173191',NULL,'1','9998887777','2007-11-08 13:19:43','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34624,'10.0.0.10','MANUAL_B','XFER',136990,1194556883.9202499,'M1108132122000136990',NULL,'1','9998887777','2007-11-08 13:21:22','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34625,'10.0.0.10','MANUAL_B','XFER',151035,1194556883.9202800,'M1108132122000151035',NULL,'1','9998887777','2007-11-08 13:21:22','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34626,'10.0.0.10','MANUAL_B','XFER',136033,1194556938.9203300,'M1108132218000136033',NULL,'1','9998887777','2007-11-08 13:22:18','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34627,'10.0.0.10','MANUAL_B','XFER',132175,1194556961.9203601,'M1108132241000132175',NULL,'1','9998887777','2007-11-08 13:22:41','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34628,'10.0.0.10','MANUAL_B','XFER',173193,1194556993.9204099,'M1108132312000173193',NULL,'1','9998887777','2007-11-08 13:23:12','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34629,'10.0.0.10','MANUAL_B','XFER',128590,1194556994.9204400,'M1108132314000128590',NULL,'1','9998887777','2007-11-08 13:23:14','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34631,'10.0.0.10','MANUAL_B','XFER',173194,1194557102.9205699,'M1108132502000173194',NULL,'1','9998887777','2007-11-08 13:25:02','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34632,'10.0.0.10','MANUAL_B','XFER',128593,1194557592.9210000,'M1108132519000128593',NULL,'1','9998887777','2007-11-08 13:25:19','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34633,'10.0.0.10','MANUAL_B','XFER',173195,1194557200.9206300,'M1108132640000173195',NULL,'1','9998887777','2007-11-08 13:26:40','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34634,'10.0.0.10','MANUAL_B','XFER',173196,1194557227.9206901,'M1108132706000173196',NULL,'1','9998887777','2007-11-08 13:27:06','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34635,'10.0.0.10','MANUAL_B','XFER',152829,1194557232.9207399,'M1108132712000152829',NULL,'1','9998887777','2007-11-08 13:27:12','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34636,'10.0.0.10','MANUAL_B','XFER',173197,1194557263.9207699,'M1108132743000173197',NULL,'1','9998887777','2007-11-08 13:27:43','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34637,'10.0.0.10','MANUAL_B','XFER',151044,1194557354.9208200,'M1108132914000151044',NULL,'1','9998887777','2007-11-08 13:29:14','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34638,'10.0.0.10','MANUAL_B','XFER',128593,1194557592.9210000,'M1108132956000128593',NULL,'1','9998887777','2007-11-08 13:29:56','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34639,'10.0.0.10','MANUAL_B','XFER',173198,1194557416.9208901,'M1108133016000173198',NULL,'1','9998887777','2007-11-08 13:30:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34640,'10.0.0.10','MANUAL_B','XFER',173199,1194558680.9225800,'M1108133033000173199',NULL,'1','9998887777','2007-11-08 13:30:33','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34641,'10.0.0.10','MANUAL_B','XFER',128593,1194557592.9210000,'M1108133311000128593',NULL,'1','9998887777','2007-11-08 13:33:11','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34649,'10.0.0.10','MANUAL_B','XFER',173205,1194557883.9212699,'M1108133803000173205',NULL,'1','9998887777','2007-11-08 13:38:03','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34643,'10.0.0.10','MANUAL_B','XFER',173201,1194557705.9210701,'M1108133504000173201',NULL,'1','9998887777','2007-11-08 13:35:04','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34644,'10.0.0.10','MANUAL_B','XFER',151055,1194557729.9210999,'M1108133529000151055',NULL,'1','9998887777','2007-11-08 13:35:29','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34645,'10.0.0.10','MANUAL_B','XFER',153705,1194557756.9211299,'M1108133556000153705',NULL,'1','9998887777','2007-11-08 13:35:56','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34646,'10.0.0.10','DRV_B','XFER',173202,NULL,'M1108133627000173202',NULL,'1','9998887777','2007-11-08 13:36:27','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34647,'10.0.0.10','DRV_B','XFER',173203,NULL,'M1108133709000173203',NULL,'1','9998887777','2007-11-08 13:37:09','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34648,'10.0.0.10','MANUAL_B','XFER',173204,1194557836.9212201,'M1108133716000173204',NULL,'1','9998887777','2007-11-08 13:37:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34650,'10.0.0.10','DRV_B','XFER',173202,NULL,'M1108133831000173202',NULL,'1','9998887777','2007-11-08 13:38:31','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34651,'10.0.0.10','MANUAL_B','XFER',155864,1194557926.9213400,'M1108133846000155864',NULL,'1','9998887777','2007-11-08 13:38:46','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34652,'10.0.0.10','MANUAL_B','XFER',151068,1194557995.9214101,'M1108133955000151068',NULL,'1','9998887777','2007-11-08 13:39:55','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34653,'10.0.0.10','MANUAL_B','XFER',173206,1194558033.9214399,'M1108134033000173206',NULL,'1','9998887777','2007-11-08 13:40:33','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34654,'10.0.0.10','DRV_B','XFER',10131,NULL,'M1108134036000010131',NULL,'1','9998887777','2007-11-08 13:40:36','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34655,'10.0.0.10','MANUAL_B','XFER',173207,1194558052.9214900,'M1108134051000173207',NULL,'1','9998887777','2007-11-08 13:40:51','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34656,'10.0.0.10','DRV_B','XFER',173208,NULL,'M1108134124000173208',NULL,'1','9998887777','2007-11-08 13:41:24','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34657,'10.0.0.10','MANUAL_B','XFER',57712,1194558089.9215801,'M1108134129000057712',NULL,'1','9998887777','2007-11-08 13:41:29','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34658,'10.0.0.10','MANUAL_B','XFER',79381,1194558095.9216101,'M1108134135000079381',NULL,'1','9998887777','2007-11-08 13:41:35','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34659,'10.0.0.10','MANUAL_B','XFER',151005,1194558125.9216599,'M1108134205000151005',NULL,'1','9998887777','2007-11-08 13:42:05','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34660,'10.0.0.10','MANUAL_B','XFER',128561,1194558138.9216900,'M1108134218000128561',NULL,'1','9998887777','2007-11-08 13:42:18','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34661,'10.0.0.10','MANUAL_B','XFER',173209,1194558138.9217401,'M1108134218000173209',NULL,'1','9998887777','2007-11-08 13:42:18','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34662,'10.0.0.10','MANUAL_B','XFER',151071,1194558183.9217701,'M1108134303000151071',NULL,'1','9998887777','2007-11-08 13:43:03','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34663,'10.0.0.10','MANUAL_B','XFER',80493,1194558189.9217999,'M1108134309000080493',NULL,'1','9998887777','2007-11-08 13:43:09','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34664,'10.0.0.10','MANUAL_B','XFER',173210,1194558206.9218500,'M1108134326000173210',NULL,'1','9998887777','2007-11-08 13:43:26','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34665,'10.0.0.10','MANUAL_B','XFER',173211,NULL,'M1108134403000173211',NULL,'1','9998887777','2007-11-08 13:44:03','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34666,'10.0.0.10','MANUAL_B','XFER',173212,1194558647.9225500,'M1108134416000173212',NULL,'1','9998887777','2007-11-08 13:44:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34667,'10.0.0.10','MANUAL_B','XFER',155046,1194558275.9219601,'M1108134435000155046',NULL,'1','9998887777','2007-11-08 13:44:35','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34668,'10.0.0.10','MANUAL_B','XFER',173213,1194558289.9220099,'M1108134449000173213',NULL,'1','9998887777','2007-11-08 13:44:49','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34669,'10.0.0.10','MANUAL_B','XFER',17486,1194558312.9220400,'M1108134511000017486',NULL,'1','9998887777','2007-11-08 13:45:11','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34670,'10.0.0.10','MANUAL_B','XFER',128559,1194558323.9220700,'M1108134523000128559',NULL,'1','9998887777','2007-11-08 13:45:23','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34671,'10.0.0.10','MANUAL_B','XFER',154505,1194558348.9221001,'M1108134548000154505',NULL,'1','9998887777','2007-11-08 13:45:48','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34672,'10.0.0.10','MANUAL_B','XFER',173214,1194558356.9221301,'M1108134555000173214',NULL,'1','9998887777','2007-11-08 13:45:55','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34673,'10.0.0.10','MANUAL_B','XFER',151046,1194558417.9222200,'M1108134603000151046',NULL,'1','9998887777','2007-11-08 13:46:03','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34674,'10.0.0.10','MANUAL_B','XFER',154506,1194558390.9221900,'M1108134629000154506',NULL,'1','9998887777','2007-11-08 13:46:29','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34675,'10.0.0.10','MANUAL_B','XFER',151046,1194558417.9222200,'M1108134657000151046',NULL,'1','9998887777','2007-11-08 13:46:57','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34676,'10.0.0.10','MANUAL_B','XFER',173215,1194558442.9222801,'M1108134721000173215',NULL,'1','9998887777','2007-11-08 13:47:21','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34677,'10.0.0.10','MANUAL_B','XFER',139126,1194558447.9223101,'M1108134726000139126',NULL,'1','9998887777','2007-11-08 13:47:26','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34680,'10.0.0.10','MANUAL_B','XFER',141057,1194558567.9224601,'M1108134926000141057',NULL,'1','9998887777','2007-11-08 13:49:26','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34679,'10.0.0.10','MANUAL_B','XFER',173217,1194558479.9223599,'M1108134759000173217',NULL,'1','9998887777','2007-11-08 13:47:59','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34681,'10.0.0.10','MANUAL_B','XFER',173218,1194558602.9224999,'M1108135002000173218',NULL,'1','9998887777','2007-11-08 13:50:02','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34685,'10.0.0.10','MANUAL_B','XFER',136003,1194558749.9226601,'M1108135228000136003',NULL,'1','9998887777','2007-11-08 13:52:28','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34683,'10.0.0.10','MANUAL_B','XFER',173212,1194558647.9225500,'M1108135047000173212',NULL,'1','9998887777','2007-11-08 13:50:47','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34684,'10.0.0.10','MANUAL_B','XFER',173199,1194558680.9225800,'M1108135120000173199',NULL,'1','9998887777','2007-11-08 13:51:20','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34686,'10.0.0.10','MANUAL_B','XFER',136003,1194558749.9226601,'M1108135229000136003',NULL,'1','9998887777','2007-11-08 13:52:29','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34687,'10.0.0.10','MANUAL_B','XFER',173220,1194558821.9226899,'M1108135341000173220',NULL,'1','9998887777','2007-11-08 13:53:41','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34688,'10.0.0.10','MANUAL_B','XFER',173221,NULL,'M1108135516000173221',NULL,'1','9998887777','2007-11-08 13:55:16','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34689,'10.0.0.10','MANUAL_B','XFER',173222,1194558950.9227901,'M1108135549000173222',NULL,'1','9998887777','2007-11-08 13:55:49','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34690,'10.0.0.10','MANUAL_B','XFER',136038,1194559056.9228401,'M1108135736000136038',NULL,'1','9998887777','2007-11-08 13:57:36','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34691,'10.0.0.10','MANUAL_B','XFER',128568,1194559061.9228699,'M1108135740000128568',NULL,'1','9998887777','2007-11-08 13:57:40','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34692,'10.0.0.10','MANUAL_B','XFER',158320,1194559154.9229300,'M1108135914000158320',NULL,'1','9998887777','2007-11-08 13:59:14','OUT','START','2007-11-09 14:54:54','NONE'); INSERT INTO `vicidial_auto_calls` VALUES (34693,'10.0.0.10','MANUAL_B','XFER',151079,1194559200.9229801,'M1108140000000151079',NULL,'1','9998887777','2007-11-08 14:00:00','OUT','START','2007-11-09 14:54:54','NONE'); /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

by **bobbymc** » Fri Nov 09, 2007 11:59 am

if im not wrong the reaosn why is because in your asterisk dialplan you do not have the hangup agi and thats why it wont get cleaned up.. look at the dialplan the manual calls make and make sure you have this in it

exten => h,1,DeadAGI(agi://127.0.0.1:4577/call_log)
exten => h,2,DeadAGI(agi://127.0.0.1:4577/VD_hangup--HVcause ... EBUG-----${HANGUPCAUSE}-----${DIALSTATUS}-----${DIALEDTIME}-----${ANSWEREDTIME}))

by **artimus** » Fri Nov 09, 2007 12:04 pm

i have

Code: Select all: exten => h,1,DeadAGI(agi://127.0.0.1:4577/call_log) exten => h,2,DeadAGI(agi://127.0.0.1:4577/VD_hangup--HVcauses--PRI-----NODEBUG-----${HANGUPCAUSE}-----${DIALSTATUS}-----${DIALEDTIME}-----${ANSWEREDTIME}))

by **artimus** » Sat Nov 10, 2007 10:15 am

Any ideas?

Being that manual calls are initiated by the agent, once the call is actually dialed is there any need to keep it in auto_calls? In otherwords can always safely delete all manual campaign entries that are older then one minute?

by **mflorell** » Sun Nov 11, 2007 1:31 am

do you have more than one context in your dialplan?

can you post the output from the agiout.2007... file for one of these calls being hungup(call_log/VDhangup stage)?

by **artimus** » Tue Nov 13, 2007 10:14 am

As far as the context goes, we haven't yet needed to stray from the scratch install.

Unfortunately I will have to wait for it to fill up today. I was out yesterday and don't know what time it was truncated.

by **debtresolve** » Tue Nov 13, 2007 4:47 pm

I'm having the same problem, I'm able to get the dialer to make calls again by running:
DELETE FROM vicidial_auto_calls WHERE status = 'XFER' AND channel IS NULL AND last_update_time < CURRENT_TIMESTAMP - INTERVAL 5 MINUTE

this way I'm only deleting calls that I know are "stale".

On a test box I was able to reproduce the problem by activating the ALT # dialing, and after a (auto dial) phone call trying to call the alt phone number.
After dispositioning the lead there was 1 record in the auto_calls table (I was the only one working on this vici):
+--------------+------------+-------------+--------+---------+--------------------+----------------------+---------+------------+--------------+---------------------+-----------+-------+---------------------+----------+
| auto_call_id | server_ip | campaign_id | status | lead_id | uniqueid | callerid | channel | phone_code | phone_number | call_time | call_type | stage | last_update_time | alt_dial |
+--------------+------------+-------------+--------+---------+--------------------+----------------------+---------+------------+--------------+---------------------+-----------+-------+---------------------+----------+
| 36 | 10.0.0.248 | 100 | XFER | 117 | 1194985826.1900001 | M1113123026000000117 | NULL | 1 | 9149495500 | 2007-11-13 12:30:26 | OUT | START | 2007-11-13 12:30:27 | NONE |
+--------------+------------+-------------+--------+---------+--------------------+----------------------+---------+------------+--------------+---------------------+-----------+-------+---------------------+----------+

Deleting this record helps to get Vici going again.

It seems to me that "manual calls" don't get cleaned up from the auto_calls table, what exactly does the auto_calls table do? and why are manual calls even inserted into the AUTO_calls table?

by **artimus** » Wed Nov 14, 2007 2:34 pm

Code: Select all: INSERT INTO `vicidial_auto_calls` VALUES (27977,'10.50.210.11','MANUAL_B','XFER', 151048,1195066032.7600999,'M1114104416000151048',NULL, '1','479494****','2007-11-14 10:44:16','OUT','START','2007-11-14 18:47:13','NONE');

I made a copy of the auto_calls and the agiout. I couldn't match anything in the record above to anything in the agiout log. We actually don't have anything between 10:34 and 10:58, so this call looks like it wasn't logged.

We noticed that the last_update_time for this record is 8 hours in the future (the correct gmt time). last_update_time i believe is supposed to be localtime?

Btw: this was a box that was built with EST timezone, and manually converted to the PST timezone. My first thought was another timezone problem, but the last_update_time is in the future even for new york..

by **debtresolve** » Wed Nov 14, 2007 4:07 pm

I just noticed that the call_log table only holds records with a caller_code starting with V (did I get it right that V is for "auto calls" and M for Manual calls?) because of this and because of the fact that manual calls in the auto_calls table just don't seem to change status from 'XFER' the AST_VDauto_dial.pl doesn't seem to be able to clean up these records.

Does anyone have an idea how to fix this? (and if I'm looking in the right direction)

by **mflorell** » Thu Nov 15, 2007 12:24 am

There must be something else going on because I cannot duplicate this problem on my systems.

by **ramindia** » Thu Nov 15, 2007 12:28 am

Hi

Did happend any time unexpected power off this server
or power failures, or hunged server due to some hardware problems.

i found this some time back , my calls keep get stuck at auto_calls like this.

but later i fixed my mysql and i am keep getting this kind of problem.

after i redo everything from scratch i have fixed the problem.

may this could help you.

ram

by **artimus** » Thu Nov 15, 2007 3:15 pm

we did have a power outage.. We noticed that the last_update_time is now working properly without making any changes, not sure why though..

However the manual calls still get stuck. Could this be caused by the campaign attempting to be Blended? I would assume that the blended functionality would just be disabled because the dial level and ratio are not sufficient for a blended campaign?

by **mflorell** » Thu Nov 15, 2007 3:58 pm

You should not be doing blended with MANUAL dialing. That causes some problems

by **rcphq** » Fri Dec 07, 2007 3:52 pm

_sigh_
reviving this topic ?

i keep getting this issue @work, the hangup agi is as was stated here,
the problem seems to be pretty random, some days it happens a lot, another day it goes unnoticed.
deleting the ones with status = XFER and channel = NULL seemed to do it for us (we used to brute force delete all the content from the auto_calls).
i could set this up as a cron (people seem to have do it? any help this direction) but it some how seems like something that shouldnt happen.

the campaign is blended AND has manual calls, im kinda new at this,
mflorell: you seem to point that this can be the cause of 'problemss', what problems? could this be the cause? how could this be fixed?

by **mflorell** » Sat Dec 08, 2007 2:12 pm

What are the campaign settings for dial_method and dial_level?

by **rcphq** » Mon Dec 10, 2007 7:52 am

mflorell wrote:What are the campaign settings for dial_method and dial_level?

dial_method => RATIO
auto dial level => 1.3
this settings are sometimes changed a bit to look for improvement, but theyve stayed like this for a while and still cause the problem after some time

by **mflorell** » Mon Dec 10, 2007 8:49 pm

Usual causes for this:
- Load is too high or spiking
- number dialed is not allowable within dialplan
- agent clicks too rapidly on links in succession

by **rcphq** » Mon Dec 10, 2007 9:02 pm

mflorell wrote:Usual causes for this:
- Load is too high or spiking
- number dialed is not allowable within dialplan
- agent clicks too rapidly on links in succession

ill watch the users tomorrow to see what i get, i hope we fix this, somedays it doesnt happen, but other days it happens a lot... seems weird

by **okli** » Tue Dec 11, 2007 3:17 pm

If I may add- in our case vicidial_auto_calls was not cleared up because we didn't have in our dial plan.
exten =>_NXXXXXXXXX,1,AGI(agi://127.0.0.1:4577/call_log)

http://www.eflo.net/VICIDIALforum/viewtopic.php?t=4712

by **rcphq** » Tue Dec 11, 2007 4:33 pm

okli wrote:If I may add- in our case vicidial_auto_calls was not cleared up because we didn't have in our dial plan.
exten =>_NXXXXXXXXX,1,AGI(agi://127.0.0.1:4577/call_log)

http://www.eflo.net/VICIDIALforum/viewtopic.php?t=4712

im making this change and the parentesis one in the linked topic, will post results. thanks for the help!

by **okli** » Tue Dec 11, 2007 9:22 pm

I think I found another reason when vicidial_auto_calls gets junked up- if you manually dial an invalid number, which is not in your dial plan, this number gets stuck there. Adding something like this for all calls slipped through

exten => _X.,1,AGI(agi://127.0.0.1:4577/call_log)
exten => _X.,2,Playback(please-contact-tech-supt)
exten => _X.,3,Hangup

fixes it, but is that the way to do it?

Is this line ....1,AGI(agi://127.0.0.1:4577/call_log) supposed to be there for i and t extensions, so if either occurs vicidial knows to remove that call from vicidial_auto_calls?

by **mflorell** » Tue Dec 11, 2007 11:15 pm

That should help with the problem. Let me know if adding it to the other error extensions helps as well and I will add it to the documentation.

by **okli** » Thu Dec 20, 2007 4:34 pm

Since I've added just

Code: Select all: exten => _X.,1,AGI(agi://127.0.0.1:4577/call_log) exten => _X.,2,Playback(please-contact-tech-supt) exten => _X.,3,Hangup

no more junk entrues in vicidial_auto_calls.
We are doing mainly manual calls for now and for more than a week that table seems OK.

by **vkad** » Tue May 29, 2018 12:07 pm

mflorell wrote:That should help with the problem. Let me know if adding it to the other error extensions helps as well and I will add it to the documentation.

I am having the same problem... What and where should I add to my dialplan to catch invalid manual dials???

vicidial.org

Manual dial junks up vicidial_auto_calls

Manual dial junks up vicidial_auto_calls

Getting Closer!

reviving and old topic

Re:

Who is online