Author Topic: Inconsistenancies with Agnt Page  (Read 5138 times)

rgrignon

  • Newbie
  • *
  • Posts: 18
  • Karma: 0
    • View Profile
    • Email
Inconsistenancies with Agnt Page
« on: September 28, 2009, 18:23:23 »
We have been running queuemetrics for a few weeks now and. There seems to be times when the agent page is unusable. When this is happening, there are no commands running between queuemetrics and asterisk.

Once logged into the agent page, If I selected Log In , Pause, Unpause, etc and submit the request, nothing is executed on the asterisk side...

It seem that the only thing that fixes it, is if I restart asterisk which is difficult with a busy call center...

Any assistance with this would be greatly appreciated.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Inconsistenancies with Agnt Page
« Reply #1 on: September 29, 2009, 09:03:55 »
This seems to be a problem with the AMI on the Asterisk side. If QM and Asterisk are on the same box, you could try using call-files instead. Or you could try putting an AMI proxy in between, so that Asterisk only sees one long-lived connection.

rgrignon

  • Newbie
  • *
  • Posts: 18
  • Karma: 0
    • View Profile
    • Email
Re: Inconsistenancies with Agnt Page
« Reply #2 on: October 01, 2009, 22:45:55 »
How would I do that?

Also is there a way to reestablish the connection without restarting asterisk?


rgrignon

  • Newbie
  • *
  • Posts: 18
  • Karma: 0
    • View Profile
    • Email
Re: Inconsistenancies with Agnt Page
« Reply #3 on: October 01, 2009, 22:53:01 »
Here is an error I tailed while trying to login:

2009-10-01 15:51:53 StandardContext[/queuemetrics][7D1A3A4705BD951A72E0F0D478CDC71B]  **** FILE/DB ACCESS ERROR ***
-- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
Stack trace:
Eccezione di I/O: java.io.FileNotFoundException:  (No such file or directory)
        at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLog.loadLogInfo_fromFile(AnalizzaLog.java:352)
        at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLog.loadAttivitaAgente(AnalizzaLog.java:559)
        at it.loway.app.queuemetrics.liveData.agentLive.doRun(agentLive.java:166)
        at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source)
        at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source)
        at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
        at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
        at java.lang.Thread.run(Thread.java:595)
-- End Inner Exception --

2009-10-01 15:51:53 StandardContext[/queuemetrics]LowayTransactionController: [7D1A3A4705BD951A72E0F0D478CDC71B] [ERR] The file   does not exist

rgrignon

  • Newbie
  • *
  • Posts: 18
  • Karma: 0
    • View Profile
    • Email
Re: Inconsistenancies with Agnt Page
« Reply #4 on: October 01, 2009, 23:05:25 »
Here is something I noticed in qloaderd.log

Notice that the heartbeat stopped after 6:54:31 Then notice how the time jumped ahead of time at 16:27:39... My time is in sync and I have not had any problems with sync between queuemetrics and mysql

|Thu Oct  1 06:24:29 2009|Heart is still beating... Imported: 10805 lines.
 |Thu Oct  1 06:39:30 2009|Heart is still beating... Imported: 10805 lines.
 |Thu Oct  1 06:54:31 2009|Heart is still beating... Imported: 10805 lines.
 |Thu Oct  1 07:26:35 2009|Loaded 10900 lines so far...
 |Thu Oct  1 07:56:20 2009|Loaded 11000 lines so far...
 |Thu Oct  1 08:10:55 2009|Loaded 11100 lines so far...
 |Thu Oct  1 08:23:29 2009|Loaded 11200 lines so far...
 |Thu Oct  1 08:39:49 2009|Loaded 11300 lines so far...
 |Thu Oct  1 08:58:50 2009|Loaded 11400 lines so far...
 |Thu Oct  1 09:15:41 2009|Loaded 11500 lines so far...
 |Thu Oct  1 09:28:02 2009|Loaded 11600 lines so far...
 |Thu Oct  1 09:40:14 2009|Loaded 11700 lines so far...
 |Thu Oct  1 09:53:50 2009|Loaded 11800 lines so far...
 |Thu Oct  1 10:01:42 2009|Loaded 11900 lines so far...
 |Thu Oct  1 10:12:41 2009|Loaded 12000 lines so far...
 |Thu Oct  1 10:27:25 2009|Loaded 12100 lines so far...
 |Thu Oct  1 10:41:17 2009|Loaded 12200 lines so far...
 |Thu Oct  1 10:56:00 2009|Loaded 12300 lines so far...
 |Thu Oct  1 11:07:51 2009|Loaded 12400 lines so far...
 |Thu Oct  1 11:20:42 2009|Loaded 12500 lines so far...
 |Thu Oct  1 11:34:39 2009|Loaded 12600 lines so far...
 |Thu Oct  1 11:44:19 2009|Loaded 12700 lines so far...
 |Thu Oct  1 11:55:02 2009|Loaded 12800 lines so far...
 |Thu Oct  1 12:04:17 2009|Loaded 12900 lines so far...
 |Thu Oct  1 12:15:42 2009|Loaded 13000 lines so far...
 |Thu Oct  1 12:25:12 2009|Loaded 13100 lines so far...
 |Thu Oct  1 12:37:57 2009|Loaded 13200 lines so far...
 |Thu Oct  1 12:52:38 2009|Loaded 13300 lines so far...
 |Thu Oct  1 13:11:23 2009|Loaded 13400 lines so far...
 |Thu Oct  1 13:29:09 2009|Loaded 13500 lines so far...
 |Thu Oct  1 13:46:01 2009|Loaded 13600 lines so far...
 |Thu Oct  1 14:04:44 2009|Loaded 13700 lines so far...
 |Thu Oct  1 14:18:39 2009|Loaded 13800 lines so far...
 |Thu Oct  1 14:36:36 2009|Loaded 13900 lines so far...
 |Thu Oct  1 14:51:55 2009|Loaded 14000 lines so far...
 |Thu Oct  1 15:08:47 2009|Loaded 14100 lines so far...
 |Thu Oct  1 16:27:39 2009|Heart is still beating... Imported: 14137 lines.
 |Thu Oct  1 15:40:26 2009|QueueMetrics MySQL loader - $Revision: 1.17 $

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Inconsistenancies with Agnt Page
« Reply #5 on: October 02, 2009, 12:37:22 »
This looks like an expired session on an agent's page....



