Queue calls not being added to database

Forums

Hi,

We have setup some queues for our Call Centre and have found only the first call into the queue was added to the database, the others all give the following error

[2017-03-15 10:38:04] WARNING[31494][C-000000df]: func_odbc.c:191 generic_execute: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '' for key 'uniqueid' (80) [2017-03-15 10:38:04] WARNING[31494][C-000000df]: func_odbc.c:199 generic_execute: SQL Exec Direct failed (-1)![call set_recording('', 'queues/G1/2017/03/15/queue-G1-2017-03-15-10-38-04-**********-.wav', '', '', 'queue', '', '**********', 'G1', '', '', '' ,'', '')] [2017-03-15 10:38:04] WARNING[31494][C-000000df]: res_odbc.c:604 ast_odbc_direct_execute: SQL Execute error! Verifying connection to pbxlogs [pbxlogs]... [2017-03-15 10:38:04] WARNING[31494][C-000000df]: func_odbc.c:191 generic_execute: SQL Execute returned an error -1: 23000: [MySQL][ODBC 5.1 Driver][mysqld-5.1.73-log]Duplicate entry '' for key 'uniqueid' (80) [2017-03-15 10:38:04] WARNING[31494][C-000000df]: func_odbc.c:199 generic_execute: SQL Exec Direct failed (-1)![call set_recording('', 'queues/G1/2017/03/15/queue-G1-2017-03-15-10-38-04-**********-.wav', '', '', 'queue', '', '**********', 'G1', '', '', '' ,'', '')] [2017-03-15 10:38:04] ERROR[31494][C-000000df]: func_odbc.c:542 acf_odbc_read: Unable to execute query [call set_recording('', 'queues/G1/2017/03/15/queue-G1-2017-03-15-10-38-04-**********-.wav', '', '', 'queue', '', '**********','G1', '', '', '' ,'', '')]

All calls are still recorded I just can't get to them from the Web GUI I have to go digging through the File System to get them.

Any suggestion would be appreciated

Submitted by thirdlane on Tue, 03/14/2017 Permalink

What version of Thirdlane are you using? Also, is it a multi or single tenant?

Submitted by magixnetworks on Tue, 03/14/2017 Permalink

Hi Alex,

Using 8.0.1.4 single tenant.

To expand on the initial issue it only applies to the call recordings, the actual call it self appears in the CDR but I get no results when checking the recordings for the call even though I can see the recording I'm after in the file system.

Thanks

Submitted by thirdlane on Tue, 03/14/2017 Permalink

Any way we could connect to your server and have a look? We would need ssh and webmin access - please respond to alex at thirdlane.com

Submitted by thirdlane on Tue, 03/14/2017 Permalink

Or you can set higher verbosity and send us Asterisk log file

Submitted by magixnetworks on Wed, 03/15/2017 Permalink

Hi Alex,

My manager Paul has contacted you regarding access to the server :)

Thanks

Submitted by thirdlane on Thu, 03/16/2017 Permalink

Thanks, fix will be in the next release - please confirm if it works for you