196
Running QueueMetrics / Re: Call Status
« on: September 06, 2013, 15:31:29 »The queue_log is correct but the datatabase has one log line too many: Do you use qloader to upload data to the database?
l.
Our database in Queuelog has this,
mysql> select * from queue_log where call_id = '1376084184.1515690'; +-----------+---------------------+------------+--------------------+-----------+-----------+----------------+-------+--------------------+-------+-------+-------+----------+------------------+
| partition | EntryTime | time_id | call_id | queue | agent | verb | data1 | data2 | data3 | data4 | data5 | serverid | unique_row_count |
+-----------+---------------------+------------+--------------------+-----------+-----------+----------------+-------+--------------------+-------+-------+-------+----------+------------------+
| P001 | 2013-08-09 14:43:59 | 1376084191 | 1376084184.1515690 | project | SIP/10821 | COMPLETEAGENT | 0 | 5 | | | | | 1 |
| P001 | 2013-08-09 14:44:08 | 1376084647 | 1376084184.1515690 | project | SIP/10821 | COMPLETECALLER | 0 | 461 | 1 | | | | 2 |
| P001 | 2013-08-09 14:36:26 | 1376084186 | 1376084184.1515690 | project | SIP/10821 | CONNECT | 0 | 1376084186.1515691 | 0 | | | | 2 |
| P001 | 2013-08-09 14:36:26 | 1376084186 | 1376084184.1515690 | project | NONE | ENTERQUEUE | | anonymous | 1 | | | | 1 |
+-----------+---------------------+------------+--------------------+-----------+-----------+----------------+-------+--------------------+-------+-------+-------+----------+------------------+
4 rows in set (0.06 sec)
In the queue_log file all we have is only this,
1376084186|1376084184.1515690|project|NONE|ENTERQUEUE||anonymous|1
1376084186|1376084184.1515690|project|SIP/10821|CONNECT|0|1376084186.1515691|0
1376084647|1376084184.1515690|project|SIP/10821|COMPLETECALLER|0|461|1