Here is an error I tailed while trying to login:

2009-10-01 15:51:53 StandardContext[/queuemetrics][7D1A3A4705BD951A72E0F0D478CDC71B]  **** FILE/DB ACCESS ERROR ***
-- Inner Exception --
Exception: it.loway.tpf.common.exceptions.TechException
Stack trace:
Eccezione di I/O: java.io.FileNotFoundException:  (No such file or directory)
        at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLog.loadLogInfo_fromFile(AnalizzaLog.java:352)
        at it.loway.app.queuemetrics.asterisk.logs.analyzers.AnalizzaLog.loadAttivitaAgente(AnalizzaLog.java:559)
        at it.loway.app.queuemetrics.liveData.agentLive.doRun(agentLive.java:166)
        at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(Unknown Source)
        at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(Unknown Source)
        at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
        at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
        at java.lang.Thread.run(Thread.java:595)
-- End Inner Exception --

2009-10-01 15:51:53 StandardContext[/queuemetrics]LowayTransactionController: [7D1A3A4705BD951A72E0F0D478CDC71B] [ERR] The file   does not exist


QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Inconsistenancies with Agnt Page
« Reply #6 on: October 02, 2009, 12:38:35 »
You are expected to see an heartbeat only after 15min that the queue_log is idle.


Here is something I noticed in qloaderd.log

Notice that the heartbeat stopped after 6:54:31 Then notice how the time jumped ahead of time at 16:27:39... My time is in sync and I have not had any problems with sync between queuemetrics and mysql

|Thu Oct  1 06:24:29 2009|Heart is still beating... Imported: 10805 lines.
 |Thu Oct  1 06:39:30 2009|Heart is still beating... Imported: 10805 lines.


rgrignon

  • Newbie
  • *
  • Posts: 18
  • Karma: 0
    • View Profile
    • Email
Re: Inconsistenancies with Agnt Page
« Reply #7 on: October 02, 2009, 14:34:55 »
Ok Thanks, but what about this:

 |Thu Oct  1 14:51:55 2009|Loaded 14000 lines so far...
 |Thu Oct  1 15:08:47 2009|Loaded 14100 lines so far...
 |Thu Oct  1 16:27:39 2009|Heart is still beating... Imported: 14137 lines.
 |Thu Oct  1 15:40:26 2009|QueueMetrics MySQL loader - $Revision: 1.17 $

Notice how it is running fine at 15:08:47 but then jumps to 16:27:39 and then back to 15:40:26......

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Inconsistenancies with Agnt Page
« Reply #8 on: October 02, 2009, 18:58:42 »
It looks like the clock of that box is changing a lot. Is it - by chance - a VMWare image?

rgrignon

  • Newbie
  • *
  • Posts: 18
  • Karma: 0
    • View Profile
    • Email
Re: Inconsistenancies with Agnt Page
« Reply #9 on: October 02, 2009, 22:18:38 »
You passed the test on that one :D

I have tried quite a few things to ease the ntpd on VMWare but it still seems to act up

I have a physical server on order but was curious to know if there is anything I can do for the time being if/when this occurs. It seems that when this happens the admin page becomes unresponsive until after the "flawed" date has passed and then starts working again.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Inconsistenancies with Agnt Page
« Reply #10 on: October 03, 2009, 09:56:22 »
We found it to behave better when running with the VmWare tools enabled, but never to full satisfaction - I think there should be a way for it to use the hardware clock, but I never found what....