Topics

1

MySQL storage and Qloaderd/Uniloader / MySQL error during large queries. Timeout related?

« on: December 17, 2012, 20:23:05 »

We receive the following error in QM when generating a large custom report:

Error (tech) in class 'it.loway.app.queuemetrics.caricamento.caricaCoda'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - - Stack trace: - Problem on DB: Database error: - -- Inner Exception -- - Exception: com.mysql.jdbc.CommunicationsException - Error: - Communications link failure due to underlying exception: - - ** BEGIN NESTED EXCEPTION ** - - java.io.EOFException - MESSAGE: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. - - STACKTRACE: - - java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. - at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997) - at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916) - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) - at com.mysql.jdbc.Connection.execSQL(Connection.java:3277) - at com.mysql.jdbc.Connection.execSQL(Connection.java:3206) - at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232) - at it.loway.tpf.SQL.selectScalare(SQL.java:318) - at it.loway.app.queuemetrics.caricamento.caricaCoda.runDataAnalysis(caricaCoda.java:408) - at it.loway.app.queuemetrics.caricamento.caricaCoda.doRun(caricaCoda.java:83) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:276) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:566) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:387) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:238) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) - at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) - at java.lang.Thread.run(Thread.java:662) - - - ** END NESTED EXCEPTION ** - - - - Last packet sent to the server was 3 ms ago. - Stack trace: - com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: - - ** BEGIN NESTED EXCEPTION ** - - java.io.EOFException - MESSAGE: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. - - STACKTRACE: - - java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. - at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997) - at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2411) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916) - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) - at com.mysql.jdbc.Connection.execSQL(Connection.java:3277) - at com.mysql.jdbc.Connection.execSQL(Connection.java:3206) - at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232) - at it.loway.tpf.SQL.selectScalare(SQL.java:318) - at it.loway.app.queuemetrics.caricamento.caricaCoda.runDataAnalysis(caricaCoda.java:408) - at it.loway.app.queuemetrics.caricamento.caricaCoda.doRun(caricaCoda.java:83) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:276) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:566) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:387) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:238) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) - at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) - at java.lang.Thread.run(Thread.java:662) - - - ** END NESTED EXCEPTION ** - - - - Last packet sent to the server was 3 ms ago. - at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2622) - at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2916) - at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) - at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) - at com.mysql.jdbc.Connection.execSQL(Connection.java:3277) - at com.mysql.jdbc.Connection.execSQL(Connection.java:3206) - at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232) - at it.loway.tpf.SQL.selectScalare(SQL.java:318) - at it.loway.app.queuemetrics.caricamento.caricaCoda.runDataAnalysis(caricaCoda.java:408) - at it.loway.app.queuemetrics.caricamento.caricaCoda.doRun(caricaCoda.java:83) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:276) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:566) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:387) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:238) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) - at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) - at java.lang.Thread.run(Thread.java:662) - -- End Inner Exception -- - - When running: SELECT announcement_duration FROM code_possibili WHERE id_coda = '40' - at it.loway.tpf.SQL.selectScalare(SQL.java:327) - at it.loway.app.queuemetrics.caricamento.caricaCoda.runDataAnalysis(caricaCoda.java:408) - at it.loway.app.queuemetrics.caricamento.caricaCoda.doRun(caricaCoda.java:83) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:276) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:566) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:387) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:238) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) - at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) - at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) - at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) - at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) - at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) - at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) - at java.lang.Thread.run(Thread.java:662) - -- End Inner Exception -- -

We have tried adding "socketTimeout=0" to the JDBC_URL setting in WEB-INF/web.xml, but this hasn't helped.

2

QueueMetrics installation / DB errors after upgrade of Queuemetrics 12.2.4 to 12.10.1

« on: November 09, 2012, 07:43:39 »

I tried upgrading to the latest version of queuemetrics but am encountering errors when trying to upgrade the database. Upon visiting the 'dbtest' site, I'm prompted to upgrade the database. I go through the steps but once they are complete I am asked to upgrade again and again.

