Thirdlane.com logo

Queue calls not being added to database

Posted by magixnetworks on Tue, 03/14/2017
Forums
Thirdlane platform General Questions

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 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