136
Running QueueMetrics / Re: can't modify the QA for chinese language
« on: June 26, 2010, 07:59:51 »
i have change the field in qa_form,it's ok
QueueMetrics professional call center suite for the Asterisk PBX
News:
Welcome to the new forum!
Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
137
Running QueueMetrics / Mysql's slow queries log
« on: June 26, 2010, 07:28:09 »
Count: 45 Time=12.29s (553s) Lock=0.04s (2s) Rows=1.0 (45), queuemetrics[queuemetrics]@localhost
SELECT max(time_id) FROM queue_log WHERE partition='S' AND verb != 'S'
and the queue_logs has 3814568 records.
How can i optimization
SELECT max(time_id) FROM queue_log WHERE partition='S' AND verb != 'S'
and the queue_logs has 3814568 records.
How can i optimization
138
Running QueueMetrics / Re: Exception starting filter BalancerFilter java.lang.NoClassDefFoundError: org/ap
« on: June 26, 2010, 07:12:55 »
139
Running QueueMetrics / Re: Exception starting filter BalancerFilter java.lang.NoClassDefFoundError: org/ap
« on: June 21, 2010, 12:25:34 »
i may found the problem
when i use ps -aux | grep java,i find three QM start process,when i use kill them all(kill -9), then i back to normal.
when i use ps -aux | grep java,i find three QM start process,when i use kill them all(kill -9), then i back to normal.
140
Running QueueMetrics / Re: can't modify the QA for chinese language
« on: June 21, 2010, 12:23:42 »
And another logs in tomcat's log file
2010-06-21 18:16:56 StandardContext[/queuemetrics][59703F7C604948A84CF6EBC8618C0DDB] Agenti trovati/consentiti: 6/9999
2010-06-21 18:16:56 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211816 Tempo totale esecuzione verbo 'qm_mostra_coda_fast_dyn': 6332 ms
2010-06-21 18:16:56 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] [ERR] Il verbo 'qm_realtime2_ds' richiede una chiave non diponibile all'utente corrente.
2010-06-21 18:16:56 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] 201006211816 Tempo totale esecuzione verbo 'qm_realtime2_ds': 8 ms
2010-06-21 18:17:00 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start': 22 ms
2010-06-21 18:17:00 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start2': 29 ms
2010-06-21 18:17:01 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] [ERR] Il verbo 'qm_realtime2_ds' richiede una chiave non diponibile all'utente corrente.
2010-06-21 18:17:01 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] 201006211817 Tempo totale esecuzione verbo 'qm_realtime2_ds': 7 ms
2010-06-21 18:17:02 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_qa_report_input': 8 ms
2010-06-21 18:17:06 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] [ERR] Il verbo 'qm_realtime2_ds' richiede una chiave non diponibile all'utente corrente.
2010-06-21 18:17:06 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] 201006211817 Tempo totale esecuzione verbo 'qm_realtime2_ds': 7 ms
2010-06-21 18:17:06 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start': 7 ms
2010-06-21 18:17:07 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start2': 33 ms
2010-06-21 18:16:56 StandardContext[/queuemetrics][59703F7C604948A84CF6EBC8618C0DDB] Agenti trovati/consentiti: 6/9999
2010-06-21 18:16:56 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211816 Tempo totale esecuzione verbo 'qm_mostra_coda_fast_dyn': 6332 ms
2010-06-21 18:16:56 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] [ERR] Il verbo 'qm_realtime2_ds' richiede una chiave non diponibile all'utente corrente.
2010-06-21 18:16:56 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] 201006211816 Tempo totale esecuzione verbo 'qm_realtime2_ds': 8 ms
2010-06-21 18:17:00 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start': 22 ms
2010-06-21 18:17:00 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start2': 29 ms
2010-06-21 18:17:01 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] [ERR] Il verbo 'qm_realtime2_ds' richiede una chiave non diponibile all'utente corrente.
2010-06-21 18:17:01 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] 201006211817 Tempo totale esecuzione verbo 'qm_realtime2_ds': 7 ms
2010-06-21 18:17:02 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_qa_report_input': 8 ms
2010-06-21 18:17:06 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] [ERR] Il verbo 'qm_realtime2_ds' richiede una chiave non diponibile all'utente corrente.
2010-06-21 18:17:06 StandardContext[/queuemetrics]LowayTransactionController: [1E689F0527A0DDAEBC62EE465F375DCF] 201006211817 Tempo totale esecuzione verbo 'qm_realtime2_ds': 7 ms
2010-06-21 18:17:06 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start': 7 ms
2010-06-21 18:17:07 StandardContext[/queuemetrics]LowayTransactionController: [59703F7C604948A84CF6EBC8618C0DDB] 201006211817 Tempo totale esecuzione verbo 'qm_start2': 33 ms
141
Running QueueMetrics / Re: can't modify the QA for chinese language
« on: June 21, 2010, 12:22:03 »
i follow the faq,and find two
1.&useUnicode=true&characterEncoding=utf8&characterSetResults=utf8 the & should be & in the web.xml
2.when i use a chinese character,there is a exception
"Errore tecnico nella classe 'it.loway.app.queuemetrics.configurazione.cfg2.ptQAForms'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema DB: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' - at it.loway.tpf.SQL.selectScalare(SQL.java:322) - at it.loway.app.queuemetrics.configurazione.cfg2.ptQAForms.PTValidateRecord(ptQAForms.java:167) - at it.loway.tpf.transaction.db.PagedTransactor.processEditor(PagedTransactor.java:166) - at it.loway.tpf.transaction.db.PagedTransactor.PTProcessVerb(PagedTransactor.java:85) - at it.loway.app.queuemetrics.configurazione.cfg2.ptQAForms.doRun(ptQAForms.java:75) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:255) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:543) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:365) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:217) - 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 -- - "
1.&useUnicode=true&characterEncoding=utf8&characterSetResults=utf8 the & should be & in the web.xml
2.when i use a chinese character,there is a exception
"Errore tecnico nella classe 'it.loway.app.queuemetrics.configurazione.cfg2.ptQAForms'. -- Inner Exception -- - Exception: it.loway.tpf.common.exceptions.TechException - Stack trace: - Problema DB: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' - at it.loway.tpf.SQL.selectScalare(SQL.java:322) - at it.loway.app.queuemetrics.configurazione.cfg2.ptQAForms.PTValidateRecord(ptQAForms.java:167) - at it.loway.tpf.transaction.db.PagedTransactor.processEditor(PagedTransactor.java:166) - at it.loway.tpf.transaction.db.PagedTransactor.PTProcessVerb(PagedTransactor.java:85) - at it.loway.app.queuemetrics.configurazione.cfg2.ptQAForms.doRun(ptQAForms.java:75) - at it.loway.tpf.transaction.servlets.LowayTransactionController.runVerb(LowayTransactionController.java:255) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequest(LowayTransactionController.java:543) - at it.loway.tpf.transaction.servlets.LowayTransactionController.serveRequestWrapper(LowayTransactionController.java:365) - at it.loway.tpf.transaction.servlets.LowayTransactionController.doPost(LowayTransactionController.java:217) - 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 -- - "
142
General Asterisk configuration / Re: A question about QM
« on: June 17, 2010, 16:08:53 »
yes,i think so.
143
Running QueueMetrics / Re: can't modify the QA for chinese language
« on: June 17, 2010, 16:05:55 »
wait for your solution
144
General Asterisk configuration / Re: A question about QM
« on: June 14, 2010, 10:15:41 »
secret？
145
Improving QueueMetrics / Re: Selection of Time for Last x days
« on: June 14, 2010, 10:13:37 »
i mean:a quick link to a defined custom report,example, last 2 day, last 2 day from 9:00 to 9:00
146
Running QueueMetrics / Re: can't modify the QA for chinese language
« on: June 14, 2010, 10:10:58 »
modify, before save 
after save
after save
147
General Asterisk configuration / A question about QM
« on: June 13, 2010, 06:46:45 »
when a call coming,it will add a lot of logs in cdr,like call other agents,because there is a lot of dail event ,how does QM detect which one to log?How does QM be sure a call was abort?
148
Running QueueMetrics / can't modify the QA for chinese language
« on: June 09, 2010, 09:56:41 »
I can't modify the QA for chinese language,it always show ??
149
Improving QueueMetrics / Re: Selection of Time for Last x days
« on: June 09, 2010, 09:51:20 »
why don't you use custom report,it is more useful
By the way,QM may add this feature: custom report link in homepage
By the way,QM may add this feature: custom report link in homepage
150
Improving QueueMetrics / Re: Want a feature
« on: June 09, 2010, 09:40:54 »
ths for your reply，i found it 