Here is the initial error that I get that indicates that we need to upgrade the database:

Java Error: Error DB: Database error: -- Inner Exception -- Exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException Error: Unknown column 'report_to' in 'field list' Stack trace: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'report_to' in 'field list' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3277) at com.mysql.jdbc.Connection.execSQL(Connection.java:3206) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232) at it.loway.tpf.SQL.selectContext(SQL.java:617) at it.loway.app.queuemetrics.jdbcTester.jdbcTester.checkDbTable(jdbcTester.java:324) at it.loway.app.queuemetrics.jdbcTester.jdbcTester.testJdbcConn(jdbcTester.java:223) at it.loway.app.queuemetrics.jdbcTester.dbtestWizard.CheckDatabase(dbtestWizard.java:65) at it.loway.app.queuemetrics.jdbcTester.dbtestWizard.EvaluateCurrentStep(dbtestWizard.java:119) at it.loway.app.queuemetrics.jdbcTester.dbtestWizard.doRun(dbtestWizard.java:204) at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:279) at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:571) at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:390) at it.loway.tpf.transaction.servlets.LowayTransactionController.doGet(LowayTransactionController.java:234) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) -- End Inner Exception -- When running: SELECT #CAMPI# FROM code_possibili LIMIT 1 The required database table 'code_possibili' is missing some fields. Are you updating from a previous version of QM?

There is one strange screen during the upgrade process. It indicates that the upgrade was successful, but then shows that there was in fact an error. Perhaps it is of use:

3

MySQL storage and Qloaderd/Uniloader / Ast Primary & Failover instances w/ QM

« on: October 12, 2012, 21:11:49 »

What is the best way to configure QM to deal with an asterisk primary server and failover server deployment scenario. We were going to have each server write to the same partition, but I'm concerned that the state of the failover server (which has the exact same queues and agents) could conflict with the primary server.

Our main concern is: when our secondary, failover PBX comes up, make the transition look transparent in QM. In other words, if the asterisk master dies and calls start routing to the second, let QM accurately show the secondary state, and then the primary once it comes back up.

Best approach?

4

Running QueueMetrics / Cannot play audio recordings in browser(s)

« on: March 23, 2012, 05:38:10 »

We are unable to play back audio recordings in our browsers. With Chrome and Safari, we simply get a non-clickable audio control or broken Quicktime logo. For Firefox, we can generally play the audio file, but it will be truncated.

We are able to download the files by right clicking and saving. We can even play the downloaded files by opening any one of these browsers.

From what I can tell, this is an issue with the download URL ending in .do, even though a .WAV file is returned. The browser sends headers for an html or xml document, but gets audio/wav in return. I've attached screenshots of the errors that Safari throws in its webkit development console. The error, specifically, is "Resource interpreted as Document but transferred with MIME type audio/wav."

How can we resolve this issue?

5

Scripting QueueMetrics / XML-RPC Realtime calls with multiple queues missing data

« on: December 01, 2011, 06:58:10 »

I am trying to grab data from RTAgentsLoggedIn and RTRiassunto for multiple queues. The problem I'm having is that some of the data for some queues seems to be missing in the response when I make the request for multiple queues at once.

For example, If I make a request with the queue value set to "100", I'll get a full listing of all members in that queue as well as an entry in RTRiassunto with all of the info that is to be expected. If I then make a request for "101", I will get another full, complete block of data.

If I make a request for "100|101", I will not get the same data set back. I'll instead see (in this particular case) only the member listings for 100, and only the RTRiassunto data for 100 as well. I've tried this with a combination of different queues, and it seems to have something to do with the queues themselves. The same queues will always "disappear" in the response when combined. For instance "100|101|102|103" might show 100 and 103, but 101 will again be gone, as will 102.

I've tested this against my script, as well as against a script I found on this forum, which I've provided below. Any help is greatly appreciated!!

Code: [Select]

