Author Topic: QM cann't insert new calls to database  (Read 4412 times)

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
QM cann't insert new calls to database
« on: April 28, 2010, 09:12:45 »
i run QM1.5.5 for a few days,it works well.But from this morning,i found that QM cann't insert any call to databse.I follow the topic(http://queuemetrics.com/faq.jsp#faq-058-qm_not_working),everything looks fine,the database check good,and i can see all of  the quickreport before today.It only cann't insert new record,and the realtime page shows not data,just like the topic says.

the tomcat logs:
Code: [Select]
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466]  Modo SQL - preset: '1' - partition: 'P001'
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466]  - fILE: sql:P001
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466]  - Data da: Wed Apr 28 00:00:00 CST 2010 Data a: Wed Jan 01 01:01:01 CST 2020 Fuso orario: 0 - Ignore QUEUESTARTs: false - Anomalous wait:1000s talk:2000s  - Always logon upaused: false
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466]  - Coda: 8001
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466]  - Coda: 8002
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466]  - Coda: 8005
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466]  - Rewriting of Local/XXX@ext channels
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466] ===== Configurazione oggetto Analizzalog ===========
 File        : sql:P001
 Tst Iniziale: 1272384000
 Tst Finale  : 1577811660
 Tst corrente: 1272438679
 Agenti amm. : [*]
 Code amm.   : [8002, none, 8001, 8005]
 TZ Offset   : 0
 RewrLocal   : true
 RewrLocalQN : false
 ChiudiCB/QSt: false
 Ign QStart  : false
 Ending ch.na: false
 UnpauseLogon: false
 Min Anom Wai: 1000
 Min Anom Tal: 2000
 Server ID   :
====================================================
===-------------- MYSQL extension ---------------===
 Connection  : com.mysql.jdbc.Connection@44eabe
 Partition   : P001
====================================================

2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466] R:AC stats: Mysql fetched 39 in 1 ms (39.000,0 r/s)- File processed 39 (0) in 0 ms (0.0 r/s - 0.0 r ok/s )
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466] Dati odierni: OK: 0 righe - KO: 0 righe
2010-04-28 15:11:19 StandardContext[/queuemetrics][84F04D176F0446B42A9B523B1D58C466] Fine classe it.loway.app.queuemetrics.liveData.realtime
2010-04-28 15:11:19 StandardContext[/queuemetrics]LowayTransactionController: [84F04D176F0446B42A9B523B1D58C466] 201004281511 Tempo totale esecuzione verbo 'qm_realtime2_ds': 9 ms

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: QM cann't insert new calls to database
« Reply #1 on: April 28, 2010, 09:46:49 »
the Queue_log file just fine,it can record the call properly

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: QM cann't insert new calls to database
« Reply #2 on: April 28, 2010, 10:44:15 »
You need to restart qloaderd. Likely your queue_log file was rotated.

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: QM cann't insert new calls to database
« Reply #3 on: April 28, 2010, 11:03:21 »
You are very kind.
i use the /etc/init.d/qloaderd restart
first ,the stop fail start ok,secord the both ok.
after that,the real_time works,but it course a new problem
when i click the quickreport ,it popup a window say:error:multiple selection criterla lead to no agent being selectable,what's the meaning?

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: QM cann't insert new calls to database
« Reply #4 on: April 28, 2010, 11:07:08 »
i relogin in ,it just fine ,and today's data is here,thank you very much

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: QM cann't insert new calls to database
« Reply #5 on: April 29, 2010, 12:42:39 »
when i click the quickreport ,it popup a window say:error:multiple selection criterla lead to no agent being selectable,what's the meaning?

This means you are asking an impossible question, e.g. if you want to filter by Location A and Agent 102 but agent 102 is not a member of Location A. This would lead to a query that leads no results, as no agent is both Agent/102 and  in location A. QM detects this kind of questions and refuses to run.