cid_channels_recent empty

[nextdial]

Hi Guys,
I'm on vicibox 10 (installed from ISO)
Asterisk 16.30.0-vici
Version: 2.14b0.5
SVN Version: 3789
DB Schema Version: 1702
Wan only (Public IP Only)


Manual Dials Work Fine, but not Autodial


I have problem with agi_VDAD_local_optimize.agi

Executing [138368@default:1] AGI("Local/998899XXXXXXXXX@default-0000001d;1", "agi-VDAD_local_optimize.agi,V2260005410000003319") in new stack

1|cid_channels_recent_051091XXXXXX|SHOW TABLES LIKE "cid_channels_recent_051091XXXXXX";
SELECT dest_channel FROM cid_channels_recent_XXXXXX where (caller_id_name = 'V2260005410000003319' or connected_line_name = 'V2260005410000003319' or caller_id_name = 'V2260005410000003319' or connected_line_name = 'V2260005410000003319') and ( linkedid = '1703545541.94' or dest_uniqueid = '1703545541.94' or uniqueid = '1703545541.94') and call_date > '2023-12-26 00:03:43'
NO DestChannel for callid V2260005410000003319|Local/998899XXXXXXXXX@default-0000001d;1!!!

NO DestChannel for callid > i'm supposed to have data in cid_channels_recent_051091XXXXXX but table is empty

1 Agent connected in sip 1188 in conf 8600051

Created MeetMe conference 1023 for conference '8600051'
[Dec 26 00:05:43] -- <SIP/1188-0000001f> Playing 'conf-onlyperson.gsm' (language 'en')



Here my AST_update_AMI2.pl output (supposed to : INSERT IGNORE INTO cid_channels_recent):


2023-12-26 00:20:29
|Channel List:
|total_channels|5
|Channel|ChannelState|ChannelStateDesc|Exten|Priority|Context|CallerIDName|CallerIDNum|ConnectedLineName|ConnectedLineNum|Uniqueid|Linkedid|Application|ApplicationData|BridgeId|AccountCode|Language|Duration|
|SIP/1188-00000000|6|Up|8600051|1|default|1188|1188|<unknown>|<unknown>|1703546404.2|1703546404.2|MeetMe|8600051,F||1188|en|00:00:24|
|SIP/PROVIDER-00000001|5|Ringing|998899XXXXXXXXX|1|trunkinbound|33XXXXXXXXX|33XXXXXXXXX|33XXXXXXXXX|33XXXXXXXXX|1703546404.5|1703546404.3|AppDial|SIP/ring|||en|00:00:24|
|DAHDI/pseudo-1064742716|1|Rsrvd|s|1|default|<unknown>|<unknown>|<unknown>|<unknown>|1703546405.6|1703546404.2|||||en|00:00:24|
|Local/998899XXXXXXXXX@default-00000001;1|5|Ringing|998899XXXXXXXXX|1|default|V2260020040000003321|33XXXXXXXXX|V2260020040000003321|33XXXXXXXXX|1703546404.3|1703546404.3|AppDial2|SIP/ring|||en|00:00:24|
|Local/998899XXXXXXXXX@default-00000001;2|4|Ring|998899XXXXXXXXX|7|default|33176242412|33176242412|V2260020040000003321|33XXXXXXXXX|1703546404.4|1703546404.3|Dial|SIP/33XXXXXXXXX@PROVIDER,,tTo|||en|00:00:24|
5 channels recieved out of 5 reported.|0|

UPDATE server_updater set last_update='2023-12-26 00:20:29' where server_ip='XXX.XXX.XXX.XXX'
marking SIP/1188-00000000 active in db_clients
marking SIP/PROVIDER-00000001 active in db_trunks
marking Local/998899XXXXXXXXX@default-00000001;1 active in db_clients
marking Local/998899XXXXXXXXX@default-00000001;2 active in db_clients
BG_check_stats [100.00|5:5 0|0:0 0|0:0 100.00|2:2 0|1:1]
|no client channels to insert|
|no trunk channels to insert|
|no client channels to delete|
|no trunk channels to delete|

Park Dup Del|DELETE pc1 FROM parked_channels pc1, parked_channels pc2 WHERE pc1.parked_time < pc2.parked_time AND pc1.parked_time <> pc2.parked_time AND pc1.channel = pc2.channel AND pc1.server_ip='XXX.XXX.XXX.XXX' and pc2.server_ip='XXX.XXX.XXX.XXX'|0E0
loop took 2654 microseconds. sleeping for 397346 microseconds to compensate


Trunk is ok ! calls ringing and customers picked up
All my config worked very well same sip trunk with old old vicidial (asterisk 1.8.23.0) without VDAD_local_optimize.agi...


Thanks for your help

[williamconley]

Hi Guys,
I'm on vicibox 10 (installed from ISO)
Asterisk 16.30.0-vici
Version: 2.14b0.5
SVN Version: 3789
DB Schema Version: 1702

Manual Dials Work Fine, but not Autodial

...

All my config worked very well same sip trunk with old old vicidial (asterisk 1.8.23.0) without VDAD_local_optimize.agi...

1) you didn't post your iso installer full version
2) you didn't post your FULL Vicidial version (with build)
3) I suspect you copied your database from the prior server into this one and likely brought the system settings and server tables with you. We generally certify a system, import the DB, and then revert to the "certified system" versions of those two tables as they are version specific and have nothing to do with leads, users, campaigns, etc.