<?php
    require_once 'XML/RPC.php';
    
    $qm_server = "yourmachine"; // the QueueMetrics server address
    $qm_port = "8080"; // the port QueueMetrics is running on
    $qm_webapp = "queuemetrics"; // the webapp name for QueueMetrics
    
    // set which response blocks we are looking for
    $req_blocks = new XML_RPC_Value(array(
        new XML_RPC_Value("RealtimeDO.RTRiassunto"),
        new XML_RPC_Value("RealtimeDO.RTCallsBeingProc"),
        new XML_RPC_Value("RealtimeDO.RTAgentsLoggedIn")
        ), "array");
        
    // general invocation parameters - see the documentation
    $params = array(
        new XML_RPC_Value("200|300"),
        new XML_RPC_Value("robot"),
        new XML_RPC_Value("robot"),
        new XML_RPC_Value(""),
        new XML_RPC_Value(""),
        $req_blocks
        );
        
    $msg = new XML_RPC_Message('QM.realtime', $params);
    $cli = new XML_RPC_Client("/$qm_webapp/xmlrpc.do", $qm_server, $qm_port);
    
    //$cli->setDebug(1);
    $resp = $cli->send($msg);
    
    if (!$resp) {
        echo 'Communication error: ' . $cli->errstr;
        exit;
    }
    
    if ($resp->faultCode()) {
        echo 'Fault Code: ' . $resp->faultCode() . "\n";
        echo 'Fault Reason: ' . $resp->faultString() . "\n";
    } else {
        $val = $resp->value();
        $blocks = XML_RPC_decode($val);

        // now we print out the details....
        printBlock( "result", $blocks );
        printBlock( "RealtimeDO.RTRiassunto", $blocks );
        printBlock( "RealtimeDO.RTCallsBeingProc", $blocks );
        printBlock( "RealtimeDO.RTAgentsLoggedIn", $blocks );
    }
    
    // output a response block as HTML
    function printBlock( $blockname, $blocks ) {
        echo "Response block: $blockname \n";
        $block = $blocks[$blockname];
        
        for ( $r = 0; $r < sizeof( $block ); $r++ ) {
            echo "\n";
            for ( $c = 0; $c < sizeof( $block[$r] ); $c++ ) {
                echo( $block[$r][$c] . "\t" );
            }
        }
    }
?>

6

Running QueueMetrics / Agents missing from "Answered Calls (for selected queues)" report

« on: July 26, 2011, 11:21:30 »

When I run a custom report on "Answered Calls (for selected queues)" for a particular hour of the day, I'm finding that not all of the agents are being listed. If I look at the "Ans Dt." tab, I see agents answering calls that aren't listed. These calls occur well within the hour and end before the hour is up, so they don't appear to be border cases.

I looked over the configurations for the agents that aren't showing in the report and found no differences between them and the agents that are appearing.

For reference sake, I discovered this problem when using the XML-RPC interface. I then generated a custom report from the web interface as a troubleshooting step and found the same problem there.

Is this a bug? Any help is greatly appreciated!

7

MySQL storage and Qloaderd/Uniloader / MySQL performance issues

« on: May 26, 2011, 00:51:41 »

Just today, we began experiencing MySQL performance issues with our Queuemetrics install. MySQL will jump up to 150-200% CPU in top for 5-15 seconds or so every so often and cause the Queuemetrics web interface to lag greatly. This issue seems to have started roughly two weeks ago and has gradually become more prominent.

I was able to grab the processlist from MySQL during one of the slowdowns.  I've included the output at the bottom of this message. As you can see, the queuemetrics queries are running slowly (up to 9 seconds of execution time). If I check the processlist when the CPU isn't high, there will generally only be a single queuemetrics query, and according to the tomcat logs, they will only take around 100ms to execute.

We did increase the amount of memory available to Java to 512MB. This may have helped marginally.

Has anyone seen anything like this before? How can we solve this performance problem?

Code: [Select]

mysql> show full processlist;
+------+--------------+---------------------+--------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id   | User         | Host                | db           | Command | Time | State        | Info                                                                                                                                                                                                                                                                                                                                                             |
+------+--------------+---------------------+--------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3517 | queuemetrics | 64.207.128.55:57419 | queuemetrics | Sleep   |    6 |              | NULL                                                                                                                                                                                                                                                                                                                                                             |
| 7353 | queuemetrics | localhost           | NULL         | Query   |    0 | NULL         | show full processlist                                                                                                                                                                                                                                                                                                                                            |
| 7411 | queuemetrics | localhost:58330     | queuemetrics | Query   |    9 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1306306800' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , 'q-301'  , '3005'  , '3006'  , 'none'  , '3003'  , '3004'  , '3009'  , '3008' )   ORDER BY time_id ASC , unique_row_count ASC |
| 7412 | queuemetrics | localhost:58331     | queuemetrics | Query   |    7 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1306306800' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , '3000'  , 'none'  , 'q-300' )   ORDER BY time_id ASC , unique_row_count ASC                                                   |
| 7413 | queuemetrics | localhost:58332     | queuemetrics | Query   |    6 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1306306800' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , 'q-301'  , '3005'  , '3006'  , 'none'  , '3003'  , '3004'  , '3009'  , '3008' )   ORDER BY time_id ASC , unique_row_count ASC |
| 7414 | queuemetrics | localhost:58333     | queuemetrics | Query   |    4 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1306306800' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , 'q-301'  , '3005'  , '3006'  , 'none'  , '3003'  , '3004'  , '3009'  , '3008' )   ORDER BY time_id ASC , unique_row_count ASC |
| 7415 | queuemetrics | localhost:58334     | queuemetrics | Query   |    3 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1306306800' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , 'q-301'  , '3005'  , '3006'  , 'none'  , '3003'  , '3004'  , '3009'  , '3008' )   ORDER BY time_id ASC , unique_row_count ASC |
| 7417 | queuemetrics | localhost:58336     | queuemetrics | Query   |    1 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1306306800' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , 'q-301'  , '3005'  , '3006'  , 'none'  , '3003'  , '3004'  , '3008' )   ORDER BY time_id ASC , unique_row_count ASC           |
| 7418 | queuemetrics | localhost:58337     | queuemetrics | Query   |    0 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1306306800' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , '3000'  , 'none'  , 'q-300' )   ORDER BY time_id ASC , unique_row_count ASC                                                   |
+------+--------------+---------------------+--------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
9 rows in set (0.00 sec)


8

QueueMetrics installation / Call recordings not playing in Safari browser

« on: April 19, 2011, 04:57:00 »

When trying to play a call recording in the Safari browser, I'm prompted with a Quicktime logo with a white question mark over it. If I download the audio recording first, it will play fine, even when opened with Safari.

In Firefox, the file plays directly from the website just fine. I believe Chrome has some issues (both of these are on a Mac).

I have a suspicion that this has to do with a MIME type not being set correctly in Tomcat or perhaps an issue with the audio URL having a ".do?<etc...>" extension, but am unsure as to how to fix it.

Any ideas? BTW, we are recording in wav49 format.

Thanks!

9

Running QueueMetrics / Queuemetrics / Java - High CPU Usage

« on: March 02, 2010, 21:23:33 »

I've noticed via top that "java" is consistently using 100-300% CPU.  Is this normal?  It's putting a significant load on our server, which isn't handling a very large call volume.  Here are some numbers to provide perspective:

System:
2x quad core 64 bit processors (in the neighborhood of 2.2Ghz I believe)
3GB memory


Configuration:
asterisk 1.4.29 x64, queuemetrics, freepbx 2.6
Four queues, three with ~12 agents, once with 2 agents
    (sip_additional.conf formatted as SIP/[exten] to reduce cpu overhead associated with freepbx local/[exten] + dialparties.agi)

Usage:
~20 total extensions
~6 queue calls during peak hours
~8 simultaneous calls during peak hours
 
I've included a screenshot of top to show the high CPU usage of "java".  Also to note: I realized that I had about 30GB of java logs from tomcat after running queuemetrics for a little over a month.  Thinking that this level of logging might be slowing the system down, I disabled all logging.  This, unfortunately, did not make a noticeable difference.

Any advice is appreciated.  I can't imagine that queuemetrics actually runs this hot!

10

Running QueueMetrics / realtime.refresh_time not working

« on: December 29, 2009, 20:22:53 »

I tried updating realtime.refresh_time to equal '3' instead of '18'.  I restarted queuemetrics.  The changes do not seem to have taken though.  I found a doc that recommends not going below 10 for this setting, however, I'd still expect a setting of 3 to produce a result.  Am I doing something wrong?

Thanks for your help.

11

Running QueueMetrics / Agents aren't shown any longer on Real Time Reports

« on: December 23, 2009, 21:33:40 »

This problem was not occurring when I first installed Queuemetrics, but is happening now and I'm not sure what changed.

If I select any one of my four queues, the agents that are assigned to the queues in queuemetrics, as well as statically members of the queues in Asterisk, are not shown.

If a call comes in, it is displayed properly.  It will even display the proper name of the agent handling the call (as entered in queuemetrics).  However, the agents that are actually sitting in the queue and ready to take calls are not displayed.

Does anyone have any idea what the problem could be?  I've tried clicking the various 'show agents' buttons at the top of the screen and have not found those to make a difference.  I am not using 'sites' so I don't believe that to be the problem either.

I am using Asterisk 1.4.26 and Queuemetrics 1.5.5.  Both are running on the same machine.

Any help is GREATLY appreciated.  Thanks!

12

Running QueueMetrics / When is a call considered 'Unanswered' in a queue?

« on: May 22, 2009, 20:32:15 »

If no agents are in the queue and the caller is eventually forwarded to a different destination automatically (such as voicemail or an external number), is the 'unanswered calls' counter incremented?

13

Running QueueMetrics / Accessing specific reports without entering username/password

« on: February 27, 2009, 03:08:24 »

Is it possible to view certain reports in Queuemetrics without having to log in?  If not, is there an easy way to POST a username and password when trying to fetch a URL? 

We are developing a web frontend for our call center agents and we'd like to have a link that will pull up a queuemetrics report when clicked.  We want to avoid them having to log in separately and going through the whole process to get it going.

Ideas?

Thanks!

14

Running QueueMetrics / Queuemetrics API

« on: November 07, 2008, 17:05:59 »

Before I purchased Queuemetrics, I would have sworn that Queuemetrics had some sort of API interface that allowed one to pull data and reports from the Queuemetrics database.  I thought there was an entire document regarding this.  I can't seem to find it, or any mention of it now. 

Does an interface like this exist?  Is there documentation for it?  Perhaps I've gone insane finally?

Thanks for your help.

15

Running QueueMetrics / Trouble Using LocalFilesByDay to locate call recording files

« on: October 07, 2008, 20:06:14 »

I'm hoping that someone can assist me with a problem I am having.  Our asterisk instance is storing audio files to subfolders in a folder based on the month/year that the call is placed.  Here is the configuration change we made to configuration.properties:

Code: [Select]

default.monitored_calls=/ast1-recordings/%YY-%MM/

Here is a listing of the directory:

Code: [Select]

[root@stats]# ls -l /ast1-recordings/
total 28
drwxr-xr-x 2  102  103  4096 Oct  7 10:06 2008-10
drwxr-xr-x 2  102  103  4096 Oct  7 10:40 2008-11
drwx------ 2 root root 16384 Aug 27 16:50 lost+found

And

Code: [Select]

[root@stats]# ls -l /ast1-recordings/2008-10/
total 32
-rw-r--r-- 1 102 103 15725 Oct  7 09:46 q3002-20081007-094611-1223397963.2203279.WAV
-rw-r--r-- 1 102 103 14425 Oct  7 10:06 q3002-20081007-100615-1223399168.2203285.WAV

When I go into the queuemetrics call detail screen, it is not showing a link for the audio file.  Before we had this directory structure, it was working fine.  I have tried restarting queuemetrics as well as rebooting the whole machine.  What am I doing wrong?